DBA Data[Home] [Help]

APPS.ARP_ALLOCATION_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 69: p_app_rec IN ar_receivable_applications%ROWTYPE,

65: PROCEDURE Get_Tax_Curr(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,
66: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE);
67:
68: PROCEDURE Get_Invoice_Distributions(p_invoice_id IN NUMBER,
69: p_app_rec IN ar_receivable_applications%ROWTYPE,
70: p_adj_rec IN ar_adjustments%ROWTYPE,
71: p_process_ed_adj IN VARCHAR2,
72: p_process_uned IN VARCHAR2,
73: p_process_pay IN VARCHAR2);

Line 75: PROCEDURE Override_Accounts(p_app_rec IN ar_receivable_applications%ROWTYPE,

71: p_process_ed_adj IN VARCHAR2,
72: p_process_uned IN VARCHAR2,
73: p_process_pay IN VARCHAR2);
74:
75: PROCEDURE Override_Accounts(p_app_rec IN ar_receivable_applications%ROWTYPE,
76: p_adj_rec IN ar_adjustments%ROWTYPE,
77: p_override1 OUT NOCOPY VARCHAR2,
78: p_override2 OUT NOCOPY VARCHAR2);
79:

Line 81: p_app_rec IN ar_receivable_applications%ROWTYPE,

77: p_override1 OUT NOCOPY VARCHAR2,
78: p_override2 OUT NOCOPY VARCHAR2);
79:
80: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,
81: p_app_rec IN ar_receivable_applications%ROWTYPE,
82: p_adj_rec IN ar_adjustments%ROWTYPE,
83: p_required OUT NOCOPY BOOLEAN);
84:
85: PROCEDURE Get_Tax_Link_Id(p_process_ed_adj IN VARCHAR2,

Line 91: PROCEDURE Process_Amounts(p_app_rec IN ar_receivable_applications%ROWTYPE,

87: p_process_pay IN VARCHAR2);
88:
89: FUNCTION Get_Acctd_Amt(p_amount IN NUMBER ) RETURN NUMBER;
90:
91: PROCEDURE Process_Amounts(p_app_rec IN ar_receivable_applications%ROWTYPE,
92: p_adj_rec IN ar_adjustments%ROWTYPE);
93:
94: PROCEDURE Doc_Tax_Acct_Rule(p_type_acct IN VARCHAR2 ,
95: p_app_rec IN ar_receivable_applications%ROWTYPE ,

Line 95: p_app_rec IN ar_receivable_applications%ROWTYPE ,

91: PROCEDURE Process_Amounts(p_app_rec IN ar_receivable_applications%ROWTYPE,
92: p_adj_rec IN ar_adjustments%ROWTYPE);
93:
94: PROCEDURE Doc_Tax_Acct_Rule(p_type_acct IN VARCHAR2 ,
95: p_app_rec IN ar_receivable_applications%ROWTYPE ,
96: p_adj_rec IN ar_adjustments%ROWTYPE );
97:
98: PROCEDURE Init_Amts(p_type_acct IN VARCHAR2 ,
99: p_app_rec IN ar_receivable_applications%ROWTYPE,

Line 99: p_app_rec IN ar_receivable_applications%ROWTYPE,

95: p_app_rec IN ar_receivable_applications%ROWTYPE ,
96: p_adj_rec IN ar_adjustments%ROWTYPE );
97:
98: PROCEDURE Init_Amts(p_type_acct IN VARCHAR2 ,
99: p_app_rec IN ar_receivable_applications%ROWTYPE,
100: p_adj_rec IN ar_adjustments%ROWTYPE );
101:
102: PROCEDURE Gross_To_Activity_GL(p_type_acct IN VARCHAR2);
103:

Line 161: p_app_rec IN ar_receivable_applications%ROWTYPE ,

157: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2,
158: p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
159:
160: PROCEDURE Dump_Init_Amts(p_type_acct IN VARCHAR2 ,
161: p_app_rec IN ar_receivable_applications%ROWTYPE ,
162: p_adj_rec IN ar_adjustments%ROWTYPE );
163:
164: PROCEDURE Dump_Line_Amts(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
165:

Line 352: p_app_rec IN ar_receivable_applications%ROWTYPE,

348: PROCEDURE Allocate_Tax (
349: p_ae_doc_rec IN ae_doc_rec_type,
350: p_ae_event_rec IN ae_event_rec_type,
351: p_ae_rule_rec IN ae_rule_rec_type,
352: p_app_rec IN ar_receivable_applications%ROWTYPE,
353: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,
354: p_adj_rec IN ar_adjustments%ROWTYPE,
355: p_ae_ctr IN OUT NOCOPY BINARY_INTEGER,
356: p_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type,

Line 863: ar_receivable_applications ra

859: where source_id = g_ae_doc_rec.source_id
860: and source_table = 'RA'
861: and ref_customer_trx_line_id in (select customer_trx_line_id
862: from ra_customer_trx_lines ctl_cm,
863: ar_receivable_applications ra
864: where ra.receivable_application_id = g_ae_doc_rec.source_id
865: and ra.customer_trx_id = ctl_cm.customer_trx_id
866: and ctl_cm.previous_customer_trx_line_id is not null);
867:

Line 885: ar_receivable_applications ra

881: where source_id = g_ae_doc_rec.source_id
882: and source_table = 'RA'
883: and ref_customer_trx_line_id in (select customer_trx_line_id
884: from ra_customer_trx_lines ctl_inv,
885: ar_receivable_applications ra
886: where ra.receivable_application_id = g_ae_doc_rec.source_id
887: and ra.applied_customer_trx_id = ctl_inv.customer_trx_id);
888: l_cnt := sql%rowcount;
889:

Line 1019: p_app_rec IN ar_receivable_applications%ROWTYPE,

1015: | p_required OUT Flag indicates whether tax processing
1016: | is required
1017: * ======================================================================*/
1018: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,
1019: p_app_rec IN ar_receivable_applications%ROWTYPE,
1020: p_adj_rec IN ar_adjustments%ROWTYPE,
1021: p_required OUT NOCOPY BOOLEAN) IS
1022:
1023: l_dummy NUMBER;

Line 1183: p_app_rec IN ar_receivable_applications%ROWTYPE,

1179: | NOTES : THE ORDERING OF THE CURSOR inv_dist_non_rule IS VERY IMPORTANT
1180: * ======================================================================*/
1181: PROCEDURE Get_Invoice_Distributions(
1182: p_invoice_id IN NUMBER,
1183: p_app_rec IN ar_receivable_applications%ROWTYPE,
1184: p_adj_rec IN ar_adjustments%ROWTYPE,
1185: p_process_ed_adj IN VARCHAR2,
1186: p_process_uned IN VARCHAR2,
1187: p_process_pay IN VARCHAR2 ) IS

Line 3068: PROCEDURE Override_Accounts(p_app_rec IN ar_receivable_applications%ROWTYPE,

3064: | p_adj_rec IN Adjustment details
3065: | p_override1 IN Override Earned discount/Adjustment account
3066: | p_override2 IN Override Unearned discount account
3067: *==========================================================================*/
3068: PROCEDURE Override_Accounts(p_app_rec IN ar_receivable_applications%ROWTYPE,
3069: p_adj_rec IN ar_adjustments%ROWTYPE,
3070: p_override1 OUT NOCOPY VARCHAR2,
3071: p_override2 OUT NOCOPY VARCHAR2 ) IS
3072: BEGIN

Line 3163: PROCEDURE Process_Amounts(p_app_rec IN ar_receivable_applications%ROWTYPE,

3159: | PARAMETERS
3160: | p_type_acct IN Flag to indicate accounting for Earned
3161: | discounts Adjustments or Unearned discounts
3162: *==========================================================================*/
3163: PROCEDURE Process_Amounts(p_app_rec IN ar_receivable_applications%ROWTYPE,
3164: p_adj_rec IN ar_adjustments%ROWTYPE) IS
3165:
3166: BEGIN
3167:

Line 3323: p_app_rec IN ar_receivable_applications%ROWTYPE ,

3319: | p_app_rec IN Receivable Application detail record
3320: | p_adj_rec IN Adjustment detail record
3321: *==========================================================================*/
3322: PROCEDURE Doc_Tax_Acct_Rule(p_type_acct IN VARCHAR2 ,
3323: p_app_rec IN ar_receivable_applications%ROWTYPE ,
3324: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
3325:
3326: l_gl_account_source ar_receivables_trx.gl_account_source%TYPE ;
3327: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE ;

Line 3416: UPDATE ar_receivable_applications

3412: | Update the correct bucket with Rule used for a discount or an adjustment |
3413: +-------------------------------------------------------------------------------*/
3414: IF ((g_ae_doc_rec.source_table = 'RA') AND (p_type_acct = 'ED_ADJ')) THEN
3415:
3416: UPDATE ar_receivable_applications
3417: SET edisc_tax_acct_rule = l_rule_used
3418: WHERE receivable_application_id = g_ae_doc_rec.source_id;
3419:
3420: ELSIF ((g_ae_doc_rec.source_table = 'ADJ') AND (p_type_acct = 'ED_ADJ')) THEN

Line 3436: UPDATE ar_receivable_applications

3432: WHERE adjustment_id = g_ae_doc_rec.source_id;
3433:
3434: ELSIF ((g_ae_doc_rec.source_table = 'RA') AND (p_type_acct = 'UNED')) THEN
3435:
3436: UPDATE ar_receivable_applications
3437: SET unedisc_tax_acct_rule = l_rule_used
3438: WHERE receivable_application_id = g_ae_doc_rec.source_id;
3439:
3440: END IF;

Line 3475: p_app_rec IN ar_receivable_applications%ROWTYPE,

3471: | p_type_acct IN Flag to indicate accounting for Earned
3472: | discounts Adjustments or Unearned discounts
3473: *==========================================================================*/
3474: PROCEDURE Init_Amts( p_type_acct IN VARCHAR2 ,
3475: p_app_rec IN ar_receivable_applications%ROWTYPE,
3476: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
3477:
3478: CURSOR chk_tax_chrg(p_cust_id IN NUMBER) IS
3479: select 1

Line 9168: p_app_rec IN ar_receivable_applications%ROWTYPE,

9164: | p_app_rec IN Receivable application record
9165: | p_adj_rec IN Adjustment Record
9166: *==========================================================================*/
9167: PROCEDURE Dump_Init_Amts(p_type_acct IN VARCHAR2 ,
9168: p_app_rec IN ar_receivable_applications%ROWTYPE,
9169: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
9170: BEGIN
9171: IF PG_DEBUG in ('Y', 'C') THEN
9172: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()+');