APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SYSTEM_ITEMS_B_S

Line 4442: select mtl_system_items_B_S.nextval

4438:
4439: lStmtNumber := 50;
4440:
4441: if lNumberMethod = 1 then
4442: select mtl_system_items_B_S.nextval
4443: into lNextNum
4444: from dual;
4445:
4446: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)

Line 4453: select to_char(mtl_system_items_B_S.nextval)

4449: into new_item_num
4450: from dual;
4451:
4452: elsif lNumberMethod = 2 then
4453: select to_char(mtl_system_items_B_S.nextval)
4454: into new_item_num
4455: from dual;
4456:
4457: -- 2652379 : When numbering method is 3 , i.e Replace with order num, line num;

Line 4559: select to_char(mtl_system_items_B_S.nextval)

4555: then
4556: IF PG_DEBUG <> 0 THEN
4557: oe_debug_pub.add( 'Create_Item: '|| 'generating unique name' ,2 );
4558: END IF;
4559: select to_char(mtl_system_items_B_S.nextval)
4560: into lNextNum
4561: from dual;
4562: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4563: end if;

Line 4574: select to_char(mtl_system_items_B_S.nextval)

4570:
4571: IF PG_DEBUG <> 0 THEN
4572: oe_debug_pub.add('Create_Item: ' || 'generating unique name' ,2 );
4573: END IF;
4574: select to_char(mtl_system_items_B_S.nextval)
4575: into lNextNum
4576: from dual;
4577: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4578: exit;

Line 4588: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;

4584:
4585: oe_debug_pub.add('Create_Item: ' || 'new_item number is ' || seg(app_col_ind) ,2 );
4586: END IF;
4587:
4588: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;
4589:
4590: IF PG_DEBUG <> 0 THEN
4591: oe_debug_pub.add('Create_Item: ' || 'new pConfigId is '||to_char(pConfigId),2);
4592: END IF;