[Home] [Help]
50:
51: PROCEDURE Get_Doc_Entitity_Data (
52: p_level IN VARCHAR2 ,
53: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
54: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
55: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
56: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
57: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
58: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
76: );
77:
78: PROCEDURE Create_Ae_Lines_RA(
79: p_app_rec IN ar_receivable_applications%ROWTYPE ,
80: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
82: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
83: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
84: p_miscel_rec IN g_ae_miscel_rec_type ,
89: --}
90: );
91:
92: PROCEDURE Create_Ae_Lines_MCD(
93: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
94: p_vat_rec IN ar_vat_tax%ROWTYPE ,
95: p_curr_rec IN ae_curr_rec_type );
96:
97: PROCEDURE Assign_Ael_Elements(
1282: * ======================================================================*/
1283: PROCEDURE Get_Doc_Entitity_Data (
1284: p_level IN VARCHAR2 ,
1285: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1286: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1287: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1288: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1289: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
1290: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
1458: p_ctlgd_cm_rec.code_combination_id ,
1459: l_gain_loss_ccid ,
1460: l_cr_unapp_ccid
1461: from ar_receivable_applications ra ,
1462: ar_cash_receipts cr ,
1463: ar_receipt_method_accounts rma ,
1464: ra_customer_trx ctinv ,
1465: ra_customer_trx ctcm ,
1466: ra_cust_trx_line_gl_dist ctlgdcm
1748: p_vat_rec.tax_account_id ,
1749: p_vat_rec.vat_tax_id ,
1750: p_curr_rec.precision ,
1751: p_curr_rec.minimum_accountable_unit
1752: from ar_cash_receipts cr ,
1753: zx_rates_b avt ,
1754: fnd_currencies fc
1755: where cr.cash_receipt_id = g_ae_doc_rec.document_id
1756: and cr.currency_code = fc.currency_code
1898: ) IS
1899:
1900: l_miscel_rec g_ae_miscel_rec_type ;
1901: l_app_rec ar_receivable_applications%ROWTYPE ;
1902: l_cr_rec ar_cash_receipts%ROWTYPE ;
1903: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1904: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1905: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1906: l_vat_rec ar_vat_tax%ROWTYPE ;
2048: | i.e. where receivables_trx_id = -16
2049: * =================================================================================*/
2050: PROCEDURE Create_Ae_Lines_RA(
2051: p_app_rec IN ar_receivable_applications%ROWTYPE ,
2052: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
2053: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
2054: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
2055: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
2056: p_miscel_rec IN g_ae_miscel_rec_type ,
2075: l_amount_applied NUMBER;
2076: l_acctd_amount_applied NUMBER;
2077:
2078: l_def_tax_flag VARCHAR2(1);
2079: l_from_curr ar_cash_receipts.currency_code%type;
2080: l_from_curr_rate ar_cash_receipts.exchange_rate%type;
2081:
2082: --}
2083:
2076: l_acctd_amount_applied NUMBER;
2077:
2078: l_def_tax_flag VARCHAR2(1);
2079: l_from_curr ar_cash_receipts.currency_code%type;
2080: l_from_curr_rate ar_cash_receipts.exchange_rate%type;
2081:
2082: --}
2083:
2084: BEGIN
3033: | p_vat_rec VAT tax Record
3034: | p_curr_rec Currency Record
3035: * ======================================================================*/
3036: PROCEDURE Create_Ae_Lines_MCD(
3037: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
3038: p_vat_rec IN ar_vat_tax%ROWTYPE ,
3039: p_curr_rec IN ae_curr_rec_type ) IS
3040:
3041: -- MRC TRigger REPLACEMENT: modified cursor to extract acctd_amount