APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_TRX_REFS

Line 133: FROM jai_rgm_trx_refs

129:
130: CURSOR c_reference(cp_source IN VARCHAR2, cp_invoice_id IN NUMBER, cp_invoice_distribution_id IN NUMBER) IS
131: SELECT reference_id, parent_reference_id, item_line_id, reversal_flag, nvl(recovered_amount, 0) recovered_amount,
132: tax_type, recoverable_amount, nvl(discounted_amount,0) discounted_amount
133: FROM jai_rgm_trx_refs
134: WHERE source = cp_source
135: AND invoice_id = cp_invoice_id
136: AND line_id = cp_invoice_distribution_id;
137:

Line 141: FROM jai_rgm_trx_refs

137:
138: CURSOR c_reference_using_id(cp_reference_id IN NUMBER) IS
139: SELECT reference_id, parent_reference_id, item_line_id, reversal_flag, recovered_amount, tax_type,
140: recoverable_amount
141: FROM jai_rgm_trx_refs
142: WHERE reference_id = cp_reference_id;
143:
144: CURSOR c_invoice_distribution(cp_invoice_distribution_id IN NUMBER) IS
145: SELECT a.invoice_id, a.invoice_distribution_id,

Line 458: UPDATE jai_rgm_trx_refs

454: OPEN c_reference(p_source, p_invoice_id, r_dist.parent_reversal_id);
455: FETCH c_reference INTO r_parent_ref;
456: CLOSE c_reference;
457:
458: UPDATE jai_rgm_trx_refs
459: SET reversal_flag = 'Y',
460: last_update_date = sysdate
461: WHERE source = p_source
462: AND invoice_id = p_invoice_id

Line 930: FROM ap_invoice_distributions_all a, jai_rgm_trx_refs b /* second table is used for join just to take IL records */

926: CURSOR c_invoice_distributions(cp_invoice_id IN NUMBER) IS
927: SELECT a.invoice_id, a.invoice_distribution_id, a.distribution_line_number, a.dist_match_type,
928: a.invoicE_line_number, /* INVOICE LINES UPTAKE */
929: a.parent_reversal_id, a.reversal_flag, a.rcv_transaction_id, a.po_distribution_id
930: FROM ap_invoice_distributions_all a, jai_rgm_trx_refs b /* second table is used for join just to take IL records */
931: WHERE a.invoice_id = cp_invoice_id
932: AND a.line_type_lookup_code = jai_constants.misc_line -- <> 'PREPAY'
933: AND b.source = jai_constants.source_ap
934: and b.invoice_id = a.invoice_id

Line 981: FROM jai_rgm_trx_refs

977: AND a.po_line_id = b.po_line_id;
978:
979: CURSOR c_batch_references(cp_batch_id IN NUMBER, cp_source IN VARCHAR2) IS
980: SELECT distinct invoice_id
981: FROM jai_rgm_trx_refs
982: WHERE batch_id = cp_batch_id
983: AND source = cp_source;
984:
985: CURSOR c_previous_payments_of_inv(cp_invoice_id IN NUMBER, cp_start_date IN DATE) IS

Line 1035: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */

1031: FROM
1032: ap_invoice_payments_all apinvp,
1033: ap_checks_all apc ,
1034: ap_invoice_distributions_all ainvd ,
1035: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */
1036: WHERE
1037: apinvp.org_id = p_org_id
1038: AND apinvp.check_id = apc.check_id
1039: AND nvl(apc.future_pay_due_date, v_today) <= v_today

Line 1078: FROM jai_rgm_trx_refs

1074: ainvd.invoice_distribution_id;
1075:
1076: CURSOR c_invoice_batch_refs(cp_source IN VARCHAR2, cp_batch_id IN NUMBER, cp_invoice_id IN NUMBER) IS
1077: SELECT *
1078: FROM jai_rgm_trx_refs
1079: WHERE source = cp_source
1080: AND batch_id = cp_batch_id
1081: AND invoice_id = cp_invoice_id
1082: AND reversal_flag IS NULL

Line 1108: ln_reference_id JAI_RGM_TRX_REFS.reference_id%TYPE;

1104: r_tax_dist_dtl c_tax_dist_dtl%ROWTYPE;
1105:
1106: ln_item_line_id NUMBER(15); -- Incase of AP -> AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id%TYPE;
1107: ln_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
1108: ln_reference_id JAI_RGM_TRX_REFS.reference_id%TYPE;
1109: ln_parent_reference_id JAI_RGM_TRX_REFS.parent_reference_id%TYPE;
1110: ln_taxable_basis NUMBER;
1111:
1112: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;

Line 1109: ln_parent_reference_id JAI_RGM_TRX_REFS.parent_reference_id%TYPE;

1105:
1106: ln_item_line_id NUMBER(15); -- Incase of AP -> AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id%TYPE;
1107: ln_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
1108: ln_reference_id JAI_RGM_TRX_REFS.reference_id%TYPE;
1109: ln_parent_reference_id JAI_RGM_TRX_REFS.parent_reference_id%TYPE;
1110: ln_taxable_basis NUMBER;
1111:
1112: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
1113: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;

Line 1113: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;

1109: ln_parent_reference_id JAI_RGM_TRX_REFS.parent_reference_id%TYPE;
1110: ln_taxable_basis NUMBER;
1111:
1112: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
1113: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;
1114: ln_recoverable_amount JAI_RGM_TRX_REFS.recoverable_amount%TYPE;
1115:
1116: ln_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
1117: lv_src_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;

Line 1114: ln_recoverable_amount JAI_RGM_TRX_REFS.recoverable_amount%TYPE;

1110: ln_taxable_basis NUMBER;
1111:
1112: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
1113: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;
1114: ln_recoverable_amount JAI_RGM_TRX_REFS.recoverable_amount%TYPE;
1115:
1116: ln_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
1117: lv_src_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
1118: lv_process_flag VARCHAR2(2);

Line 1182: -- ~~~~~~~~~~~~~~~~~~~~~~~~~ POPULATION Logic for Data Entry into JAI_RGM_TRX_REFS ~~~~~~~~~~~~~~~~~~~~~~~~

1178: END IF;
1179: GOTO end_of_reference_insertion;
1180: END IF;
1181:
1182: -- ~~~~~~~~~~~~~~~~~~~~~~~~~ POPULATION Logic for Data Entry into JAI_RGM_TRX_REFS ~~~~~~~~~~~~~~~~~~~~~~~~
1183: -- following condition is satisfied for REVERSAL lines
1184: IF ap_acc_dist.reversal_flag = 'Y' AND ap_acc_dist.parent_reversal_id IS NOT NULL THEN
1185: OPEN c_invoice_distribution(ap_acc_dist.parent_reversal_id);
1186: FETCH c_invoice_distribution INTO r_parent_dist;