eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_TRANSACTIONS

Line 57: FROM JAI_RCV_TRANSACTIONS

53:
54: CURSOR c_trx(cp_transaction_id IN NUMBER)
55: IS
56: SELECT *
57: FROM JAI_RCV_TRANSACTIONS
58: WHERE transaction_id = cp_transaction_id;
59:
60: CURSOR c_base_trx(cp_transaction_id IN NUMBER) IS
61: SELECT shipment_header_id,

Line 86: FROM rcv_transactions

82: vendor_site_id,
83: transaction_date
84: --,attribute_category,
85: --attribute4
86: FROM rcv_transactions
87: WHERE transaction_id = cp_transaction_id;
88:
89: PROCEDURE get_location(
90: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

Line 90: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

86: FROM rcv_transactions
87: WHERE transaction_id = cp_transaction_id;
88:
89: PROCEDURE get_location(
90: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
91: p_location_id OUT NOCOPY hr_locations_all.location_id%TYPE,
92: p_process_status OUT NOCOPY VARCHAR2,
93: p_process_message OUT NOCOPY VARCHAR2);
94:

Line 99: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,

95: PROCEDURE generate_schedule(
96: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
97: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
98: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
99: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
100: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
101: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,
102: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
103: p_process_status OUT NOCOPY VARCHAR2,

Line 112: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

108:
109: PROCEDURE insert_rcv_lines(
110: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
111: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
112: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
113: p_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE,
114: p_simulate_flag IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
115: p_process_status OUT NOCOPY VARCHAR2,
116: p_process_message OUT NOCOPY VARCHAR2);

Line 125: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',

121: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
122: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
123: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
124: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
125: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
126: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
127: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
128: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
129: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,

Line 126: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),

122: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
123: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
124: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
125: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
126: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
127: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
128: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
129: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
130: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,

Line 136: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

132: p_process_status OUT NOCOPY VARCHAR2,
133: p_process_message OUT NOCOPY VARCHAR2);
134:
135: PROCEDURE process_vat(
136: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
137: p_process_status OUT NOCOPY VARCHAR2,
138: p_process_message OUT NOCOPY VARCHAR2);
139:
140:

Line 150: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

146: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
147: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
148: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,
149: p_force IN VARCHAR2 DEFAULT NULL,
150: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
151: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
152: p_called_from IN VARCHAR2,
153: p_process_status OUT NOCOPY VARCHAR2,
154: p_process_message OUT NOCOPY VARCHAR2);

Line 151: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

147: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
148: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,
149: p_force IN VARCHAR2 DEFAULT NULL,
150: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
151: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
152: p_called_from IN VARCHAR2,
153: p_process_status OUT NOCOPY VARCHAR2,
154: p_process_message OUT NOCOPY VARCHAR2);
155:

Line 181: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

177: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
178: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,
179: p_force IN VARCHAR2 DEFAULT NULL,
180: p_commit_switch IN VARCHAR2,
181: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
182: pv_invoice_date IN VARCHAR2, /* rallamse bug#4336482 changed to VARCHAR2 from DATE */
183: p_called_from IN VARCHAR2);
184:
185: PROCEDURE do_rtv_accounting(

Line 188: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

184:
185: PROCEDURE do_rtv_accounting(
186: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
187: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
188: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
189: p_called_from IN VARCHAR2,
190: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
191: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
192: p_process_status OUT NOCOPY VARCHAR2,

Line 190: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

186: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
187: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
188: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
189: p_called_from IN VARCHAR2,
190: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
191: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
192: p_process_status OUT NOCOPY VARCHAR2,
193: p_process_message OUT NOCOPY VARCHAR2);
194:

Line 191: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

187: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
188: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
189: p_called_from IN VARCHAR2,
190: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
191: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
192: p_process_status OUT NOCOPY VARCHAR2,
193: p_process_message OUT NOCOPY VARCHAR2);
194:
195: PROCEDURE do_rma_accounting(

Line 196: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

192: p_process_status OUT NOCOPY VARCHAR2,
193: p_process_message OUT NOCOPY VARCHAR2);
194:
195: PROCEDURE do_rma_accounting(
196: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
197: p_process_status OUT NOCOPY VARCHAR2,
198: p_process_message OUT NOCOPY VARCHAR2);
199:
200: END jai_rcv_rgm_claims_pkg;