DBA Data[Home] [Help]

APPS.AHL_WORKORDER_SEARCH_PUB dependencies on FND_GLOBAL

Line 36: FND_GLOBAL.apps_initialize(l_user_id,l_resp_id,867);

32: OPEN get_resp_id_csr;
33: FETCH get_resp_id_csr INTO l_resp_id;
34: CLOSE get_resp_id_csr;
35:
36: FND_GLOBAL.apps_initialize(l_user_id,l_resp_id,867);
37: mo_global.init('AHL');
38: return Fnd_Api.G_RET_STS_SUCCESS;
39:
40: END init_user_and_role;

Line 79: --FND_GLOBAL.apps_initialize(1003259,62211,867);

75:
76: BEGIN
77: SAVEPOINT Search_Work_Orders;
78:
79: --FND_GLOBAL.apps_initialize(1003259,62211,867);
80: --mo_global.init('AHL');
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF Fnd_Api.to_boolean(p_init_msg_list)

Line 126: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||

122: 'per_People_F Pf, '||
123: 'per_Person_Types Pt, '||
124: 'Fnd_User fnd '||
125: 'WHERE '||
126: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
127: 'fnd.employee_id = pf.PERSON_ID and '||
128: 'wass.employee_id = pf.PERSON_ID and '||
129: ' pt.Person_Type_Id = Pf.Person_Type_Id And '||
130: 'pt.system_person_type =''EMP'' AND '||

Line 191: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||

187: 'PER_PERSON_TYPES PEPT, '||
188: 'ahl_pp_requirement_v aprv, '||
189: 'Fnd_User fnd '||
190: 'WHERE '||
191: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
192: 'fnd.employee_id = pf.PERSON_ID and '||
193: ' NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||
194: 'PEPT.PERSON_TYPE_ID = pf.PERSON_TYPE_ID AND '||
195: 'PEPT.SYSTEM_PERSON_TYPE =''EMP'' AND '||

Line 210: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||

206: 'ahl_Operation_Resources Opr, '||
207: 'ahl_Work_Assignments Wass, '||
208: 'Fnd_User fnd '||
209: 'WHERE '||
210: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
211: 'fnd.employee_id = pf.PERSON_ID and '||
212: 'NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||
213: 'PEPT.PERSON_TYPE_ID = pf.PERSON_TYPE_ID AND '||
214: 'PEPT.SYSTEM_PERSON_TYPE =''EMP'' AND '||