APPS.RCV_NORMALIZE_DATA_PKG dependencies on RCV_HEADERS_INTERFACE

Line 6: g_ou_name rcv_headers_interface.operating_unit%TYPE; -- Bug 14370850

2: /* $Header: RCVNRMDB.pls 120.24.12020000.6 2013/03/14 07:11:57 zhlee ship $*/
3:
4: g_fail_if_one_line_fails VARCHAR2(1) := nvl(fnd_profile.VALUE('RCV_FAIL_IF_LINE_FAILS'),'N'); /* lcm changes */
5: g_org_id NUMBER; -- Bug 14370850
6: g_ou_name rcv_headers_interface.operating_unit%TYPE; -- Bug 14370850
7:
8: PROCEDURE handle_error(
9: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
10: ) IS

Line 55: p_rhi_row IN OUT NOCOPY rcv_headers_interface%ROWTYPE

51: END IF;
52: END handle_error;
53:
54: PROCEDURE check_orphan_rhi(
55: p_rhi_row IN OUT NOCOPY rcv_headers_interface%ROWTYPE
56: ) IS
57: x_rti_count NUMBER;
58: proc_code rcv_headers_interface.processing_status_code%TYPE;
59: BEGIN

Line 58: proc_code rcv_headers_interface.processing_status_code%TYPE;

54: PROCEDURE check_orphan_rhi(
55: p_rhi_row IN OUT NOCOPY rcv_headers_interface%ROWTYPE
56: ) IS
57: x_rti_count NUMBER;
58: proc_code rcv_headers_interface.processing_status_code%TYPE;
59: BEGIN
60: SELECT count(*)
61: INTO x_rti_count
62: FROM rcv_transactions_interface

Line 85: p_rhi_row IN OUT NOCOPY rcv_headers_interface%ROWTYPE

81: NULL;
82: END check_orphan_rhi;
83:
84: PROCEDURE prepare_pending_rhi(
85: p_rhi_row IN OUT NOCOPY rcv_headers_interface%ROWTYPE
86: ) IS
87: x_org_id NUMBER;
88: BEGIN --update block
89: BEGIN --exception handling block

Line 149: x_rhi_row rcv_headers_interface%ROWTYPE;

145:
146: PROCEDURE process_row(
147: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
148: ) IS
149: x_rhi_row rcv_headers_interface%ROWTYPE;
150:
151: -- Following 4 variables are added for BugFix 5078706
152: l_parent_transaction_type rcv_transactions.transaction_type%type;
153: l_parent_transaction_id rcv_transactions.transaction_id%type;

Line 510: FROM rcv_headers_interface

506: FROM DUAL;
507:
508: CURSOR c_get_all_pending_rhi_row IS
509: SELECT *
510: FROM rcv_headers_interface
511: WHERE processing_status_code = 'PENDING'
512: AND ( mo_global.check_access(org_id) = 'Y'
513: OR org_id IS NULL)
514: ORDER BY group_id, header_interface_id; -- added by bug 16393104 to avoid deadlock

Line 519: FROM rcv_headers_interface

515: -- FOR UPDATE NOWAIT; --Added by bug 13587955
516:
517: CURSOR c_get_pending_rhi_row IS
518: SELECT *
519: FROM rcv_headers_interface
520: WHERE processing_status_code = 'PENDING'
521: AND GROUP_ID = g_group_id
522: ORDER BY header_interface_id; -- added by bug 16393104 to avoid deadlock
523: -- FOR UPDATE NOWAIT; --Added by bug 13587955

Line 611: FROM rcv_headers_interface

607:
608: -- Bug 14370850 : Start
609: CURSOR c_get_all_pending_rhi_row2 IS
610: SELECT *
611: FROM rcv_headers_interface
612: WHERE processing_status_code = 'PENDING'
613: AND org_id = p_org_id
614: ORDER BY group_id,header_interface_id; -- added by bug 16393104 to avoid deadlock
615: -- FOR UPDATE NOWAIT; --Added by bug 13587955

Line 649: FROM rcv_headers_interface

645: -- FOR UPDATE NOWAIT; --Added by bug 13587955
646:
647: CURSOR c_get_pending_rhi_row2 IS
648: SELECT *
649: FROM rcv_headers_interface
650: WHERE processing_status_code = 'PENDING'
651: AND group_id = g_group_id
652: AND org_id = p_org_id
653: ORDER BY header_interface_id; -- added by bug 16393104 to avoid deadlock

Line 693: x_rhi_row1 rcv_headers_interface%ROWTYPE; -- added by bug 16393104

689:
690: row_locked EXCEPTION; --Added by bug 13587955
691: PRAGMA EXCEPTION_INIT(row_locked, -54); --Added by bug 13587955
692: x_rti_row1 rcv_transactions_interface%ROWTYPE; -- added by bug 16393104
693: x_rhi_row1 rcv_headers_interface%ROWTYPE; -- added by bug 16393104
694:
695: BEGIN
696: IF p_processing_mode = 'BATCH' THEN
697: IF p_group_id IS NULL

Line 743: UPDATE rcv_headers_interface

739: IF (g_multiple_groups = TRUE) THEN
740: asn_debug.put_line('Processing multiple groups when p_org_id is passed...');
741: explode_all_lpn;
742:
743: UPDATE rcv_headers_interface
744: SET org_id = p_org_id
745: WHERE processing_status_code = 'PENDING'
746: AND org_id IS NULL
747: AND operating_unit = g_ou_name;

Line 762: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id

758: FOR x_rhi_row IN c_get_all_pending_rhi_row2 LOOP
759: -- bug 16393104 start
760: SELECT *
761: INTO x_rhi_row1
762: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id
763: FOR UPDATE NOWAIT;
764:
765: prepare_pending_rhi(x_rhi_row1);
766: -- bug 16393104 end

Line 805: UPDATE rcv_headers_interface

801: ELSE
802: asn_debug.put_line('Processing single group when p_org_id is passed...');
803: explode_lpn;
804:
805: UPDATE rcv_headers_interface
806: SET org_id = p_org_id
807: WHERE processing_status_code = 'PENDING'
808: AND group_id = g_group_id
809: AND org_id IS NULL

Line 826: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id

822: FOR x_rhi_row IN c_get_pending_rhi_row2 LOOP
823: -- bug 16393104 start
824: SELECT *
825: INTO x_rhi_row1
826: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id
827: FOR UPDATE NOWAIT;
828:
829: prepare_pending_rhi(x_rhi_row1);
830: -- bug 16393104 end

Line 898: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id

894: FOR x_rhi_row IN c_get_all_pending_rhi_row LOOP
895: -- bug 16393104 start
896: SELECT *
897: INTO x_rhi_row1
898: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id
899: FOR UPDATE NOWAIT;
900:
901: prepare_pending_rhi(x_rhi_row1);
902: -- bug 16393104 end

Line 946: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id

942: FOR x_rhi_row IN c_get_pending_rhi_row LOOP
943: -- bug 16393104 start
944: SELECT *
945: INTO x_rhi_row1
946: FROM rcv_headers_interface WHERE header_interface_id = x_rhi_row.header_interface_id
947: FOR UPDATE NOWAIT;
948:
949: prepare_pending_rhi(x_rhi_row1);
950: -- bug 16393104 end