APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SYSTEM_ITEMS_B_S

Line 4347: select mtl_system_items_B_S.nextval

4343:
4344: lStmtNumber := 50;
4345:
4346: if lNumberMethod = 1 then
4347: select mtl_system_items_B_S.nextval
4348: into lNextNum
4349: from dual;
4350:
4351: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)

Line 4358: select to_char(mtl_system_items_B_S.nextval)

4354: into new_item_num
4355: from dual;
4356:
4357: elsif lNumberMethod = 2 then
4358: select to_char(mtl_system_items_B_S.nextval)
4359: into new_item_num
4360: from dual;
4361:
4362: -- 2652379 : When numbering method is 3 , i.e Replace with order num, line num;

Line 4464: select to_char(mtl_system_items_B_S.nextval)

4460: then
4461: IF PG_DEBUG <> 0 THEN
4462: oe_debug_pub.add( 'Create_Item: '|| 'generating unique name' ,2 );
4463: END IF;
4464: select to_char(mtl_system_items_B_S.nextval)
4465: into lNextNum
4466: from dual;
4467: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4468: end if;

Line 4479: select to_char(mtl_system_items_B_S.nextval)

4475:
4476: IF PG_DEBUG <> 0 THEN
4477: oe_debug_pub.add('Create_Item: ' || 'generating unique name' ,2 );
4478: END IF;
4479: select to_char(mtl_system_items_B_S.nextval)
4480: into lNextNum
4481: from dual;
4482: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4483: exit;

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

4489:
4490: oe_debug_pub.add('Create_Item: ' || 'new_item number is ' || seg(app_col_ind) ,2 );
4491: END IF;
4492:
4493: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;
4494:
4495: IF PG_DEBUG <> 0 THEN
4496: oe_debug_pub.add('Create_Item: ' || 'new pConfigId is '||to_char(pConfigId),2);
4497: END IF;