APPS.ARP_CREDIT_MEMO_MODULE dependencies on AR_CREDIT_MEMO_AMOUNTS

Line 542: 'DELETE from ar_credit_memo_amounts

538: debug(' len(delete_line_dist_sql) = '||
539: to_char(lengthb(l_delete_line_dist_sql)));
540:
541: l_delete_header_cma_sql :=
542: 'DELETE from ar_credit_memo_amounts
543: WHERE customer_trx_line_id in
544: (SELECT customer_trx_line_id
545: FROM ra_customer_trx_lines
546: WHERE line_type = ''LINE''

Line 554: 'DELETE from ar_credit_memo_amounts

550: debug(' len(delete_header_cma_sql) = '||
551: to_char(lengthb(l_delete_header_cma_sql)));
552:
553: l_delete_line_cma_sql :=
554: 'DELETE from ar_credit_memo_amounts
555: WHERE customer_trx_line_id = :customer_trx_line_id';
556:
557: debug(l_delete_line_cma_sql);
558: debug(' len(delete_line_cma_sql) = '||

Line 1994: -- Build insert stmt for ar_credit_memo_amounts

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

Line 1997: 'INSERT INTO ar_credit_memo_amounts

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

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

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

Line 3157: -- Insert into ar_credit_memo_amounts

3153: END IF;
3154:
3155: IF( cm_sched_insert_cma_t( i ) = YES ) THEN
3156: -------------------------------------------------------------
3157: -- Insert into ar_credit_memo_amounts
3158: -------------------------------------------------------------
3159:
3160: /*--------------------------------------------------------------
3161: | Bug # 2988282 - ORASHID: 07-07-2003

Line 3560: debug( ' Updating ar_credit_memo_amounts table',

3556: ----------------------------------------------------------------
3557: -- gl_date not in cm schedule tables, update the database
3558: ----------------------------------------------------------------
3559: BEGIN
3560: debug( ' Updating ar_credit_memo_amounts table',
3561: MSG_LEVEL_DEBUG );
3562:
3563: UPDATE ar_credit_memo_amounts
3564: SET amount = amount + p_amount

Line 3563: UPDATE ar_credit_memo_amounts

3559: BEGIN
3560: debug( ' Updating ar_credit_memo_amounts table',
3561: MSG_LEVEL_DEBUG );
3562:
3563: UPDATE ar_credit_memo_amounts
3564: SET amount = amount + p_amount
3565: WHERE customer_trx_line_id = p_line_id
3566: and gl_date = p_gl_date;
3567: