APPS.AHL_RM_ROUTE_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 2690: DELETE AHL_RT_OPER_MATERIALS

2686: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Effectivities' );
2687: END IF;
2688:
2689: -- 1.Delete Material Requirements
2690: DELETE AHL_RT_OPER_MATERIALS
2691: WHERE OBJECT_ID = p_route_id
2692: AND ASSOCIATION_TYPE_CODE = 'ROUTE';
2693:
2694: -- If no records exist, then, Continue.

Line 3281: INSERT INTO AHL_RT_OPER_MATERIALS

3277: l_get_route_efcts.ATTRIBUTE14,
3278: l_get_route_efcts.ATTRIBUTE15
3279: );
3280:
3281: INSERT INTO AHL_RT_OPER_MATERIALS
3282: (
3283: RT_OPER_MATERIAL_ID,
3284: OBJECT_VERSION_NUMBER,
3285: OBJECT_ID,

Line 3320: AHL_RT_OPER_MATERIALS_S.NEXTVAL,

3316: CREATED_BY,
3317: LAST_UPDATE_LOGIN,
3318: IN_SERVICE --pdoki added for OGMA 105 issue
3319: ) SELECT
3320: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
3321: 1,
3322: l_route_effectivity_id,
3323: 'DISPOSITION',
3324: position_path_id ,

Line 3356: FROM AHL_RT_OPER_MATERIALS

3352: creation_date,
3353: created_by,
3354: last_update_login,
3355: in_service --pdoki added for OGMA 105 issue
3356: FROM AHL_RT_OPER_MATERIALS
3357: WHERE OBJECT_ID = l_get_route_efcts.route_effectivity_id
3358: ;
3359:
3360: END LOOP;

Line 3363: INSERT INTO AHL_RT_OPER_MATERIALS

3359:
3360: END LOOP;
3361:
3362: -- 1.Copy Material Requirements
3363: INSERT INTO AHL_RT_OPER_MATERIALS
3364: (
3365: RT_OPER_MATERIAL_ID,
3366: OBJECT_VERSION_NUMBER,
3367: OBJECT_ID,

Line 3399: AHL_RT_OPER_MATERIALS_S.NEXTVAL,

3395: LAST_UPDATE_LOGIN,
3396: IN_SERVICE --pdoki added for OGMA 105 issue
3397: )
3398: SELECT
3399: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
3400: 1,
3401: l_route_id,
3402: ASSOCIATION_TYPE_CODE,
3403: ITEM_GROUP_ID,

Line 3431: FROM AHL_RT_OPER_MATERIALS

3427: SYSDATE,
3428: FND_GLOBAL.user_id,
3429: FND_GLOBAL.login_id,
3430: IN_SERVICE --pdoki added for OGMA 105 issue
3431: FROM AHL_RT_OPER_MATERIALS
3432: WHERE object_id = p_route_id
3433: AND association_type_code = 'ROUTE';
3434:
3435: -- 2.Copy Resource Requirements and Alternate Resources