APPS.ICX_PO_REQ_ACCT2 dependencies on ICX_CART_LINE_DISTRIBUTIONS

Line 447: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'

443: and a.REGION_CODE = c.REGION_CODE
444: and a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
445: and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
446: and a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
447: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'
448: and d.COLUMN_NAME like 'CHARGE_ACCOUNT_SEGMENT%'
449: order by a.display_sequence;
450:
451: v_col_name varchar2(100);

Line 497: l_insert_sql := 'Update icx_cart_line_distributions set

493: /* Modified to take care of Bind vars code ***/
494:
495:
496: /*
497: l_insert_sql := 'Update icx_cart_line_distributions set
498: last_updated_by = ' || l_shopper_id
499: || ' ,last_update_login = ' || l_shopper_id
500: || ' ,last_update_date = sysdate';
501:

Line 516: l_insert_sql := 'Update icx_cart_line_distributions

512: l_insert_sql := l_insert_sql || ', charge_account_num = ''' || v_account_num || '''';
513: end if;
514: ***/
515:
516: l_insert_sql := 'Update icx_cart_line_distributions
517: set last_updated_by = :last_updated_by,
518: last_update_login = :last_update_login ,
519: last_update_date = :last_update_date,
520: allocation_type = decode(:allocation_type, null, allocation_type, :allocation_type ),

Line 584: update icx_cart_line_distributions

580: v_budget_acct_id,
581: v_accrual_acct_id,
582: v_return_code);
583:
584: update icx_cart_line_distributions
585: set ACCRUAL_ACCOUNT_ID = v_accrual_acct_id,
586: VARIANCE_ACCOUNT_ID = v_variance_acct_id,
587: BUDGET_ACCOUNT_ID = v_budget_acct_id
588: where CART_LINE_ID = v_cart_line_id

Line 1403: from icx_cart_line_distributions

1399: l_ret_cd BOOLEAN;
1400:
1401: cursor get_account_id(cartid number,cartline_id number,oo_id number,dist_id number) is
1402: select charge_account_id
1403: from icx_cart_line_distributions
1404: where cart_id = cartid
1405: and cart_line_id = cartline_id
1406: and distribution_id = dist_id
1407: and nvl(org_id,-9999) = nvl(oo_id,-9999);