APPS.INV_RCV_STD_RCPT_APIS dependencies on RCV_PARAMETERS

Line 437: -- Bug 3124881 Get the default routing parameter from rcv_parameters

433: END IF;
434:
435: IF NVL(l_rcv_transaction_rec.inspection_required_flag, 'N') = 'Y' THEN
436: x_routing_id := 2;
437: -- Bug 3124881 Get the default routing parameter from rcv_parameters
438: ELSIF ( l_rcv_transaction_rec.receipt_source_code = 'CUSTOMER' ) then
439: Begin
440: select rma_receipt_routing_id
441: into x_routing_id

Line 442: from rcv_parameters

438: ELSIF ( l_rcv_transaction_rec.receipt_source_code = 'CUSTOMER' ) then
439: Begin
440: select rma_receipt_routing_id
441: into x_routing_id
442: from rcv_parameters
443: where organization_id = p_organization_id;
444:
445: IF (l_debug = 1) THEN
446: print_debug('insert_txn_interface: from rcv parameters: x_routing_id = '|| x_routing_id, 4);

Line 446: print_debug('insert_txn_interface: from rcv parameters: x_routing_id = '|| x_routing_id, 4);

442: from rcv_parameters
443: where organization_id = p_organization_id;
444:
445: IF (l_debug = 1) THEN
446: print_debug('insert_txn_interface: from rcv parameters: x_routing_id = '|| x_routing_id, 4);
447: END IF;
448:
449: Exception
450: WHEN OTHERS THEN

Line 452: print_debug('insert_txn_interface: Exception in getting the routing id from rcv parameters', 4);

448:
449: Exception
450: WHEN OTHERS THEN
451: IF (l_debug = 1) THEN
452: print_debug('insert_txn_interface: Exception in getting the routing id from rcv parameters', 4);
453: print_debug('insert_txn_interface: routing id is set to what fetched from post_query : x_routing_id ='|| x_routing_id, 4);
454: END IF;
455: End;
456: END IF;

Line 1259: FROM rcv_parameters rp

1255: WHERE mp.organization_id = l_to_org_id;
1256:
1257: SELECT rp.pre_receive
1258: INTO v_pre_receive
1259: FROM rcv_parameters rp
1260: WHERE rp.organization_id = l_to_org_id;
1261:
1262: /* SELECT LCM_FLAG
1263: INTO v_lcm_flag