APPS.CTO_MSUTIL_PUB dependencies on DUAL

Line 3183: FROM DUAL;

3179: -- get assignment id for config item
3180: --
3181: SELECT mrp_sr_assignments_s.nextval
3182: INTO lConfigAssignmentId
3183: FROM DUAL;
3184:
3185: --
3186: -- form lAssignmentTbl from lAssignmentRec
3187: --

Line 3716: FROM DUAL;

3712:
3713:
3714: SELECT mrp_sr_assignments_s.nextval
3715: INTO lConfigAssignmentId
3716: FROM DUAL;
3717:
3718: --
3719: -- form lAssignmentTbl from lAssignmentRec
3720: --

Line 4095: from dual

4091: gLoginId, -- last_update_login
4092: null, -- program_application_id,??
4093: null, -- program_id,??
4094: sysdate -- program_update_date
4095: from dual
4096: where NOT EXISTS
4097: (select NULL
4098: from bom_cto_src_orgs_b
4099: where line_id = p_model_line_id

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

4287: begin
4288:
4289: oe_debug_pub.add( '$$$ insert type3 bcmo bcso ' , 1 ) ;
4290:
4291: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4292:
4293:
4294:
4295: insert into bom_cto_model_orgs

Line 4401: from dual

4397: gLoginId, -- last_update_login
4398: null, -- program_application_id,??
4399: null, -- program_id,??
4400: sysdate -- program_update_date
4401: from dual
4402: where NOT EXISTS
4403: (select NULL
4404: from bom_cto_src_orgs_b
4405: where line_id = p_model_line_id );

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

4436: exception
4437: when no_data_found then
4438:
4439: oe_debug_pub.add( '$$$ short circuit for type3 referenced bcso ' , 1 ) ;
4440: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4441:
4442:
4443:
4444: insert into bom_cto_model_orgs

Line 4550: from dual

4546: gLoginId, -- last_update_login
4547: null, -- program_application_id,??
4548: null, -- program_id,??
4549: sysdate -- program_update_date
4550: from dual
4551: where NOT EXISTS
4552: (select NULL
4553: from bom_cto_src_orgs_b
4554: where line_id = p_model_line_id );

Line 4722: from dual

4718:
4719:
4720: begin
4721: select 'Y' into l_chk_org
4722: from dual
4723: where EXISTS (
4724: select 1
4725: from bom_cto_src_orgs
4726: where line_id = pModelLineId

Line 4851: from dual

4847: begin
4848: -- rkaza. 3742393. 08/12/2004.
4849: -- Repalcing org_organization_definitions with inv_organization_info_v
4850: select 'Y' into l_chk_own_oper_unit
4851: from dual
4852: where EXISTS (
4853: select po_header_id
4854: from po_ga_org_assignments
4855: where enabled_flag = 'Y'

Line 5073: select 'Y' into v_procured_models_exist from dual

5069: v_receiving_org number ;
5070: begin
5071: begin
5072:
5073: select 'Y' into v_procured_models_exist from dual
5074: where exists
5075: ( select * from bom_cto_src_orgs_b
5076: where line_id = p_line_id
5077: and model_item_id = p_model_item_id

Line 5097: select 'Y' into v_bom_created from dual

5093: begin
5094:
5095: v_bom_created := 'N' ;
5096:
5097: select 'Y' into v_bom_created from dual
5098: where exists
5099: ( select * from bom_cto_src_orgs_b where line_id = p_line_id
5100: and model_item_id = p_model_item_id
5101: and create_bom = 'Y' );