APPS.AHL_REPAIR_CATEGORIES_PVT dependencies on AHL_REPAIR_CATEGORIES

Line 1: PACKAGE BODY AHL_REPAIR_CATEGORIES_PVT AS

1: PACKAGE BODY AHL_REPAIR_CATEGORIES_PVT AS
2: /* $Header: AHLVRCTB.pls 120.12 2006/08/22 07:45:38 priyan noship $ */
3:
4: G_USER_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.USER_ID);
5: G_LOGIN_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.LOGIN_ID);

Line 63: FROM ahl_repair_categories

59: srurg_id in number
60: )
61: IS
62: SELECT 'x'
63: FROM ahl_repair_categories
64: WHERE sr_urgency_id = srurg_id;
65:
66: CURSOR check_reptime_exists
67: (

Line 73: FROM ahl_repair_categories

69: repcat_id in number
70: )
71: IS
72: SELECT 'x'
73: FROM ahl_repair_categories
74: WHERE nvl(repair_time, -1) = nvl(reptime, -1) AND
75: (repcat_id is null or repcat_id <> repair_category_id);
76:
77: CURSOR check_repcat_assoc

Line 93: FROM ahl_repair_categories

89: sr_id in number
90: )
91: IS
92: SELECT 'x'
93: FROM ahl_repair_categories
94: WHERE repair_category_id = rep_cat_id AND
95: sr_urgency_id = sr_id;
96:
97: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_REPAIR_CATEGORIES';

Line 148: DELETE FROM ahl_repair_categories

144: OPEN check_repcat_assoc (p_x_repair_category_tbl(i).repair_category_id);
145: FETCH check_repcat_assoc INTO l_dummy_varchar;
146: IF (check_repcat_assoc%NOTFOUND)
147: THEN
148: DELETE FROM ahl_repair_categories
149: WHERE repair_category_id = p_x_repair_category_tbl(i).repair_category_id;
150: ELSE
151: SELECT cssr.name
152: INTO p_x_repair_category_tbl(i).incident_urgency_name

Line 153: FROM cs_incident_urgencies_vl cssr , ahl_repair_categories repcat

149: WHERE repair_category_id = p_x_repair_category_tbl(i).repair_category_id;
150: ELSE
151: SELECT cssr.name
152: INTO p_x_repair_category_tbl(i).incident_urgency_name
153: FROM cs_incident_urgencies_vl cssr , ahl_repair_categories repcat
154: WHERE repcat.sr_urgency_id = cssr.incident_urgency_id AND
155: repcat.repair_category_id = p_x_repair_category_tbl(i).repair_category_id;
156:
157: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_ATASEQ_DEL');

Line 256: UPDATE AHL_REPAIR_CATEGORIES

252:
253: -- Default values for update
254: p_x_repair_category_tbl(i).object_version_number := p_x_repair_category_tbl(i).object_version_number + 1;
255:
256: UPDATE AHL_REPAIR_CATEGORIES
257: SET OBJECT_VERSION_NUMBER = p_x_repair_category_tbl(i).object_version_number,
258: LAST_UPDATE_DATE = G_SYSDATE,
259: LAST_UPDATED_BY = G_USER_ID,
260: LAST_UPDATE_LOGIN = G_LOGIN_ID,

Line 371: select ahl_repair_categories_s.nextval into p_x_repair_category_tbl(i).repair_category_id from dual;

367:
368: -- Default values for create
369: IF (p_x_repair_category_tbl(i).repair_category_id IS NULL OR p_x_repair_category_tbl(i).repair_category_id = FND_API.G_MISS_NUM)
370: THEN
371: select ahl_repair_categories_s.nextval into p_x_repair_category_tbl(i).repair_category_id from dual;
372: END IF;
373: p_x_repair_category_tbl(i).object_version_number := 1;
374:
375: INSERT INTO AHL_REPAIR_CATEGORIES

Line 375: INSERT INTO AHL_REPAIR_CATEGORIES

371: select ahl_repair_categories_s.nextval into p_x_repair_category_tbl(i).repair_category_id from dual;
372: END IF;
373: p_x_repair_category_tbl(i).object_version_number := 1;
374:
375: INSERT INTO AHL_REPAIR_CATEGORIES
376: (
377: REPAIR_CATEGORY_ID,
378: OBJECT_VERSION_NUMBER,
379: LAST_UPDATE_DATE,

Line 523: FROM ahl_repair_categories

519: p_rep_cat_id in number
520: )
521: IS
522: SELECT object_version_number
523: FROM ahl_repair_categories
524: WHERE repair_category_id = p_rep_cat_id;
525:
526: BEGIN
527:

Line 548: End AHL_REPAIR_CATEGORIES_PVT;

544: CLOSE check_rep_cat_exists;
545:
546: END VALIDATE_REP_CAT_EXISTS;
547:
548: End AHL_REPAIR_CATEGORIES_PVT;