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 69: p_adj_rec IN ar_adjustments%ROWTYPE,

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

Line 75: p_adj_rec IN ar_adjustments%ROWTYPE,

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

Line 81: p_adj_rec IN ar_adjustments%ROWTYPE,

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:
85: PROCEDURE Get_Tax_Link_Id(p_process_ed_adj 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 160: p_adj_rec IN ar_adjustments%ROWTYPE );

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

Line 187: FROM ar_adjustments

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

Line 352: p_adj_rec IN ar_adjustments%ROWTYPE,

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

Line 918: p_adj_rec IN ar_adjustments%ROWTYPE,

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:
922: l_dummy NUMBER;

Line 1119: p_adj_rec IN ar_adjustments%ROWTYPE,

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

Line 1176: l_adj_number ar_adjustments.adjustment_number%TYPE;

1172:
1173: l_adj_id NUMBER ;
1174: l_dist_count NUMBER ;
1175: l_ae_tax_id NUMBER ;
1176: l_adj_number ar_adjustments.adjustment_number%TYPE;
1177:
1178: l_ra_dist_tbl AR_Revenue_Adjustment_PVT.RA_Dist_Tbl_Type;
1179:
1180: l_return_status VARCHAR2(1) ;

Line 2783: p_adj_rec IN ar_adjustments%ROWTYPE,

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

Line 2878: p_adj_rec IN ar_adjustments%ROWTYPE) IS

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

Line 3038: p_adj_rec IN ar_adjustments%ROWTYPE ) IS

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

Line 3139: UPDATE ar_adjustments

3135: /* Bug 5659539 - When ccid is overriden while creating adjustment thru API,
3136: overriden ccid should be considered, but not from activities setup(adj_code_combination_id)
3137: This is done by checking if created_from is ADJ_API or not in update stmt. */
3138:
3139: UPDATE ar_adjustments
3140: SET adj_tax_acct_rule = l_rule_used,
3141: -- code_combination_id = nvl(adj_code_combination_id, code_combination_id)
3142: code_combination_id = DECODE(created_from,
3143: 'ADJ_API', nvl(code_combination_id, adj_code_combination_id),

Line 3190: p_adj_rec IN ar_adjustments%ROWTYPE ) IS

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

Line 3196: from ar_adjustments

3192: CURSOR chk_tax_chrg(p_cust_id IN NUMBER) IS
3193: select 1
3194: from dual
3195: where exists(select 'x'
3196: from ar_adjustments
3197: where type = 'CHARGES'
3198: and nvl(tax_adjusted,0) <> 0
3199: and status = 'A'
3200: and customer_trx_id = p_cust_id);

Line 5571: UPDATE ar_adjustments

5567: (g_ae_doc_rec.source_table = 'ADJ')
5568: THEN
5569: IF get_adj_act_ccid <> l_ae_line_rec.ae_account THEN
5570: BEGIN
5571: UPDATE ar_adjustments
5572: SET code_Combination_id = l_ae_line_rec.ae_account
5573: WHERE adjustment_id = g_ae_doc_rec.document_id;
5574: g_adj_act_gl_acct_ccid := l_ae_line_rec.ae_account;
5575: EXCEPTION

Line 8679: p_adj_rec IN ar_adjustments%ROWTYPE ) IS

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