16:
17:
18: BEGIN
19:
20: IF icx_sec.validateSession THEN
21: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
22: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
23:
24: htp.htmlOpen;
17:
18: BEGIN
19:
20: IF icx_sec.validateSession THEN
21: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
22: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
23:
24: htp.htmlOpen;
25: htp.title('HTML Template Tags');
48:
49: ak_query_pkg.exec_query( P_PARENT_REGION_APPL_ID => 601,
50: P_PARENT_REGION_CODE => 'ICX_TEMPL_TAG_HDR_R',
51: P_ORDER_BY_CLAUSE => v_order_by,
52: P_RESPONSIBILITY_ID => icx_sec.getID( icx_sec.PV_RESPONSIBILITY_ID ),
53: P_USER_ID => icx_sec.getID( icx_sec.PV_WEB_USER_ID ),
54: P_RETURN_PARENTS => 'T');
55:
56: if ak_query_pkg.g_results_table.COUNT > 0 then
49: ak_query_pkg.exec_query( P_PARENT_REGION_APPL_ID => 601,
50: P_PARENT_REGION_CODE => 'ICX_TEMPL_TAG_HDR_R',
51: P_ORDER_BY_CLAUSE => v_order_by,
52: P_RESPONSIBILITY_ID => icx_sec.getID( icx_sec.PV_RESPONSIBILITY_ID ),
53: P_USER_ID => icx_sec.getID( icx_sec.PV_WEB_USER_ID ),
54: P_RETURN_PARENTS => 'T');
55:
56: if ak_query_pkg.g_results_table.COUNT > 0 then
57:
125: p_copy_temp varchar2(1);
126:
127: BEGIN
128:
129: IF icx_sec.validateSession THEN
130: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
131: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
132:
133: htp.htmlOpen;
126:
127: BEGIN
128:
129: IF icx_sec.validateSession THEN
130: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
131: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
132:
133: htp.htmlOpen;
134: htp.title('HTML Template Tags');