DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on ICX_CALL

Line 2105: --htp.p ('Begin Open_RCV_orders p1= ' || icx_call.decrypt (p1));

2101:
2102: -- Construct the Receive Orders Web page parameters
2103: -- Note: ~ is translated to = sign.
2104:
2105: --htp.p ('Begin Open_RCV_orders p1= ' || icx_call.decrypt (p1));
2106: --htp.p ('Begin Open_RCV_orders p2= ' || icx_call.decrypt (p2));
2107: --htp.p ('Begin Open_RCV_orders p3= ' || icx_call.decrypt (p3));
2108:
2109: -- bug 475711

Line 2106: --htp.p ('Begin Open_RCV_orders p2= ' || icx_call.decrypt (p2));

2102: -- Construct the Receive Orders Web page parameters
2103: -- Note: ~ is translated to = sign.
2104:
2105: --htp.p ('Begin Open_RCV_orders p1= ' || icx_call.decrypt (p1));
2106: --htp.p ('Begin Open_RCV_orders p2= ' || icx_call.decrypt (p2));
2107: --htp.p ('Begin Open_RCV_orders p3= ' || icx_call.decrypt (p3));
2108:
2109: -- bug 475711
2110: -- set date format to be the same in Web date format mask

Line 2107: --htp.p ('Begin Open_RCV_orders p3= ' || icx_call.decrypt (p3));

2103: -- Note: ~ is translated to = sign.
2104:
2105: --htp.p ('Begin Open_RCV_orders p1= ' || icx_call.decrypt (p1));
2106: --htp.p ('Begin Open_RCV_orders p2= ' || icx_call.decrypt (p2));
2107: --htp.p ('Begin Open_RCV_orders p3= ' || icx_call.decrypt (p3));
2108:
2109: -- bug 475711
2110: -- set date format to be the same in Web date format mask
2111:

Line 2116: 'PO_HEADER_ID ~ ' || icx_call.decrypt (p1) ||

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) ||
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: '**]';

Line 2117: ' and REQUESTOR_ID ~ ' || icx_call.decrypt (p2) ||

2113:
2114:
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:

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 2126: IF icx_call.decrypt(p11) is not NULL THEN

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
2129: icx_sec.set_org_context(l_session_id, icx_call.decrypt(p11));
2130: END IF;

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:

Line 2134: OracleOn.IC (Y => icx_call.encrypt2 (l_param,-999));

2130: END IF;
2131:
2132: IF l_session_id is NULL THEN
2133:
2134: OracleOn.IC (Y => icx_call.encrypt2 (l_param,-999));
2135:
2136: ELSE
2137:
2138: OracleOn.IC (Y => icx_call.encrypt2 (l_param,l_session_id));

Line 2138: OracleOn.IC (Y => icx_call.encrypt2 (l_param,l_session_id));

2134: OracleOn.IC (Y => icx_call.encrypt2 (l_param,-999));
2135:
2136: ELSE
2137:
2138: OracleOn.IC (Y => icx_call.encrypt2 (l_param,l_session_id));
2139:
2140: END IF;
2141:
2142: END IF;