DBA Data[Home] [Help]

APPS.ICX_REQ_NAVIGATION dependencies on ICX_SEC

Line 21: if (icx_sec.validatesession('ICX_REQS')) then

17: v_0_encrypt varchar2(100);
18: begin
19:
20: -- Check if session is valid
21: if (icx_sec.validatesession('ICX_REQS')) then
22:
23: -- get dcd name
24: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
25:

Line 27: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

23: -- get dcd name
24: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
25:
26: -- set lang code
27: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
28:
29: -- encrypt 0
30: v_0_encrypt := icx_call.encrypt2('0');
31:

Line 664: v_return_template := icx_sec.getID(icx_sec.PV_USER_REQ_TEMPLATE);

660:
661: begin
662:
663: -- get default template
664: v_return_template := icx_sec.getID(icx_sec.PV_USER_REQ_TEMPLATE);
665:
666: v_test := 0;
667:
668: if v_emergency = 'YES' then

Line 855: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

851: v_lang varchar2(5);
852:
853: begin
854: -- set lang code
855: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
856:
857: htp.htmlOpen;
858: htp.headOpen;
859: icx_admin_sig.toolbar(language_code => v_lang);

Line 894: if (icx_sec.validatesession('ICX_REQS')) then

890: v_lang varchar2(5);
891: v_image_name varchar2(32);
892: begin
893:
894: if (icx_sec.validatesession('ICX_REQS')) then
895:
896: -- get lang code
897: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
898:

Line 897: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

893:
894: if (icx_sec.validatesession('ICX_REQS')) then
895:
896: -- get lang code
897: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
898:
899: htp.htmlOpen;
900: htp.headOpen;
901:

Line 1065: if (icx_sec.validatesession(v_function_code)) then

1061: Begin
1062:
1063:
1064: -- Check if session is valid
1065: if (icx_sec.validatesession(v_function_code)) then
1066:
1067: -- decrypt parameters
1068: begin
1069: v_cart_id := icx_call.decrypt2(cart_id);

Line 1079: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1075:
1076: -- Get dcd
1077: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1078: -- get language
1079: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1080: -- get shopper id
1081: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1082: -- get employee_id ( Internal Contect ID )
1083: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

Line 1081: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1077: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1078: -- get language
1079: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1080: -- get shopper id
1081: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1082: -- get employee_id ( Internal Contect ID )
1083: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1084: -- get org id
1085: v_oo_id := icx_sec.getId(icx_sec.PV_ORG_ID);

Line 1083: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

1079: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1080: -- get shopper id
1081: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1082: -- get employee_id ( Internal Contect ID )
1083: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1084: -- get org id
1085: v_oo_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1086:
1087: if ((v_cart_id = -1)) then

Line 1085: v_oo_id := icx_sec.getId(icx_sec.PV_ORG_ID);

1081: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1082: -- get employee_id ( Internal Contect ID )
1083: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1084: -- get org id
1085: v_oo_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1086:
1087: if ((v_cart_id = -1)) then
1088: v_function_code := '-1';
1089: end if;

Line 1137: OPEN getDate(nvl(icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY), 0));

1133: WHERE table_name = 'PO_REQUISITION_HEADERS';
1134:
1135: commit;
1136:
1137: OPEN getDate(nvl(icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY), 0));
1138: FETCH getDate into v_need_by_date;
1139: CLOSE getDate;
1140:
1141: if v_emergency is null or v_emergency = 'NO' then

Line 1377: v_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);

1373:
1374: -- decrypt parameters
1375: v_req_header_id := icx_call.decrypt(p_req_header_id);
1376:
1377: v_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1378:
1379: -- get the preparer,
1380: select preparer_id, authorization_status
1381: into v_preparer_id, v_req_status

Line 1447: --USE ICX_SEC.getID API's here.

1443: where requisition_header_id = v_req_header_id
1444: and rownum = 1;
1445:
1446: -- get the web user based on who the preparer was
1447: --USE ICX_SEC.getID API's here.
1448: -- select web_user_id
1449: -- into v_web_user_id
1450: -- from icx_web_users
1451: -- where internal_contact_id = v_preparer_id;

Line 1453: v_web_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1449: -- into v_web_user_id
1450: -- from icx_web_users
1451: -- where internal_contact_id = v_preparer_id;
1452:
1453: v_web_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1454:
1455: -- check if this is an emergency po
1456: open emergency_check(v_req_header_id);
1457: fetch emergency_check into v_emergency;