DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on ICX_SEC

Line 2112: IF icx_sec.validateSession THEN

2108:
2109: -- bug 475711
2110: -- set date format to be the same in Web date format mask
2111:
2112: IF icx_sec.validateSession THEN
2113:
2114:
2115: l_param := 'W*178*ICX_EMPLOYEES*178*ICX_RCV_CONFIRM_RECEIPT*' ||
2116: 'PO_HEADER_ID ~ ' || icx_call.decrypt (p1) ||

Line 2119: ' and EXPECTED_RECEIPT_DATE ~ '''|| to_char(to_date(icx_call.decrypt (p3),'DD/MM/YYYY'),icx_sec.getID(icx_sec.pv_date_format)) ||'''' ||

2115: l_param := 'W*178*ICX_EMPLOYEES*178*ICX_RCV_CONFIRM_RECEIPT*' ||
2116: 'PO_HEADER_ID ~ ' || icx_call.decrypt (p1) ||
2117: ' and REQUESTOR_ID ~ ' || icx_call.decrypt (p2) ||
2118: ' and DESTINATION_TYPE_CODE ~ '|| '''EXPENSE''' ||
2119: ' and EXPECTED_RECEIPT_DATE ~ '''|| to_char(to_date(icx_call.decrypt (p3),'DD/MM/YYYY'),icx_sec.getID(icx_sec.pv_date_format)) ||'''' ||
2120: '**]';
2121:
2122:
2123:

Line 2124: l_session_id := icx_sec.getID (icx_sec.PV_Session_ID);

2120: '**]';
2121:
2122:
2123:
2124: l_session_id := icx_sec.getID (icx_sec.PV_Session_ID);
2125:
2126: IF icx_call.decrypt(p11) is not NULL THEN
2127:
2128: -- Set multi-org context with the correct organization id

Line 2129: icx_sec.set_org_context(l_session_id, icx_call.decrypt(p11));

2125:
2126: IF icx_call.decrypt(p11) is not NULL THEN
2127:
2128: -- Set multi-org context with the correct organization id
2129: icx_sec.set_org_context(l_session_id, icx_call.decrypt(p11));
2130: END IF;
2131:
2132: IF l_session_id is NULL THEN
2133: