DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on ICX_CALL

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

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

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

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

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

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

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

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

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

2116:
2117:
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:

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

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

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:

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

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

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

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