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.

APPS.ICX_REQ_ACCT2 dependencies on ICX_CART_LINE_DISTRIBUTIONS

Line 24: from icx_cart_line_distributions

20: l_account_id number;
21:
22: cursor dist_acct is
23: select charge_account_id
24: from icx_cart_line_distributions
25: where cart_id = v_cart_id
26: and cart_line_id = v_cart_line_id
27: order by distribution_id;
28:

Line 161: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'

157: and a.REGION_CODE = c.REGION_CODE
158: and a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
159: and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
160: and a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
161: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'
162: and d.COLUMN_NAME like 'CHARGE_ACCOUNT_SEGMENT%'
163: order by a.display_sequence;
164:
165: v_col_name varchar2(100);

Line 187: from icx_cart_line_distributions

183: l_num_ak_cols number := 0;
184:
185: cursor get_dist_num is
186: select max(distribution_num)
187: from icx_cart_line_distributions
188: where cart_id = v_cart_id
189: and cart_line_id = v_cart_line_id
190: and nvl(org_id,-9999) = nvl(v_oo_id,-9999);
191:

Line 242: l_insert_sql := 'Insert into icx_cart_line_distributions(cart_line_id,

238:
239: /* changed the code to take care of Bind vars + AK flexibility of DYnamic sql ***/
240:
241:
242: l_insert_sql := 'Insert into icx_cart_line_distributions(cart_line_id,
243: distribution_id,distribution_num,charge_account_id,charge_account_num,
244: allocation_type,allocation_value';
245:
246: l_insert_sql := l_insert_sql || ' ,last_updated_by,last_update_date,

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 338: update icx_cart_line_distributions

334: v_budget_acct_id,
335: v_accrual_acct_id,
336: v_return_code);
337:
338: update icx_cart_line_distributions
339: set ACCRUAL_ACCOUNT_ID = v_accrual_acct_id,
340: VARIANCE_ACCOUNT_ID = v_variance_acct_id,
341: BUDGET_ACCOUNT_ID = v_budget_acct_id
342: where CART_LINE_ID = v_cart_line_id

Line 394: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'

390: and a.REGION_CODE = c.REGION_CODE
391: and a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
392: and c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
393: and a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
394: and a.region_code = 'ICX_CART_LINE_DISTRIBUTIONS_R'
395: and d.COLUMN_NAME like 'CHARGE_ACCOUNT_SEGMENT%'
396: order by a.display_sequence;
397:
398: v_col_name varchar2(100);

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*/

Line 447: l_insert_sql := 'Update icx_cart_line_distributions

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*/
446:
447: l_insert_sql := 'Update icx_cart_line_distributions
448: set last_updated_by = :last_updated_by,
449: last_update_login = :last_update_login ,
450: last_update_date = :last_update_date,
451: allocation_type = decode( :allocation_type, null, allocation_type, :allocation_type),

Line 536: update icx_cart_line_distributions

532: v_budget_acct_id,
533: v_accrual_acct_id,
534: v_return_code);
535:
536: update icx_cart_line_distributions
537: set ACCRUAL_ACCOUNT_ID = v_accrual_acct_id,
538: VARIANCE_ACCOUNT_ID = v_variance_acct_id,
539: BUDGET_ACCOUNT_ID = v_budget_acct_id
540: where CART_LINE_ID = v_cart_line_id

Line 779: from icx_cart_line_distributions

775: l_line_number number := NULL;
776:
777: cursor get_line_number(cartid number,cartline_id number,oo_id number) is
778: select max(distribution_num)
779: from icx_cart_line_distributions
780: where cart_id = cartid
781: and cart_line_id = cartline_id
782: and nvl(org_id, -9999) = nvl(oo_id,-9999);
783:

Line 904: from icx_cart_line_distributions

900: l_line_number number := NULL;
901:
902: cursor get_line_number(cartid number,cartline_id number,oo_id number) is
903: select max(distribution_num)
904: from icx_cart_line_distributions
905: where cart_id = cartid
906: and cart_line_id = cartline_id
907: and nvl(org_id, -9999) = nvl(oo_id,-9999);
908:

Line 1322: from icx_cart_line_distributions

1318: l_ret_cd BOOLEAN;
1319:
1320: cursor get_account_id(cartid number,cartline_id number,oo_id number,dist_id number) is
1321: select charge_account_id
1322: from icx_cart_line_distributions
1323: where cart_id = cartid
1324: and cart_line_id = cartline_id
1325: and distribution_id = dist_id
1326: and nvl(org_id,-9999) = nvl(oo_id,-9999);