DBA Data[Home] [Help]

APPS.CSD_RECEIVE_UTIL dependencies on RCV_PARAMETERS

Line 62: FROM rcv_parameters rcp

58: p_org_id NUMBER
59: )
60: IS
61: SELECT rcp.receiving_routing_id
62: FROM rcv_parameters rcp
63: WHERE organization_id = p_org_id;
64:
65: --Cursor for shipping network
66: CURSOR cur_shipping_network (

Line 264: -- At org level check rcv_parameters. This is kept as dynamic sql

260: IF(l_routing_header_id is not null) THEN
261: RETURN l_routing_header_id;
262: END IF;
263:
264: -- At org level check rcv_parameters. This is kept as dynamic sql
265: -- to remove code dependency for R10.
266:
267: BEGIN
268: EXECUTE IMMEDIATE 'SELECT nvl(RMA_RECEIPT_ROUTING_ID, '||g_standard_routing ||')'

Line 269: || 'FROM RCV_PARAMETERS WHERE organization_id =:1'

265: -- to remove code dependency for R10.
266:
267: BEGIN
268: EXECUTE IMMEDIATE 'SELECT nvl(RMA_RECEIPT_ROUTING_ID, '||g_standard_routing ||')'
269: || 'FROM RCV_PARAMETERS WHERE organization_id =:1'
270: --|| p_inv_org_id --4277749 TBD
271: --4277749 changed the exec to use using clause
272: INTO l_routing_header_id using p_inv_org_id;
273: EXCEPTION