APPS.INV_RCV_STD_RCPT_APIS dependencies on RCV_PARAMETERS

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

435: END IF;
436:
437: IF NVL(l_rcv_transaction_rec.inspection_required_flag, 'N') = 'Y' THEN
438: x_routing_id := 2;
439: -- Bug 3124881 Get the default routing parameter from rcv_parameters
440: ELSIF ( l_rcv_transaction_rec.receipt_source_code = 'CUSTOMER' ) then
441: Begin
442:
443: /* Bug 9158529: LSP Changes */

Line 462: from rcv_parameters

458: ELSE
459:
460: select rma_receipt_routing_id
461: into x_routing_id
462: from rcv_parameters
463: where organization_id = p_organization_id;
464:
465:
466: End If;

Line 472: from rcv_parameters

468: Else
469:
470: select rma_receipt_routing_id
471: into x_routing_id
472: from rcv_parameters
473: where organization_id = p_organization_id;
474:
475: END IF;
476:

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

476:
477: /* End Bug 9158529 */
478:
479: IF (l_debug = 1) THEN
480: print_debug('insert_txn_interface: from rcv parameters: x_routing_id = '|| x_routing_id, 4);
481: END IF;
482:
483: Exception
484: WHEN OTHERS THEN

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

482:
483: Exception
484: WHEN OTHERS THEN
485: IF (l_debug = 1) THEN
486: print_debug('insert_txn_interface: Exception in getting the routing id from rcv parameters', 4);
487: print_debug('insert_txn_interface: routing id is set to what fetched from post_query : x_routing_id ='|| x_routing_id, 4);
488: END IF;
489: End;
490: END IF;

Line 1293: FROM rcv_parameters rp

1289: WHERE mp.organization_id = l_to_org_id;
1290:
1291: SELECT rp.pre_receive
1292: INTO v_pre_receive
1293: FROM rcv_parameters rp
1294: WHERE rp.organization_id = l_to_org_id;
1295:
1296: /* SELECT LCM_FLAG
1297: INTO v_lcm_flag