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 1257: l_item_grp_id from DUAL;

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

Line 1380: l_item_association_id from DUAL;

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

Line 2841: Select 'x' from dual

2837: Where item_group_id = c_itemgroup_id;
2838:
2839: CURSOR validate_item_group(c_itemgroup_id NUMBER)
2840: is
2841: Select 'x' from dual
2842: Where exists ( select item_association_id from ahl_item_associations_vl
2843: Where Item_Group_id = c_itemgroup_id and
2844: INTERCHANGE_TYPE_CODE in ('1-WAY INTERCHANGEABLE','2-WAY INTERCHANGEABLE') );
2845:

Line 3341: from dual;

3337: -- Sequence Number for the New Revision.
3338:
3339: Select AHL_ITEM_GROUPS_B_S.nextval
3340: into l_item_group_id
3341: from dual;
3342:
3343: l_last_updated_by := to_number(fnd_global.USER_ID);
3344: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3345: l_created_by := to_number(fnd_global.user_id);

Line 3426: l_item_association_id from DUAL;

3422: LOOP
3423:
3424: --Gets the sequence Number
3425: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
3426: l_item_association_id from DUAL;
3427:
3428:
3429: ahl_item_associations_pkg.insert_row
3430: (

Line 3610: into l_item_associations_h_id from dual;

3606: END IF;
3607:
3608:
3609: Select ahl_item_associations_b_h_s.nextval
3610: into l_item_associations_h_id from dual;
3611:
3612: INSERT INTO ahl_item_groups_b_h
3613: (item_group_h_id ,
3614: item_group_id ,

Line 3717: into l_item_associations_h_id from dual;

3713:
3714: FOR l_item_assos_det IN get_item_assos_det_csr(p_ItemGroups_id) LOOP
3715:
3716: Select ahl_item_associations_b_h_s.nextval
3717: into l_item_associations_h_id from dual;
3718:
3719: AHL_ITEM_ASSOCIATIONS_H_PKG.INSERT_ROW(
3720: X_ROWID => l_rowid,
3721: X_ITEM_ASSOCIATION_H_ID => l_item_associations_h_id ,