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.

[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on AR_APPROVAL_ACTION_HISTORY

Line 934: l_aah_rec ar_approval_action_history%rowtype;

930: l_adjustment_id ar_adjustments.adjustment_id%type;
931: l_ps_rec ar_payment_schedules%rowtype;
932: l_acctd_amount ar_adjustments.acctd_amount%type;
933: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
934: l_aah_rec ar_approval_action_history%rowtype;
935: l_approval_action_history_id
936: ar_approval_action_history.approval_action_history_id%type;
937: ln_adr_tmp NUMBER;
938: ln_acctd_adr_tmp NUMBER;

Line 936: ar_approval_action_history.approval_action_history_id%type;

932: l_acctd_amount ar_adjustments.acctd_amount%type;
933: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
934: l_aah_rec ar_approval_action_history%rowtype;
935: l_approval_action_history_id
936: ar_approval_action_history.approval_action_history_id%type;
937: ln_adr_tmp NUMBER;
938: ln_acctd_adr_tmp NUMBER;
939: /* VAT changes */
940: l_ae_doc_rec ae_doc_rec_type;

Line 1492: -- insert row into ar_approval_action_history

1488: +---------------------*/
1489:
1490: IF p_adj_rec.status <> 'A'
1491: THEN
1492: -- insert row into ar_approval_action_history
1493:
1494: l_aah_rec.action_name := p_adj_rec.status;
1495: l_aah_rec.adjustment_id := l_adjustment_id;
1496: l_aah_rec.action_date := trunc(sysdate);

Line 1574: l_aah_rec ar_approval_action_history%rowtype;

1570:
1571: IS
1572:
1573: l_adj_rec ar_adjustments%rowtype;
1574: l_aah_rec ar_approval_action_history%rowtype;
1575: l_ps_rec ar_payment_schedules%rowtype;
1576: l_approval_action_history_id
1577: ar_approval_action_history.approval_action_history_id%type;
1578: l_status_changed_flag boolean;

Line 1577: ar_approval_action_history.approval_action_history_id%type;

1573: l_adj_rec ar_adjustments%rowtype;
1574: l_aah_rec ar_approval_action_history%rowtype;
1575: l_ps_rec ar_payment_schedules%rowtype;
1576: l_approval_action_history_id
1577: ar_approval_action_history.approval_action_history_id%type;
1578: l_status_changed_flag boolean;
1579: l_old_adj_rec ar_adjustments%rowtype;
1580: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1581: l_ae_doc_rec ae_doc_rec_type;

Line 1925: -- insert row into ar_approval_action_history

1921: +---------------------*/
1922:
1923: IF l_status_changed_flag
1924: THEN
1925: -- insert row into ar_approval_action_history
1926:
1927: l_aah_rec.action_name := l_adj_rec.status;
1928: l_aah_rec.adjustment_id := p_adjustment_id;
1929: l_aah_rec.action_date := trunc(sysdate);

Line 2029: l_aah_rec ar_approval_action_history%rowtype;

2025: p_move_deferred_tax IN varchar2 := 'Y') IS
2026:
2027: l_ps_rec ar_payment_schedules%rowtype;
2028: l_adj_rec ar_adjustments%rowtype;
2029: l_aah_rec ar_approval_action_history%rowtype;
2030: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2031:
2032: l_approval_action_history_id
2033: ar_approval_action_history.approval_action_history_id%type;

Line 2033: ar_approval_action_history.approval_action_history_id%type;

2029: l_aah_rec ar_approval_action_history%rowtype;
2030: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2031:
2032: l_approval_action_history_id
2033: ar_approval_action_history.approval_action_history_id%type;
2034: l_old_adj_rec ar_adjustments%rowtype;
2035: l_ae_doc_rec ae_doc_rec_type;
2036: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2037: --BUG#2750340

Line 2311: | Insert into ar_approval_action_history |

2307:
2308: END IF;
2309:
2310: /*-------------------------------------------+
2311: | Insert into ar_approval_action_history |
2312: +-------------------------------------------*/
2313:
2314: l_aah_rec.action_name := l_adj_rec.status;
2315: l_aah_rec.adjustment_id := p_adjustment_id;

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

2468: END IF;
2469:
2470:
2471: /*------------------------------------------------------------------+
2472: | Verify that a row was inserted into ar_approval_action_history |
2473: +------------------------------------------------------------------*/
2474:
2475: select p_result ||
2476: decode(max(approval_action_history_id),

Line 2480: from ar_approval_action_history

2476: decode(max(approval_action_history_id),
2477: NULL, 'H: Fail, ',
2478: 'H: Pass, ')
2479: into p_result
2480: from ar_approval_action_history
2481: where adjustment_id = p_adj_rec.adjustment_id
2482: and action_name = p_adj_rec.status
2483: and action_date = TRUNC(sysdate)
2484: and nvl(comments, '!@#$%') = nvl(p_adj_rec.comments, '!@#$%');

Line 2618: l_aah_rec ar_approval_action_history%ROWTYPE;

2614: p_reversal_gl_date IN DATE,
2615: p_reversal_date IN DATE,
2616: p_module_name IN VARCHAR2,
2617: p_module_version IN VARCHAR2 ) IS
2618: l_aah_rec ar_approval_action_history%ROWTYPE;
2619: l_aah_id NUMBER;
2620: l_adj_rec ar_adjustments%ROWTYPE;
2621: l_ps_rec ar_payment_schedules%rowtype;
2622: --BUG#2750340

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

2684: END IF;
2685: RAISE;
2686: END;
2687:
2688: -- Create a record in AR_APPROVAL_ACTION_HISTORY for the above adj
2689: -- Get the message from message dict for inserting in comments
2690:
2691: l_aah_rec.action_name := 'R';
2692: l_aah_rec.adjustment_id := p_adj_id;

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

2695: l_aah_rec.comments :=
2696: fnd_message.get_string ('AR','AR_ADJ_REVERSED');
2697:
2698: IF PG_DEBUG in ('Y', 'C') THEN
2699: arp_util.debug( 'before insert_p for ar_approval_action_history');
2700: END IF;
2701: arp_aa_history_pkg.insert_p( l_aah_rec, l_aah_id );
2702:
2703: -- If status of adj == R, then there is no need to create an opposing