APPS.AHL_MC_ITEMGROUP_PVT dependencies on DUAL

Line 807: FROM DUAL

803: CURSOR chk_top_node_csr(p_relationship_id IN NUMBER,
804: p_inventory_item_id IN NUMBER,
805: p_inventory_org_id IN NUMBER) IS
806: SELECT 'x'
807: FROM DUAL
808: WHERE EXISTS (SELECT name
809: FROM ahl_unit_config_headers unit, csi_item_instances csi
810: WHERE unit.csi_item_instance_id = csi.instance_id
811: AND master_config_id = p_relationship_id

Line 1259: l_item_grp_id from DUAL;

1255:
1256:
1257: --Gets the sequence Number
1258: SELECT AHL_ITEM_GROUPS_B_S.nextval INTO
1259: l_item_grp_id from DUAL;
1260:
1261: l_last_updated_by := to_number(fnd_global.USER_ID);
1262: l_last_update_login := to_number(fnd_global.LOGIN_ID);
1263:

Line 1382: l_item_association_id from DUAL;

1378: l_item_assoc_rec.ATTRIBUTE15 := null;
1379: END IF;
1380: --Gets the sequence Number
1381: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
1382: l_item_association_id from DUAL;
1383:
1384: AHL_ITEM_ASSOCIATIONS_PKG.INSERT_ROW(
1385: X_ROWID => l_row_id,
1386: X_ITEM_ASSOCIATION_ID => l_item_association_id,

Line 2851: Select 'x' from dual

2847: Where item_group_id = c_itemgroup_id;
2848:
2849: CURSOR validate_item_group(c_itemgroup_id NUMBER)
2850: is
2851: Select 'x' from dual
2852: Where exists ( select item_association_id from ahl_item_associations_vl
2853: Where Item_Group_id = c_itemgroup_id and
2854: INTERCHANGE_TYPE_CODE in ('1-WAY INTERCHANGEABLE','2-WAY INTERCHANGEABLE') );
2855:

Line 3351: from dual;

3347: -- Sequence Number for the New Revision.
3348:
3349: Select AHL_ITEM_GROUPS_B_S.nextval
3350: into l_item_group_id
3351: from dual;
3352:
3353: l_last_updated_by := to_number(fnd_global.USER_ID);
3354: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3355: l_created_by := to_number(fnd_global.user_id);

Line 3436: l_item_association_id from DUAL;

3432: LOOP
3433:
3434: --Gets the sequence Number
3435: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
3436: l_item_association_id from DUAL;
3437:
3438:
3439: ahl_item_associations_pkg.insert_row
3440: (

Line 3620: into l_item_associations_h_id from dual;

3616: END IF;
3617:
3618:
3619: Select ahl_item_associations_b_h_s.nextval
3620: into l_item_associations_h_id from dual;
3621:
3622: INSERT INTO ahl_item_groups_b_h
3623: (item_group_h_id ,
3624: item_group_id ,

Line 3727: into l_item_associations_h_id from dual;

3723:
3724: FOR l_item_assos_det IN get_item_assos_det_csr(p_ItemGroups_id) LOOP
3725:
3726: Select ahl_item_associations_b_h_s.nextval
3727: into l_item_associations_h_id from dual;
3728:
3729: AHL_ITEM_ASSOCIATIONS_H_PKG.INSERT_ROW(
3730: X_ROWID => l_rowid,
3731: X_ITEM_ASSOCIATION_H_ID => l_item_associations_h_id ,