DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on ICX_SEC

Line 2115: IF icx_sec.validateSession THEN

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

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

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

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

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

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

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