APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_TRANSACTIONS

Line 5: g_rti_row rcv_transactions_interface%ROWTYPE;

1: PACKAGE BODY rcv_table_functions AS
2: /* $Header: RCVTBFNB.pls 120.4.12010000.3 2008/12/26 07:28:26 ksivasa ship $*/
3: g_debug_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
4: g_rhi_row rcv_headers_interface%ROWTYPE;
5: g_rti_row rcv_transactions_interface%ROWTYPE;
6: g_rt_row rcv_transactions%ROWTYPE;
7: g_rsh_row rcv_shipment_headers%ROWTYPE;
8: g_rsl_row rcv_shipment_lines%ROWTYPE;
9: g_poh_row po_headers_all%ROWTYPE;

Line 6: g_rt_row rcv_transactions%ROWTYPE;

2: /* $Header: RCVTBFNB.pls 120.4.12010000.3 2008/12/26 07:28:26 ksivasa ship $*/
3: g_debug_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
4: g_rhi_row rcv_headers_interface%ROWTYPE;
5: g_rti_row rcv_transactions_interface%ROWTYPE;
6: g_rt_row rcv_transactions%ROWTYPE;
7: g_rsh_row rcv_shipment_headers%ROWTYPE;
8: g_rsl_row rcv_shipment_lines%ROWTYPE;
9: g_poh_row po_headers_all%ROWTYPE;
10: g_pol_row po_lines_all%ROWTYPE;

Line 94: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE

90: /*******/
91: /* RTI */
92: /*******/
93: FUNCTION get_rti_row_from_id(
94: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE
95: )
96: RETURN rcv_transactions_interface%ROWTYPE IS
97: BEGIN
98: IF (p_interface_transaction_id IS NULL) THEN

Line 96: RETURN rcv_transactions_interface%ROWTYPE IS

92: /*******/
93: FUNCTION get_rti_row_from_id(
94: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE
95: )
96: RETURN rcv_transactions_interface%ROWTYPE IS
97: BEGIN
98: IF (p_interface_transaction_id IS NULL) THEN
99: RETURN NULL;
100: END IF;

Line 108: FROM rcv_transactions_interface

104: END IF;
105:
106: SELECT *
107: INTO g_rti_row
108: FROM rcv_transactions_interface
109: WHERE interface_transaction_id = p_interface_transaction_id;
110:
111: RETURN g_rti_row;
112: EXCEPTION

Line 118: p_rti_row IN rcv_transactions_interface%ROWTYPE

114: invalid_value(p_interface_transaction_id, 'INTERFACE_TRANSACTION_ID');
115: END;
116:
117: PROCEDURE update_rti_row(
118: p_rti_row IN rcv_transactions_interface%ROWTYPE
119: ) IS
120: BEGIN
121: asn_debug.put_line('Updating RTI INTERFACE_TRANSACTION_ID=' || p_rti_row.interface_transaction_id);
122:

Line 123: UPDATE rcv_transactions_interface

119: ) IS
120: BEGIN
121: asn_debug.put_line('Updating RTI INTERFACE_TRANSACTION_ID=' || p_rti_row.interface_transaction_id);
122:
123: UPDATE rcv_transactions_interface
124: SET ROW = p_rti_row
125: WHERE interface_transaction_id = p_rti_row.interface_transaction_id
126: AND processing_status_code <> 'ERROR'; --BUG: 5598140
127:

Line 135: p_transaction_id IN rcv_transactions.transaction_id%TYPE

131: /*******/
132: /* RT */
133: /*******/
134: FUNCTION get_rt_row_from_id(
135: p_transaction_id IN rcv_transactions.transaction_id%TYPE
136: )
137: RETURN rcv_transactions%ROWTYPE IS
138: BEGIN
139: IF (p_transaction_id IS NULL) THEN

Line 137: RETURN rcv_transactions%ROWTYPE IS

133: /*******/
134: FUNCTION get_rt_row_from_id(
135: p_transaction_id IN rcv_transactions.transaction_id%TYPE
136: )
137: RETURN rcv_transactions%ROWTYPE IS
138: BEGIN
139: IF (p_transaction_id IS NULL) THEN
140: RETURN NULL;
141: END IF;

Line 149: FROM rcv_transactions

145: END IF;
146:
147: SELECT *
148: INTO g_rt_row
149: FROM rcv_transactions
150: WHERE transaction_id = p_transaction_id;
151:
152: RETURN g_rt_row;
153: EXCEPTION