DBA Data[Home] [Help]

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_RGM_LINES

Line 122: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,

118: PROCEDURE update_rcv_lines(
119: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
120: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
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'),

Line 123: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,

119: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
120: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
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,

Line 129: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,

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,
131: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
132: p_process_status OUT NOCOPY VARCHAR2,
133: p_process_message OUT NOCOPY VARCHAR2);

Line 130: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,

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,
131: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
132: p_process_status OUT NOCOPY VARCHAR2,
133: p_process_message OUT NOCOPY VARCHAR2);
134:

Line 131: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,

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,
131: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
132: p_process_status OUT NOCOPY VARCHAR2,
133: p_process_message OUT NOCOPY VARCHAR2);
134:
135: PROCEDURE process_vat(

Line 148: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,

144: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
145: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
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,

Line 160: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,

156:
157: PROCEDURE process_no_claim(
158: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
159: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
160: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,
161: p_regime_regno IN VARCHAR2 DEFAULT NULL,
162: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
163: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
164: p_process_status OUT NOCOPY VARCHAR2,

Line 178: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,

174: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
175: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
176: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
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 */