APPS.AHL_RM_PROD_ZONE_AS_PVT dependencies on AHL_PRODTYPE_ZONES

Line 401: FROM AHL_PRODTYPE_ZONES

397: attribute12,
398: attribute13,
399: attribute14,
400: attribute15
401: FROM AHL_PRODTYPE_ZONES
402: WHERE prodtype_zone_id = c_prodtype_zone_id;
403:
404: BEGIN
405:

Line 651: FROM ahl_prodtype_zones

647: l_return_status VARCHAR2(1);
648: l_msg_data VARCHAR2(2000);
649: CURSOR get_zone_assoc (c_product_type_code VARCHAR2, c_zone_code VARCHAR2) IS
650: SELECT product_type_code, zone_code
651: FROM ahl_prodtype_zones
652: WHERE product_type_code = c_product_type_code
653: AND zone_code = c_zone_code;
654: l_zone_assoc get_zone_assoc%ROWTYPE;
655:

Line 686: FROM AHL_PRODTYPE_ZONES_V

682: SELECT zone_code,
683: zone,
684: sub_zone_code,
685: sub_zone
686: FROM AHL_PRODTYPE_ZONES_V
687: WHERE product_type_code = c_product_type_code
688: GROUP BY zone_code,
689: zone,
690: sub_zone_code,

Line 746: FROM ahl_prodtype_zones

742: l_prodtype_zone_id NUMBER;
743:
744: CURSOR get_prod_zone_rec(c_prodtype_zone_id NUMBER) IS
745: SELECT product_type_code, zone_code, sub_zone_code
746: FROM ahl_prodtype_zones
747: WHERE prodtype_zone_id = c_prodtype_zone_id;
748:
749: CURSOR get_route_zone_rec(c_product_type_code VARCHAR2, c_zone_code VARCHAR2) IS
750: SELECT route_id

Line 942: INSERT INTO AHL_PRODTYPE_ZONES

938: FOR i IN 1..p_x_prod_zone_as_tbl.count LOOP
939: IF ( p_x_prod_zone_as_tbl(i).dml_operation = 'C' ) THEN
940: BEGIN
941: -- Insert the record
942: INSERT INTO AHL_PRODTYPE_ZONES
943: (
944: PRODTYPE_ZONE_ID,
945: OBJECT_VERSION_NUMBER,
946: LAST_UPDATE_DATE,

Line 972: AHL_PRODTYPE_ZONES_S.NEXTVAL,

968: ATTRIBUTE14,
969: ATTRIBUTE15
970: ) VALUES
971: (
972: AHL_PRODTYPE_ZONES_S.NEXTVAL,
973: p_x_prod_zone_as_tbl(i).object_version_number,
974: p_x_prod_zone_as_tbl(i).last_update_date,
975: p_x_prod_zone_as_tbl(i).last_updated_by,
976: p_x_prod_zone_as_tbl(i).creation_date,

Line 1016: UPDATE AHL_PRODTYPE_ZONES SET

1012: ELSIF ( p_x_prod_zone_as_tbl(i).dml_operation = 'U' ) THEN
1013:
1014: BEGIN
1015: -- Update the record
1016: UPDATE AHL_PRODTYPE_ZONES SET
1017: object_version_number = object_version_number + 1,
1018: last_update_date = p_x_prod_zone_as_tbl(i).last_update_date,
1019: last_updated_by = p_x_prod_zone_as_tbl(i).last_updated_by,
1020: last_update_login = p_x_prod_zone_as_tbl(i).last_update_login,

Line 1076: DELETE FROM AHL_PRODTYPE_ZONES

1072: END IF;
1073: CLOSE get_prod_zone_rec;
1074:
1075: -- Delete the record
1076: DELETE FROM AHL_PRODTYPE_ZONES
1077: WHERE prodtype_zone_id = p_x_prod_zone_as_tbl(i).prodtype_zone_id
1078: AND object_version_number = p_x_prod_zone_as_tbl(i).object_version_number;
1079:
1080: -- If the record does not exist, then, abort API.

Line 1087: DELETE FROM AHL_PRODTYPE_ZONES

1083: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1084: FND_MSG_PUB.add;
1085: ELSE
1086: IF l_get_prod_zone_rec.sub_zone_code IS NULL THEN
1087: DELETE FROM AHL_PRODTYPE_ZONES
1088: WHERE product_type_code = l_get_prod_zone_rec.product_type_code
1089: AND zone_code = l_get_prod_zone_rec.zone_code;
1090: FOR I IN get_route_zone_rec(l_get_prod_zone_rec.product_type_code,
1091: l_get_prod_zone_rec.zone_code) LOOP