APPS.ARP_CREDIT_MEMO_MODULE dependencies on AR_CREDIT_MEMO_AMOUNTS

Line 538: 'DELETE from ar_credit_memo_amounts

534: debug(' len(delete_line_dist_sql) = '||
535: to_char(lengthb(l_delete_line_dist_sql)));
536:
537: l_delete_header_cma_sql :=
538: 'DELETE from ar_credit_memo_amounts
539: WHERE customer_trx_line_id in
540: (SELECT customer_trx_line_id
541: FROM ra_customer_trx_lines
542: WHERE line_type = ''LINE''

Line 550: 'DELETE from ar_credit_memo_amounts

546: debug(' len(delete_header_cma_sql) = '||
547: to_char(lengthb(l_delete_header_cma_sql)));
548:
549: l_delete_line_cma_sql :=
550: 'DELETE from ar_credit_memo_amounts
551: WHERE customer_trx_line_id = :customer_trx_line_id';
552:
553: debug(l_delete_line_cma_sql);
554: debug(' len(delete_line_cma_sql) = '||

Line 1993: -- Build insert stmt for ar_credit_memo_amounts

1989: debug(' len(rule_insert_dist_sql) = '||
1990: to_char(lengthb(l_rule_insert_dist_sql)));
1991:
1992: ----------------------------------------------------
1993: -- Build insert stmt for ar_credit_memo_amounts
1994: ----------------------------------------------------
1995: l_rule_insert_cma_sql :=
1996: 'INSERT INTO ar_credit_memo_amounts
1997: (

Line 1996: 'INSERT INTO ar_credit_memo_amounts

1992: ----------------------------------------------------
1993: -- Build insert stmt for ar_credit_memo_amounts
1994: ----------------------------------------------------
1995: l_rule_insert_cma_sql :=
1996: 'INSERT INTO ar_credit_memo_amounts
1997: (
1998: credit_memo_amount_id,
1999: last_updated_by,
2000: last_update_date,

Line 2013: ar_credit_memo_amounts_s.nextval, /* credit_memo_amount_id */' || CRLF ||

2009: program_update_date,
2010: request_id
2011: )
2012: SELECT
2013: ar_credit_memo_amounts_s.nextval, /* credit_memo_amount_id */' || CRLF ||
2014: p_profile_info.user_id || ', /* last_updated_by */
2015: sysdate, /* last_update_date */' || CRLF ||
2016: p_profile_info.conc_login_id || ', /* last_update_login */' || CRLF ||
2017: p_profile_info.user_id || ', /* created_by */

Line 3069: -- Insert into ar_credit_memo_amounts

3065: END IF;
3066:
3067: IF( cm_sched_insert_cma_t( i ) = YES ) THEN
3068: -------------------------------------------------------------
3069: -- Insert into ar_credit_memo_amounts
3070: -------------------------------------------------------------
3071:
3072: /*--------------------------------------------------------------
3073: | Bug # 2988282 - ORASHID: 07-07-2003

Line 3472: debug( ' Updating ar_credit_memo_amounts table',

3468: ----------------------------------------------------------------
3469: -- gl_date not in cm schedule tables, update the database
3470: ----------------------------------------------------------------
3471: BEGIN
3472: debug( ' Updating ar_credit_memo_amounts table',
3473: MSG_LEVEL_DEBUG );
3474:
3475: UPDATE ar_credit_memo_amounts
3476: SET amount = amount + p_amount

Line 3475: UPDATE ar_credit_memo_amounts

3471: BEGIN
3472: debug( ' Updating ar_credit_memo_amounts table',
3473: MSG_LEVEL_DEBUG );
3474:
3475: UPDATE ar_credit_memo_amounts
3476: SET amount = amount + p_amount
3477: WHERE customer_trx_line_id = p_line_id
3478: and gl_date = p_gl_date;
3479: