APPS.CTO_MSUTIL_PUB dependencies on DUAL

Line 3379: FROM DUAL;

3375: -- get assignment id for config item
3376: --
3377: SELECT mrp_sr_assignments_s.nextval
3378: INTO lConfigAssignmentId
3379: FROM DUAL;
3380:
3381: --
3382: -- form lAssignmentTbl from lAssignmentRec
3383: --

Line 4139: FROM DUAL;

4135:
4136:
4137: SELECT mrp_sr_assignments_s.nextval
4138: INTO lConfigAssignmentId
4139: FROM DUAL;
4140:
4141: --
4142: -- form lAssignmentTbl from lAssignmentRec
4143: --

Line 4612: from dual

4608: gLoginId, -- last_update_login
4609: null, -- program_application_id,??
4610: null, -- program_id,??
4611: sysdate -- program_update_date
4612: from dual
4613: where NOT EXISTS
4614: (select NULL
4615: from bom_cto_src_orgs_b
4616: where line_id = p_model_line_id

Line 4808: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;

4804: begin
4805:
4806: oe_debug_pub.add( '$$$ insert type3 bcmo bcso ' , 1 ) ;
4807:
4808: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4809:
4810:
4811:
4812: insert into bom_cto_model_orgs

Line 4918: from dual

4914: gLoginId, -- last_update_login
4915: null, -- program_application_id,??
4916: null, -- program_id,??
4917: sysdate -- program_update_date
4918: from dual
4919: where NOT EXISTS
4920: (select NULL
4921: from bom_cto_src_orgs_b
4922: where line_id = p_model_line_id );

Line 4965: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;

4961: exception
4962: when no_data_found then
4963:
4964: oe_debug_pub.add( '$$$ short circuit for type3 referenced bcso ' , 1 ) ;
4965: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4966:
4967:
4968:
4969: insert into bom_cto_model_orgs

Line 5079: from dual

5075: gLoginId, -- last_update_login
5076: null, -- program_application_id,??
5077: null, -- program_id,??
5078: sysdate -- program_update_date
5079: from dual
5080: where NOT EXISTS
5081: (select NULL
5082: from bom_cto_src_orgs_b
5083: where line_id = p_model_line_id );

Line 5252: from dual

5248:
5249:
5250: begin
5251: select 'Y' into l_chk_org
5252: from dual
5253: where EXISTS (
5254: select 1
5255: from bom_cto_src_orgs
5256: where line_id = pModelLineId

Line 5381: from dual

5377: begin
5378: -- rkaza. 3742393. 08/12/2004.
5379: -- Repalcing org_organization_definitions with inv_organization_info_v
5380: select 'Y' into l_chk_own_oper_unit
5381: from dual
5382: where EXISTS (
5383: select po_header_id
5384: from po_ga_org_assignments
5385: where enabled_flag = 'Y'

Line 5603: select 'Y' into v_procured_models_exist from dual

5599: v_receiving_org number ;
5600: begin
5601: begin
5602:
5603: select 'Y' into v_procured_models_exist from dual
5604: where exists
5605: ( select * from bom_cto_src_orgs_b
5606: where line_id = p_line_id
5607: and model_item_id = p_model_item_id

Line 5627: select 'Y' into v_bom_created from dual

5623: begin
5624:
5625: v_bom_created := 'N' ;
5626:
5627: select 'Y' into v_bom_created from dual
5628: where exists
5629: ( select * from bom_cto_src_orgs_b where line_id = p_line_id
5630: and model_item_id = p_model_item_id
5631: and create_bom = 'Y' );