eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_WF_MAPPING_PVT dependencies on AHL_WF_MAPPING

Line 1: PACKAGE BODY AHL_WF_MAPPING_PVT AS

1: PACKAGE BODY AHL_WF_MAPPING_PVT AS
2: /* $Header: AHLVWFMB.pls 120.4 2006/08/23 09:40:48 sathapli noship $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE

Line 6: -- AHL_Wf_Mapping_PVT

2: /* $Header: AHLVWFMB.pls 120.4 2006/08/23 09:40:48 sathapli noship $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE
6: -- AHL_Wf_Mapping_PVT
7: --
8: -- PROCEDURES
9: -- AHL_Wf_Mapping:
10: -- Check_Wf_Mapping_Req_Items

Line 9: -- AHL_Wf_Mapping:

5: -- PACKAGE
6: -- AHL_Wf_Mapping_PVT
7: --
8: -- PROCEDURES
9: -- AHL_Wf_Mapping:
10: -- Check_Wf_Mapping_Req_Items
11: -- Check_Wf_Mapping_UK_Items
12: -- Check_Process_Name
13: -- Check_Default

Line 22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_Wf_Mapping_PVT';

18: -- 20-Jan-2002 shbhanda Created.
19: -----------------------------------------------------------
20: --
21: -- Global CONSTANTS
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_Wf_Mapping_PVT';
23: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
24: G_VALID_NAME CONSTANT NUMBER:= 50;
25:
26: -- Check_Wf_Mapping_Req_Items

Line 121: -- For creation of AHL_WF_MAPPING

117:
118: IF (l_x_Wf_Mapping_tbl.COUNT > 0) THEN
119: FOR i IN l_x_Wf_Mapping_tbl.FIRST..l_x_Wf_Mapping_tbl.LAST LOOP
120: IF (l_x_Wf_Mapping_tbl(i).operation_flag = 'C' or l_x_Wf_Mapping_tbl(i).operation_flag = 'c') THEN
121: -- For creation of AHL_WF_MAPPING
122: Create_Wf_Mapping (
123: p_api_version,
124: p_init_msg_list,
125: p_commit,

Line 137: -- For updation of AHL_WF_MAPPING

133: p_x_Wf_Mapping_tbl(i).Wf_Mapping_Id := x_WF_Mapping_ID;
134:
135: END IF;
136: IF (p_x_Wf_Mapping_tbl(i).operation_flag = 'U' or l_x_Wf_Mapping_tbl(i).operation_flag = 'u') THEN
137: -- For updation of AHL_WF_MAPPING
138: Update_Wf_Mapping (
139: p_api_version ,
140: p_init_msg_list,
141: p_commit,

Line 149: -- For deletion of AHL_WF_MAPPING

145: x_msg_count,
146: x_msg_data);
147: END IF;
148: IF (p_x_Wf_Mapping_tbl(i).operation_flag = 'D' or l_x_Wf_Mapping_tbl(i).operation_flag = 'd') THEN
149: -- For deletion of AHL_WF_MAPPING
150: Delete_wf_mapping (
151: p_api_version,
152: p_init_msg_list,
153: p_commit,

Line 254: SELECT Ahl_Wf_Mapping_S.NEXTVAL

250: l_seed varchar(1) := 'N';
251: l_process_name varchar2(30);
252:
253: CURSOR c_seq IS
254: SELECT Ahl_Wf_Mapping_S.NEXTVAL
255: FROM dual;
256:
257: CURSOR c_id_exists (x_id IN NUMBER) IS
258: SELECT 1

Line 261: FROM AHL_Wf_Mapping

257: CURSOR c_id_exists (x_id IN NUMBER) IS
258: SELECT 1
259: FROM dual
260: WHERE EXISTS (SELECT 1
261: FROM AHL_Wf_Mapping
262: WHERE WF_Mapping_ID = x_id);
263:
264: -- To retrieve item type for the entered process name not selected from LOV's
265: /*cursor c_item_type Is

Line 416: Ahl_Wf_Mapping_Pkg.insert_row (

412:
413: -- Invoke the table handler to create a record
414: --
415: -- l_process_name := UPPER(l_Wf_Mapping_rec.WF_PROCESS_NAME) ;
416: Ahl_Wf_Mapping_Pkg.insert_row (
417: X_ROWID => l_rowid,
418: X_WF_Mapping_ID => l_Wf_Mapping_rec.WF_Mapping_ID,
419: X_OBJECT_VERSION_NUMBER => 1,
420: X_CREATION_DATE => SYSDATE,

Line 636: Ahl_Wf_Mapping_Pkg. UPDATE_ROW (

632: Ahl_Debug_Pub.debug( l_full_name ||':Update');
633: END IF;
634:
635: --l_process_name := UPPER(l_Wf_Mapping_rec.WF_PROCESS_NAME);
636: Ahl_Wf_Mapping_Pkg. UPDATE_ROW (
637: X_WF_Mapping_ID => l_Wf_Mapping_rec.WF_Mapping_ID,
638: X_OBJECT_VERSION_NUMBER => l_Wf_Mapping_rec.OBJECT_VERSION_NUMBER + 1,
639: X_LAST_UPDATE_DATE => SYSDATE,
640: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

Line 802: select 1 from AHL_WF_MAPPING

798: l_count number;
799: l_wf_id number;
800: l_application_usg_code VARCHAR2(30);
801: cursor check_object(c_appl_usg_code IN VARCHAR2) Is
802: select 1 from AHL_WF_MAPPING
803: where APPROVAL_OBJECT is NULL
804: AND APPLICATION_USG_CODE = c_appl_usg_code;
805:
806: CURSOR Cur_object (c_appl_usg_code IN VARCHAR2) IS

Line 807: select wf_mapping_id from AHL_WF_MAPPING where APPROVAL_OBJECT is NULL

803: where APPROVAL_OBJECT is NULL
804: AND APPLICATION_USG_CODE = c_appl_usg_code;
805:
806: CURSOR Cur_object (c_appl_usg_code IN VARCHAR2) IS
807: select wf_mapping_id from AHL_WF_MAPPING where APPROVAL_OBJECT is NULL
808: AND APPLICATION_USG_CODE = c_appl_usg_code;
809:
810: /* CURSOR appl_usg_code (c_appl_usg IN VARCHAR2) IS
811: select lookup_code from fnd_lookup_values_vl

Line 863: FROM Ahl_wf_mapping

859:
860: IS
861: CURSOR c_wf_mapping IS
862: SELECT *
863: FROM Ahl_wf_mapping
864: WHERE wf_mapping_id = p_wf_mapping_id;
865: --
866: -- This is the only exception for using %ROWTYPE.
867: -- We are selecting from the VL view, which may

Line 917: DELETE FROM Ahl_wf_mapping

913: END IF;
914: CLOSE c_wf_mapping;
915: -- Delete TL data
916:
917: DELETE FROM Ahl_wf_mapping
918: WHERE wf_mapping_id = p_wf_mapping_id;
919: IF (SQL%NOTFOUND) THEN
920: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
921: THEN

Line 1171: FROM AHL_Wf_Mapping

1167: )
1168: IS
1169: CURSOR c_Wf_Mapping IS
1170: SELECT *
1171: FROM AHL_Wf_Mapping
1172: WHERE WF_Mapping_ID = p_Wf_Mapping_rec.WF_Mapping_ID;
1173: --
1174: -- This is the only exception for using %ROWTYPE.
1175: --

Line 1274: 'AHL_Wf_Mapping',

1270: IF p_validation_mode = Jtf_Plsql_Api.g_create
1271: AND p_Wf_Mapping_rec.WF_Mapping_ID IS NOT NULL
1272: THEN
1273: IF Ahl_Utility_Pvt.check_uniqueness(
1274: 'AHL_Wf_Mapping',
1275: 'WF_Mapping_ID = ' || p_Wf_Mapping_rec.WF_Mapping_ID
1276: ) = Fnd_Api.g_false
1277: THEN
1278: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

Line 1279: Fnd_Message.set_name ('AHL', 'AHL_WF_MAPPING_DUP_ID');

1275: 'WF_Mapping_ID = ' || p_Wf_Mapping_rec.WF_Mapping_ID
1276: ) = Fnd_Api.g_false
1277: THEN
1278: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1279: Fnd_Message.set_name ('AHL', 'AHL_WF_MAPPING_DUP_ID');
1280: Fnd_Msg_Pub.ADD;
1281: END IF;
1282: x_return_status := Fnd_Api.g_ret_sts_error;
1283: RETURN;

Line 1300: 'AHL_Wf_Mapping',

1296:
1297: -- check if APPROVAL OBJECT is UNIQUE
1298: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1299: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
1300: 'AHL_Wf_Mapping',
1301: 'APPROVAL_OBJECT = ''' || p_Wf_Mapping_rec.approval_object ||
1302: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code || '''');
1303: ELSE
1304: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

Line 1305: 'AHL_Wf_Mapping',

1301: 'APPROVAL_OBJECT = ''' || p_Wf_Mapping_rec.approval_object ||
1302: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code || '''');
1303: ELSE
1304: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
1305: 'AHL_Wf_Mapping',
1306: 'APPROVAL_OBJECT = ''' || p_Wf_Mapping_rec.approval_object ||
1307: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code ||
1308: ''' AND WF_Mapping_ID <> ' || p_Wf_Mapping_rec.WF_Mapping_ID );
1309: END IF;

Line 1320: END Ahl_Wf_Mapping_Pvt;

1316: RETURN;
1317: END IF;
1318: END Check_Wf_Mapping_UK_Items;
1319:
1320: END Ahl_Wf_Mapping_Pvt;