Package gokprxy

FILE NAME..: gokprxy0.sql RELEASE....: 8.5 OBJECT NAME: gokprxy PRODUCT....: GENERAL USAGE......: Use this package to enable dynamic access to Web Tailor
tables with General forms.
COPYRIGHT..: Copyright 2011 SunGard. All rights reserved.

DESCRIPTION:

This package selects rows from Web Tailor tables for the GPAPRXY form.

DESCRIPTION END

Program units

p_wt_query
f_wt_parm
f_get_desc

Types

wt_rec	Define record type used by form
wt_tab

Variables

wt_data

wt_rec

TYPE wt_rec IS RECORD (
  menu_name   VARCHAR2(120),                               
  menu_desc   VARCHAR2(120),                               
  menu_text   VARCHAR2(120),                                   
  menu_url    VARCHAR2(120),                              
  menu_seq    NUMBER(08));

Define record type used by form

wt_tab

TYPE wt_tab IS TABLE OF wt_rec INDEX BY BINARY_INTEGER;

wt_data

wt_data  wt_tab;

p_wt_query

PROCEDURE p_wt_query(wt_data     IN OUT wt_tab,
                     p_retp_code IN VARCHAR2)

f_wt_parm

FUNCTION f_wt_parm(wt_parm IN VARCHAR2) RETURN VARCHAR2

f_get_desc

FUNCTION f_get_desc(p_table             IN VARCHAR2,
                    p_value             IN VARCHAR2,
                    p_override_desc_col IN VARCHAR2 DEFAULT NULL)
  RETURN VARCHAR2