APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 1078: FROM AHL_MR_RELATIONSHIPS

1074:
1075: IF p_mr_header_rec.TYPE_CODE<>l_mr_rec.type_code
1076: THEN
1077: SELECT COUNT(*) INTO l_counter
1078: FROM AHL_MR_RELATIONSHIPS
1079: WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
1080: AND RELATIONSHIP_CODE = 'PARENT';
1081: IF l_counter >0
1082: THEN

Line 1301: from ahl_mr_relationships

1297: c_mr_header_id number
1298: )
1299: IS
1300: select 'x'
1301: from ahl_mr_relationships
1302: where relationship_code <> 'PARENT'
1303: and (mr_header_id = c_mr_header_id
1304: or related_mr_header_id = c_mr_header_id);
1305:

Line 1320: from AHL_MR_RELATIONSHIPS

1316: --sukhwsin::Complex Assembly Maintenance Changes - starts
1317: CURSOR CHECK_GROUP_MR(c_mr_header_id NUMBER)
1318: IS
1319: select 'x'
1320: from AHL_MR_RELATIONSHIPS
1321: where relationship_code = 'PARENT'
1322: and (MR_HEADER_ID=c_mr_header_id or RELATED_MR_HEADER_ID=c_mr_header_id);
1323:
1324: CURSOR CHK_MR_IN_LOOP_OR_CHAIN (c_mr_header_id NUMBER, c_relationship_code VARCHAR2)

Line 2840: Delete AHL_MR_RELATIONSHIPS

2836: End if;
2837: End loop;
2838: Close curGetMrdocAssociations;
2839:
2840: Delete AHL_MR_RELATIONSHIPS
2841: Where mr_header_id=p_mr_header_id
2842: or RELATED_MR_HEADER_ID=P_MR_HEADER_ID;
2843:
2844: -- Changes for SBE Begin: Delete the relation from MR loop/chain relationships table