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_LTP_MATRL_AVAL_PUB dependencies on STANDARD

Line 32: -- Standard IN Parameters :

28: -- for Routine jobs derived requested quantity and task start date
29: -- Pre-reqs :
30: -- Parameters :
31: --
32: -- Standard IN Parameters :
33: -- p_api_version IN NUMBER Required
34: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
35: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
36: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 40: -- Standard OUT Parameters :

36: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
37: -- Based on this flag, the API will set the default attributes.
38: -- p_module_type In VARCHAR2 Default NULL
39: -- This will be null.
40: -- Standard OUT Parameters :
41: -- x_return_status OUT VARCHAR2 Required
42: -- x_msg_count OUT NUMBER Required
43: -- x_msg_data OUT VARCHAR2 Required
44: --

Line 81: -- Standard Start of API savepoint

77: END IF;
78: -- dbms_output.put_line( 'start public API:');
79:
80: --------------------Initialize ----------------------------------
81: -- Standard Start of API savepoint
82: SAVEPOINT check_material_aval;
83: -- Standard call to check for call compatibility.
84: IF FND_API.to_boolean(p_init_msg_list)
85: THEN

Line 83: -- Standard call to check for call compatibility.

79:
80: --------------------Initialize ----------------------------------
81: -- Standard Start of API savepoint
82: SAVEPOINT check_material_aval;
83: -- Standard call to check for call compatibility.
84: IF FND_API.to_boolean(p_init_msg_list)
85: THEN
86: FND_MSG_PUB.initialize;
87: END IF;

Line 200: --Standard check to count messages

196: END IF;
197: END LOOP;
198: END IF;
199: ------------------------End of Body---------------------------------------
200: --Standard check to count messages
201: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
202: l_msg_count := FND_MSG_PUB.count_msg;
203: IF l_msg_count > 0 THEN
204: RAISE FND_API.G_EXC_ERROR;

Line 208: --Standard check for commit

204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: END IF;
207:
208: --Standard check for commit
209: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
210: COMMIT;
211: END IF;
212:

Line 260: -- Standard IN Parameters :

256: -- visit, which are defined at Route Operation level
257: -- Pre-reqs :
258: -- Parameters :
259: --
260: -- Standard IN Parameters :
261: -- p_api_version IN NUMBER Required
262: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
263: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 268: -- Standard OUT Parameters :

264: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
265: -- Based on this flag, the API will set the default attributes.
266: -- p_module_type In VARCHAR2 Default NULL
267: -- This will be null.
268: -- Standard OUT Parameters :
269: -- x_return_status OUT VARCHAR2 Required
270: -- x_msg_count OUT NUMBER Required
271: -- x_msg_data OUT VARCHAR2 Required
272: --

Line 288: --Standard local variables

284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2)
287: IS
288: --Standard local variables
289: l_api_name CONSTANT VARCHAR2(30) := 'Get_Visit_Task_Materials';
290: l_api_version CONSTANT NUMBER := 1.0;
291: l_msg_count NUMBER;
292: l_return_status VARCHAR2(1);

Line 307: -- Standard Start of API savepoint

303: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Get_Visit_Task_Materials.begin',
304: 'At the start of PLSQL procedure'
305: );
306: END IF;
307: -- Standard Start of API savepoint
308: SAVEPOINT get_visit_task_materials;
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_boolean(p_init_msg_list)
311: THEN

Line 316: -- Standard call to check for call compatibility.

312: FND_MSG_PUB.initialize;
313: END IF;
314: -- Initialize API return status to success
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
318: p_api_version,
319: l_api_name,G_PKG_NAME)
320: THEN

Line 468: --Standard check for commit

464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466: END IF;
467:
468: --Standard check for commit
469: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
470: COMMIT;
471: END IF;
472:

Line 519: -- Standard IN Parameters :

515: -- for Routine jobs associated to a visit
516: -- Pre-reqs :
517: -- Parameters :
518: --
519: -- Standard IN Parameters :
520: -- p_api_version IN NUMBER Required
521: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
522: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
523: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 527: -- Standard OUT Parameters :

523: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
524: -- Based on this flag, the API will set the default attributes.
525: -- p_module_type In VARCHAR2 Default NULL
526: -- This will be null.
527: -- Standard OUT Parameters :
528: -- x_return_status OUT VARCHAR2 Required
529: -- x_msg_count OUT NUMBER Required
530: -- x_msg_data OUT VARCHAR2 Required
531: --

Line 582: -- Standard Start of API savepoint

578: );
579: END IF;
580:
581: --------------------Initialize ----------------------------------
582: -- Standard Start of API savepoint
583: SAVEPOINT check_materials_for_all;
584: -- Standard call to check for call compatibility.
585: IF FND_API.to_boolean(p_init_msg_list)
586: THEN

Line 584: -- Standard call to check for call compatibility.

580:
581: --------------------Initialize ----------------------------------
582: -- Standard Start of API savepoint
583: SAVEPOINT check_materials_for_all;
584: -- Standard call to check for call compatibility.
585: IF FND_API.to_boolean(p_init_msg_list)
586: THEN
587: FND_MSG_PUB.initialize;
588: END IF;

Line 800: --Standard check to count messages

796: END IF;
797: END IF;
798:
799: ------------------------End of Body---------------------------------------
800: --Standard check to count messages
801: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
802: l_msg_count := FND_MSG_PUB.count_msg;
803: IF l_msg_count > 0 THEN
804: RAISE FND_API.G_EXC_ERROR;

Line 808: --Standard check for commit

804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: END IF;
807:
808: --Standard check for commit
809: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
810: COMMIT;
811: END IF;
812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 859: -- Standard IN Parameters :

855: -- for Routine jobs derived requested quantity and task start date
856: -- Pre-reqs :
857: -- Parameters :
858: --
859: -- Standard IN Parameters :
860: -- p_api_version IN NUMBER Required
861: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
862: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
863: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 867: -- Standard OUT Parameters :

863: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
864: -- Based on this flag, the API will set the default attributes.
865: -- p_module_type In VARCHAR2 Default NULL
866: -- This will be null.
867: -- Standard OUT Parameters :
868: -- x_return_status OUT VARCHAR2 Required
869: -- x_msg_count OUT NUMBER Required
870: -- x_msg_data OUT VARCHAR2 Required
871: --

Line 888: --Standard local variables

884: x_msg_count OUT NOCOPY NUMBER,
885: x_msg_data OUT NOCOPY VARCHAR2)
886:
887: IS
888: --Standard local variables
889: l_api_name CONSTANT VARCHAR2(30) := 'Schedule_Planned_Matrls';
890: l_api_version CONSTANT NUMBER := 1.0;
891: l_msg_count NUMBER;
892: l_return_status VARCHAR2(1);

Line 910: -- Standard Start of API savepoint

906: 'At the start of PLSQL procedure'
907: );
908: END IF;
909:
910: -- Standard Start of API savepoint
911: SAVEPOINT Schedule_Planned_Matrls;
912: -- Initialize message list if p_init_msg_list is set to TRUE.
913: IF FND_API.to_boolean(p_init_msg_list)
914: THEN

Line 919: -- Standard call to check for call compatibility.

915: FND_MSG_PUB.initialize;
916: END IF;
917: -- Initialize API return status to success
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: -- Standard call to check for call compatibility.
920: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
921: p_api_version,
922: l_api_name,G_PKG_NAME)
923: THEN

Line 1020: --Standard check for commit

1016: END IF;
1017:
1018: END LOOP;
1019: END IF;
1020: --Standard check for commit
1021: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1022: COMMIT;
1023: END IF;
1024:

Line 1073: -- Standard IN Parameters :

1069: -- for Routine jobs derived requested quantity and task start date
1070: -- Pre-reqs :
1071: -- Parameters :
1072: --
1073: -- Standard IN Parameters :
1074: -- p_api_version IN NUMBER Required
1075: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1076: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1077: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1081: -- Standard OUT Parameters :

1077: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1078: -- Based on this flag, the API will set the default attributes.
1079: -- p_module_type In VARCHAR2 Default NULL
1080: -- This will be null.
1081: -- Standard OUT Parameters :
1082: -- x_return_status OUT VARCHAR2 Required
1083: -- x_msg_count OUT NUMBER Required
1084: -- x_msg_data OUT VARCHAR2 Required
1085: --

Line 1112: --Standard local variables

1108: FROM AHL_VISIT_TASKS_B
1109: WHERE visit_id = c_visit_id
1110: AND status_code = 'PLANNING';
1111: l_dummy number;
1112: --Standard local variables
1113: l_api_name CONSTANT VARCHAR2(30) := 'Schedule_All_Materials';
1114: l_api_version CONSTANT NUMBER := 1.0;
1115: l_msg_count NUMBER;
1116: l_return_status VARCHAR2(1);

Line 1132: -- Standard Start of API savepoint

1128: 'At the start of PLSQL procedure'
1129: );
1130: END IF;
1131:
1132: -- Standard Start of API savepoint
1133: SAVEPOINT Schedule_All_Materials;
1134: -- Initialize message list if p_init_msg_list is set to TRUE.
1135: IF FND_API.to_boolean(p_init_msg_list)
1136: THEN

Line 1141: -- Standard call to check for call compatibility.

1137: FND_MSG_PUB.initialize;
1138: END IF;
1139: -- Initialize API return status to success
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141: -- Standard call to check for call compatibility.
1142: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1143: p_api_version,
1144: l_api_name,G_PKG_NAME)
1145: THEN

Line 1262: --Standard check for commit

1258:
1259: END LOOP;
1260: END IF;
1261:
1262: --Standard check for commit
1263: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1264: COMMIT;
1265: END IF;
1266: