APPS.RCV_NORMALIZE_DATA_PKG dependencies on RCV_HEADERS_INTERFACE

Line 53: p_rhi_row IN OUT NOCOPY rcv_headers_interface%ROWTYPE

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

Line 56: proc_code rcv_headers_interface.processing_status_code%TYPE;

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

Line 83: p_rhi_row IN OUT NOCOPY rcv_headers_interface%ROWTYPE

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

Line 141: x_rhi_row rcv_headers_interface%ROWTYPE;

137:
138: PROCEDURE process_row(
139: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
140: ) IS
141: x_rhi_row rcv_headers_interface%ROWTYPE;
142:
143: -- Following 4 variables are added for BugFix 5078706
144: l_parent_transaction_type rcv_transactions.transaction_type%type;
145: l_parent_transaction_id rcv_transactions.transaction_id%type;

Line 419: FROM rcv_headers_interface

415: FROM DUAL;
416:
417: CURSOR c_get_all_pending_rhi_row IS
418: SELECT *
419: FROM rcv_headers_interface
420: WHERE processing_status_code = 'PENDING'
421: AND ( mo_global.check_access(org_id) = 'Y'
422: OR org_id IS NULL);
423:

Line 426: FROM rcv_headers_interface

422: OR org_id IS NULL);
423:
424: CURSOR c_get_pending_rhi_row IS
425: SELECT *
426: FROM rcv_headers_interface
427: WHERE processing_status_code = 'PENDING'
428: AND GROUP_ID = g_group_id;
429:
430: /* the order is important, which is the reason for the connect by string */