eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_ALLOCATION_PKG dependencies on AR_ADJUSTMENTS

Line 70: p_adj_rec IN ar_adjustments%ROWTYPE,

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);
74:

Line 76: p_adj_rec IN ar_adjustments%ROWTYPE,

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:
80: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,

Line 82: p_adj_rec IN ar_adjustments%ROWTYPE,

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,
86: p_process_uned IN VARCHAR2,

Line 92: p_adj_rec IN ar_adjustments%ROWTYPE);

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 ,
96: p_adj_rec IN ar_adjustments%ROWTYPE );

Line 96: p_adj_rec IN ar_adjustments%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,
100: p_adj_rec IN ar_adjustments%ROWTYPE );

Line 100: p_adj_rec IN ar_adjustments%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:
104: PROCEDURE Init_Rev_Tax_Tab;

Line 162: p_adj_rec IN ar_adjustments%ROWTYPE );

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:
166: PROCEDURE Dump_Dist_Amts(p_ae_line_rec ar_distributions%ROWTYPE);

Line 189: FROM ar_adjustments

185: FUNCTION get_adj_act_ccid RETURN NUMBER
186: IS
187: CURSOR c IS
188: SELECT CODE_COMBINATION_ID
189: FROM ar_adjustments
190: WHERE adjustment_id = g_ae_doc_rec.document_id;
191: BEGIN
192: IF g_adj_act_gl_acct_ccid = -9999 THEN
193: IF g_ae_doc_rec.source_table = 'ADJ' THEN

Line 354: p_adj_rec IN ar_adjustments%ROWTYPE,

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,
357: p_br_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE default NULL,
358: p_simul_app IN VARCHAR2 default NULL,

Line 1020: p_adj_rec IN ar_adjustments%ROWTYPE,

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;
1024: l_ae_def_tax BOOLEAN := FALSE;

Line 1184: p_adj_rec IN ar_adjustments%ROWTYPE,

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
1188:

Line 1241: l_adj_number ar_adjustments.adjustment_number%TYPE;

1237:
1238: l_adj_id NUMBER ;
1239: l_dist_count NUMBER ;
1240: l_ae_tax_id NUMBER ;
1241: l_adj_number ar_adjustments.adjustment_number%TYPE;
1242:
1243: l_ra_dist_tbl AR_Revenue_Adjustment_PVT.RA_Dist_Tbl_Type;
1244:
1245: l_return_status VARCHAR2(1) ;

Line 3069: p_adj_rec IN ar_adjustments%ROWTYPE,

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
3073: /*------------------------------------------------------------------------------+

Line 3164: p_adj_rec IN ar_adjustments%ROWTYPE) IS

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:
3168: IF PG_DEBUG in ('Y', 'C') THEN

Line 3324: p_adj_rec IN ar_adjustments%ROWTYPE ) IS

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 ;
3328: l_tax_recoverable_flag ar_receivables_trx.tax_recoverable_flag%TYPE ;

Line 3425: UPDATE ar_adjustments

3421: /* Bug 5659539 - When ccid is overriden while creating adjustment thru API,
3422: overriden ccid should be considered, but not from activities setup(adj_code_combination_id)
3423: This is done by checking if created_from is ADJ_API or not in update stmt. */
3424:
3425: UPDATE ar_adjustments
3426: SET adj_tax_acct_rule = l_rule_used,
3427: -- code_combination_id = nvl(adj_code_combination_id, code_combination_id)
3428: code_combination_id = DECODE(created_from,
3429: 'ADJ_API', nvl(code_combination_id, adj_code_combination_id),

Line 3476: p_adj_rec IN ar_adjustments%ROWTYPE ) IS

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
3480: from dual

Line 3482: from ar_adjustments

3478: CURSOR chk_tax_chrg(p_cust_id IN NUMBER) IS
3479: select 1
3480: from dual
3481: where exists(select 'x'
3482: from ar_adjustments
3483: where type = 'CHARGES'
3484: and nvl(tax_adjusted,0) <> 0
3485: and status = 'A'
3486: and customer_trx_id = p_cust_id);

Line 5857: UPDATE ar_adjustments

5853: (g_ae_doc_rec.source_table = 'ADJ')
5854: THEN
5855: IF get_adj_act_ccid <> l_ae_line_rec.ae_account THEN
5856: BEGIN
5857: UPDATE ar_adjustments
5858: SET code_Combination_id = l_ae_line_rec.ae_account
5859: WHERE adjustment_id = g_ae_doc_rec.document_id;
5860: g_adj_act_gl_acct_ccid := l_ae_line_rec.ae_account;
5861:

Line 9169: p_adj_rec IN ar_adjustments%ROWTYPE ) IS

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()+');
9173: arp_standard.debug('Dump_Init_Amts: ' || 'p_type_acct = ' || p_type_acct);