APPS.ICX_REQ_ACCT2 dependencies on ICX_CART_LINE_DISTRIBUTIONS_S

Line 251: select icx_cart_line_distributions_s.nextval into v_distribution_id from sys.dual;

247: last_update_login, creation_date,created_by,org_id,cart_id';
248:
249:
250:
251: select icx_cart_line_distributions_s.nextval into v_distribution_id from sys.dual;
252:
253: /* code was commented out to take care of Bind vars logic ***/
254:
255:

Line 275: l_insert_sql := l_insert_sql || ' VALUES (' || v_cart_line_id || ',icx_cart_line_distributions_s.nextval,' || l_dist_num || ','

271:
272:
273:
274: /*
275: l_insert_sql := l_insert_sql || ' VALUES (' || v_cart_line_id || ',icx_cart_line_distributions_s.nextval,' || l_dist_num || ','
276: || v_account_id || ',''' || v_account_num || ''',''' || l_alloc_type|| ''','
277: || l_alloc_percent || ',' || l_shopper_id || ',sysdate,' || l_shopper_id || ',sysdate,' || l_shopper_id || ',' || v_oo_id || ',' || v_cart_id;
278: ***/
279: /*sugupta breaking l_insert_sql into two to reduce line length for MRC conversion*/

Line 441: -- l_insert_sql := 'Update icx_cart_line_distributions set

437: close get_cart_line_number;
438:
439: /* Commented out the following code to implement Bind vars **/
440:
441: -- l_insert_sql := 'Update icx_cart_line_distributions set
442: -- last_updated_by = ' || l_shopper_id
443: -- || ' ,last_update_login = ' || l_shopper_id
444: -- || ' ,last_update_date = sysdate';
445: /*sugupta breaking l_insert_sql into two to reduce line length for MRC conversion*/