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_PROCESS_ADJUSTMENT dependencies on AR_APPROVAL_ACTION_HISTORY

Line 1156: l_aah_rec ar_approval_action_history%rowtype;

1152: l_adjustment_id ar_adjustments.adjustment_id%type;
1153: l_ps_rec ar_payment_schedules%rowtype;
1154: l_acctd_amount ar_adjustments.acctd_amount%type;
1155: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
1156: l_aah_rec ar_approval_action_history%rowtype;
1157: l_approval_action_history_id
1158: ar_approval_action_history.approval_action_history_id%type;
1159: ln_adr_tmp NUMBER;
1160: ln_acctd_adr_tmp NUMBER;

Line 1158: ar_approval_action_history.approval_action_history_id%type;

1154: l_acctd_amount ar_adjustments.acctd_amount%type;
1155: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
1156: l_aah_rec ar_approval_action_history%rowtype;
1157: l_approval_action_history_id
1158: ar_approval_action_history.approval_action_history_id%type;
1159: ln_adr_tmp NUMBER;
1160: ln_acctd_adr_tmp NUMBER;
1161: /* VAT changes */
1162: l_ae_doc_rec ae_doc_rec_type;

Line 1774: -- insert row into ar_approval_action_history

1770: END IF;
1771:
1772: IF p_adj_rec.status <> 'A'
1773: THEN
1774: -- insert row into ar_approval_action_history
1775:
1776: l_aah_rec.action_name := p_adj_rec.status;
1777: l_aah_rec.adjustment_id := l_adjustment_id;
1778: l_aah_rec.action_date := trunc(sysdate);

Line 1856: l_aah_rec ar_approval_action_history%rowtype;

1852:
1853: IS
1854:
1855: l_adj_rec ar_adjustments%rowtype;
1856: l_aah_rec ar_approval_action_history%rowtype;
1857: l_ps_rec ar_payment_schedules%rowtype;
1858: l_approval_action_history_id
1859: ar_approval_action_history.approval_action_history_id%type;
1860: l_status_changed_flag boolean;

Line 1859: ar_approval_action_history.approval_action_history_id%type;

1855: l_adj_rec ar_adjustments%rowtype;
1856: l_aah_rec ar_approval_action_history%rowtype;
1857: l_ps_rec ar_payment_schedules%rowtype;
1858: l_approval_action_history_id
1859: ar_approval_action_history.approval_action_history_id%type;
1860: l_status_changed_flag boolean;
1861: l_old_adj_rec ar_adjustments%rowtype;
1862: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1863: l_ae_doc_rec ae_doc_rec_type;

Line 2353: -- insert row into ar_approval_action_history

2349: +---------------------*/
2350:
2351: IF l_status_changed_flag
2352: THEN
2353: -- insert row into ar_approval_action_history
2354:
2355: l_aah_rec.action_name := l_adj_rec.status;
2356: l_aah_rec.adjustment_id := p_adjustment_id;
2357: l_aah_rec.action_date := trunc(sysdate);

Line 2457: l_aah_rec ar_approval_action_history%rowtype;

2453: p_move_deferred_tax IN varchar2 := 'Y') IS
2454:
2455: l_ps_rec ar_payment_schedules%rowtype;
2456: l_adj_rec ar_adjustments%rowtype;
2457: l_aah_rec ar_approval_action_history%rowtype;
2458: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2459:
2460: l_approval_action_history_id
2461: ar_approval_action_history.approval_action_history_id%type;

Line 2461: ar_approval_action_history.approval_action_history_id%type;

2457: l_aah_rec ar_approval_action_history%rowtype;
2458: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2459:
2460: l_approval_action_history_id
2461: ar_approval_action_history.approval_action_history_id%type;
2462: l_old_adj_rec ar_adjustments%rowtype;
2463: l_ae_doc_rec ae_doc_rec_type;
2464: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2465: --BUG#2750340

Line 2739: | Insert into ar_approval_action_history |

2735:
2736: END IF;
2737:
2738: /*-------------------------------------------+
2739: | Insert into ar_approval_action_history |
2740: +-------------------------------------------*/
2741:
2742: l_aah_rec.action_name := l_adj_rec.status;
2743: l_aah_rec.adjustment_id := p_adjustment_id;

Line 2900: | Verify that a row was inserted into ar_approval_action_history |

2896: END IF;
2897:
2898:
2899: /*------------------------------------------------------------------+
2900: | Verify that a row was inserted into ar_approval_action_history |
2901: +------------------------------------------------------------------*/
2902:
2903: select p_result ||
2904: decode(max(approval_action_history_id),

Line 2908: from ar_approval_action_history

2904: decode(max(approval_action_history_id),
2905: NULL, 'H: Fail, ',
2906: 'H: Pass, ')
2907: into p_result
2908: from ar_approval_action_history
2909: where adjustment_id = p_adj_rec.adjustment_id
2910: and action_name = p_adj_rec.status
2911: and action_date = TRUNC(sysdate)
2912: and nvl(comments, '!@#$%') = nvl(p_adj_rec.comments, '!@#$%');

Line 3046: l_aah_rec ar_approval_action_history%ROWTYPE;

3042: p_reversal_gl_date IN DATE,
3043: p_reversal_date IN DATE,
3044: p_module_name IN VARCHAR2,
3045: p_module_version IN VARCHAR2 ) IS
3046: l_aah_rec ar_approval_action_history%ROWTYPE;
3047: l_aah_id NUMBER;
3048: l_adj_rec ar_adjustments%ROWTYPE;
3049: l_ps_rec ar_payment_schedules%rowtype;
3050: --BUG#2750340

Line 3180: -- Create a record in AR_APPROVAL_ACTION_HISTORY for the above adj

3176: END IF;
3177: RAISE;
3178: END;
3179:
3180: -- Create a record in AR_APPROVAL_ACTION_HISTORY for the above adj
3181: -- Get the message from message dict for inserting in comments
3182:
3183: l_aah_rec.action_name := 'R';
3184: l_aah_rec.adjustment_id := p_adj_id;

Line 3191: arp_util.debug( 'before insert_p for ar_approval_action_history');

3187: l_aah_rec.comments :=
3188: fnd_message.get_string ('AR','AR_ADJ_REVERSED');
3189:
3190: IF PG_DEBUG in ('Y', 'C') THEN
3191: arp_util.debug( 'before insert_p for ar_approval_action_history');
3192: END IF;
3193: arp_aa_history_pkg.insert_p( l_aah_rec, l_aah_id );
3194:
3195: -- If status of adj == R, then there is no need to create an opposing