DBA Data[Home] [Help]

APPS.ARP_ALLOCATION_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 68: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

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

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

Line 80: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

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 159: p_app_rec IN ar_receivable_applications%ROWTYPE ,

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

Line 350: p_app_rec IN ar_receivable_applications%ROWTYPE,

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

Line 917: p_app_rec IN ar_receivable_applications%ROWTYPE,

913: | p_required OUT Flag indicates whether tax processing
914: | is required
915: * ======================================================================*/
916: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,
917: p_app_rec IN ar_receivable_applications%ROWTYPE,
918: p_adj_rec IN ar_adjustments%ROWTYPE,
919: p_rev_rec_req OUT NOCOPY BOOLEAN,
920: p_required OUT NOCOPY BOOLEAN) IS
921:

Line 1118: p_app_rec IN ar_receivable_applications%ROWTYPE,

1114: | NOTES : THE ORDERING OF THE CURSOR inv_dist_non_rule IS VERY IMPORTANT
1115: * ======================================================================*/
1116: PROCEDURE Get_Invoice_Distributions(
1117: p_invoice_id IN NUMBER,
1118: p_app_rec IN ar_receivable_applications%ROWTYPE,
1119: p_adj_rec IN ar_adjustments%ROWTYPE,
1120: p_process_ed_adj IN VARCHAR2,
1121: p_process_uned IN VARCHAR2,
1122: p_process_pay IN VARCHAR2 ) IS

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

2778: | p_adj_rec IN Adjustment details
2779: | p_override1 IN Override Earned discount/Adjustment account
2780: | p_override2 IN Override Unearned discount account
2781: *==========================================================================*/
2782: PROCEDURE Override_Accounts(p_app_rec IN ar_receivable_applications%ROWTYPE,
2783: p_adj_rec IN ar_adjustments%ROWTYPE,
2784: p_override1 OUT NOCOPY VARCHAR2,
2785: p_override2 OUT NOCOPY VARCHAR2 ) IS
2786: BEGIN

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

2873: | PARAMETERS
2874: | p_type_acct IN Flag to indicate accounting for Earned
2875: | discounts Adjustments or Unearned discounts
2876: *==========================================================================*/
2877: PROCEDURE Process_Amounts(p_app_rec IN ar_receivable_applications%ROWTYPE,
2878: p_adj_rec IN ar_adjustments%ROWTYPE) IS
2879:
2880: BEGIN
2881:

Line 3037: p_app_rec IN ar_receivable_applications%ROWTYPE ,

3033: | p_app_rec IN Receivable Application detail record
3034: | p_adj_rec IN Adjustment detail record
3035: *==========================================================================*/
3036: PROCEDURE Doc_Tax_Acct_Rule(p_type_acct IN VARCHAR2 ,
3037: p_app_rec IN ar_receivable_applications%ROWTYPE ,
3038: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
3039:
3040: l_gl_account_source ar_receivables_trx.gl_account_source%TYPE ;
3041: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE ;

Line 3130: UPDATE ar_receivable_applications

3126: | Update the correct bucket with Rule used for a discount or an adjustment |
3127: +-------------------------------------------------------------------------------*/
3128: IF ((g_ae_doc_rec.source_table = 'RA') AND (p_type_acct = 'ED_ADJ')) THEN
3129:
3130: UPDATE ar_receivable_applications
3131: SET edisc_tax_acct_rule = l_rule_used
3132: WHERE receivable_application_id = g_ae_doc_rec.source_id;
3133:
3134: ELSIF ((g_ae_doc_rec.source_table = 'ADJ') AND (p_type_acct = 'ED_ADJ')) THEN

Line 3150: UPDATE ar_receivable_applications

3146: WHERE adjustment_id = g_ae_doc_rec.source_id;
3147:
3148: ELSIF ((g_ae_doc_rec.source_table = 'RA') AND (p_type_acct = 'UNED')) THEN
3149:
3150: UPDATE ar_receivable_applications
3151: SET unedisc_tax_acct_rule = l_rule_used
3152: WHERE receivable_application_id = g_ae_doc_rec.source_id;
3153:
3154: END IF;

Line 3189: p_app_rec IN ar_receivable_applications%ROWTYPE,

3185: | p_type_acct IN Flag to indicate accounting for Earned
3186: | discounts Adjustments or Unearned discounts
3187: *==========================================================================*/
3188: PROCEDURE Init_Amts( p_type_acct IN VARCHAR2 ,
3189: p_app_rec IN ar_receivable_applications%ROWTYPE,
3190: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
3191:
3192: CURSOR chk_tax_chrg(p_cust_id IN NUMBER) IS
3193: select 1

Line 8678: p_app_rec IN ar_receivable_applications%ROWTYPE,

8674: | p_app_rec IN Receivable application record
8675: | p_adj_rec IN Adjustment Record
8676: *==========================================================================*/
8677: PROCEDURE Dump_Init_Amts(p_type_acct IN VARCHAR2 ,
8678: p_app_rec IN ar_receivable_applications%ROWTYPE,
8679: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
8680: BEGIN
8681: IF PG_DEBUG in ('Y', 'C') THEN
8682: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Init_Amts()+');