DBA Data[Home] [Help]

APPS.ICX_REQ_COPY_REQ dependencies on ICX_SEC

Line 18: IF (icx_sec.validatesession('ICX_REQS_COPY_REQ')) THEN

14:
15: BEGIN
16:
17: -- Check if session is valid
18: IF (icx_sec.validatesession('ICX_REQS_COPY_REQ')) THEN
19:
20: -- get dcd name
21: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
22:

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

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

Line 154: IF icx_sec.validateSession('ICX_REQS_COPY_REQ') THEN

150: v_help_url VARCHAR2(2000) := NULL;
151: v_language_code VARCHAR2(30) := NULL;
152:
153: BEGIN
154: IF icx_sec.validateSession('ICX_REQS_COPY_REQ') THEN
155:
156: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
157: v_help_url := '/OA_DOC/' || v_language_code ||'/awe' || '/icxhlprq.htm';
158:

Line 156: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

152:
153: BEGIN
154: IF icx_sec.validateSession('ICX_REQS_COPY_REQ') THEN
155:
156: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
157: v_help_url := '/OA_DOC/' || v_language_code ||'/awe' || '/icxhlprq.htm';
158:
159: -- Call the Findpage function to paint the find page. (AK flow)
160:

Line 231: IF icx_sec.validateSession('ICX_REQS_COPY_REQ') THEN

227:
228:
229: BEGIN
230:
231: IF icx_sec.validateSession('ICX_REQS_COPY_REQ') THEN
232:
233: v_dcd_name := owa_util.get_cgi_env('SCRIPT_NAME');
234: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
235: v_help_url := '/OA_DOC/' || v_language_code || '/awe' || '/icxhlprq.htm';

Line 234: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

230:
231: IF icx_sec.validateSession('ICX_REQS_COPY_REQ') THEN
232:
233: v_dcd_name := owa_util.get_cgi_env('SCRIPT_NAME');
234: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
235: v_help_url := '/OA_DOC/' || v_language_code || '/awe' || '/icxhlprq.htm';
236: v_session_id := to_number(icx_sec.getID(icx_sec.PV_SESSION_ID));
237:
238: select rowidtochar(ROWID)

Line 236: v_session_id := to_number(icx_sec.getID(icx_sec.PV_SESSION_ID));

232:
233: v_dcd_name := owa_util.get_cgi_env('SCRIPT_NAME');
234: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
235: v_help_url := '/OA_DOC/' || v_language_code || '/awe' || '/icxhlprq.htm';
236: v_session_id := to_number(icx_sec.getID(icx_sec.PV_SESSION_ID));
237:
238: select rowidtochar(ROWID)
239: into v_row_id
240: from AK_FLOW_REGION_RELATIONS

Line 287: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

283: icx_on_utilities.unpack_whereSegment(v_where_clause, l_where_clause, l_where_binds);
284:
285: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
286: P_PARENT_REGION_CODE => 'ICX_PO_REQ_HEAD_SUM_R',
287: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
288: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
289: P_WHERE_CLAUSE => l_where_clause,
290: P_RETURN_PARENTS => 'T',
291: P_RETURN_CHILDREN => 'F',

Line 288: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

284:
285: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
286: P_PARENT_REGION_CODE => 'ICX_PO_REQ_HEAD_SUM_R',
287: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
288: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
289: P_WHERE_CLAUSE => l_where_clause,
290: P_RETURN_PARENTS => 'T',
291: P_RETURN_CHILDREN => 'F',
292: P_WHERE_BINDS => l_where_binds );

Line 457: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);

453: select substr(l_message,12,512) into l_err_mesg from dual;
454: if (abs(l_err_num) between 1800 and 1899)
455: then
456: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
457: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);
458: fnd_message.set_token('FORMAT_MASK_TOKEN',nvl(l_web_user_date_format,'DD-MON-YYYY'));
459: l_message := l_err_mesg||'
'||fnd_message.get;
460: icx_util.add_error(l_message) ;
461: icx_admin_sig.error_screen(l_err_mesg);

Line 517: IF (icx_sec.validatesession('ICX_REQS_COPY_REQ')) THEN

513: AND cart_line_id = l_cart_line_id;
514:
515:
516: BEGIN
517: IF (icx_sec.validatesession('ICX_REQS_COPY_REQ')) THEN
518:
519: -- Get dcd path
520: v_dcd_name := owa_util.get_cgi_env('SCRIPT_NAME');
521: -- Get language code

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

518:
519: -- Get dcd path
520: v_dcd_name := owa_util.get_cgi_env('SCRIPT_NAME');
521: -- Get language code
522: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
523:
524: l_req_header_id := icx_call.decrypt2(v_req_header_id);
525:
526: -- Get organization id

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

523:
524: l_req_header_id := icx_call.decrypt2(v_req_header_id);
525:
526: -- Get organization id
527: v_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
528: -- get shopper id
529: v_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
530: -- get employee_id ( Internal Contect ID )
531: v_int_contact_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

Line 529: v_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

525:
526: -- Get organization id
527: v_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
528: -- get shopper id
529: v_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
530: -- get employee_id ( Internal Contect ID )
531: v_int_contact_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
532:
533: -- Get deliver to location etc.,

Line 531: v_int_contact_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

527: v_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
528: -- get shopper id
529: v_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
530: -- get employee_id ( Internal Contect ID )
531: v_int_contact_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
532:
533: -- Get deliver to location etc.,
534: ICX_REQ_NAVIGATION.shopper_info(v_int_contact_id, v_int_contact_name,
535: v_deliver_to_loc_id, v_deliver_to_location,

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

534: ICX_REQ_NAVIGATION.shopper_info(v_int_contact_id, v_int_contact_name,
535: v_deliver_to_loc_id, v_deliver_to_location,
536: v_destination_org_id, v_org_code);
537:
538: OPEN getDate (nvl(icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY), 0));
539: FETCH getDate into v_need_by_date;
540: CLOSE getDate;
541:
542: SELECT note_to_agent