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 197: --Standard check to count messages

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

Line 205: --Standard check for commit

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

Line 257: -- Standard IN Parameters :

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

Line 265: -- Standard OUT Parameters :

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

Line 285: --Standard local variables

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

Line 304: -- Standard Start of API savepoint

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

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

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

Line 465: --Standard check for commit

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

Line 516: -- Standard IN Parameters :

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

Line 524: -- Standard OUT Parameters :

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

Line 579: -- Standard Start of API savepoint

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

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

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

Line 788: --Standard check to count messages

784: END IF;
785: END IF;
786:
787: ------------------------End of Body---------------------------------------
788: --Standard check to count messages
789: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
790: l_msg_count := FND_MSG_PUB.count_msg;
791: IF l_msg_count > 0 THEN
792: RAISE FND_API.G_EXC_ERROR;

Line 796: --Standard check for commit

792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794: END IF;
795:
796: --Standard check for commit
797: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
798: COMMIT;
799: END IF;
800: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 847: -- Standard IN Parameters :

843: -- for Routine jobs derived requested quantity and task start date
844: -- Pre-reqs :
845: -- Parameters :
846: --
847: -- Standard IN Parameters :
848: -- p_api_version IN NUMBER Required
849: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
850: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
851: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 855: -- Standard OUT Parameters :

851: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
852: -- Based on this flag, the API will set the default attributes.
853: -- p_module_type In VARCHAR2 Default NULL
854: -- This will be null.
855: -- Standard OUT Parameters :
856: -- x_return_status OUT VARCHAR2 Required
857: -- x_msg_count OUT NUMBER Required
858: -- x_msg_data OUT VARCHAR2 Required
859: --

Line 876: --Standard local variables

872: x_msg_count OUT NOCOPY NUMBER,
873: x_msg_data OUT NOCOPY VARCHAR2)
874:
875: IS
876: --Standard local variables
877: l_api_name CONSTANT VARCHAR2(30) := 'Schedule_Planned_Matrls';
878: l_api_version CONSTANT NUMBER := 1.0;
879: l_msg_count NUMBER;
880: l_return_status VARCHAR2(1);

Line 898: -- Standard Start of API savepoint

894: 'At the start of PLSQL procedure'
895: );
896: END IF;
897:
898: -- Standard Start of API savepoint
899: SAVEPOINT Schedule_Planned_Matrls;
900: -- Initialize message list if p_init_msg_list is set to TRUE.
901: IF FND_API.to_boolean(p_init_msg_list)
902: THEN

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

903: FND_MSG_PUB.initialize;
904: END IF;
905: -- Initialize API return status to success
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907: -- Standard call to check for call compatibility.
908: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
909: p_api_version,
910: l_api_name,G_PKG_NAME)
911: THEN

Line 999: --Standard check for commit

995: END IF;
996:
997: END LOOP;
998: END IF;
999: --Standard check for commit
1000: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1001: COMMIT;
1002: END IF;
1003:

Line 1052: -- Standard IN Parameters :

1048: -- for Routine jobs derived requested quantity and task start date
1049: -- Pre-reqs :
1050: -- Parameters :
1051: --
1052: -- Standard IN Parameters :
1053: -- p_api_version IN NUMBER Required
1054: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1055: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1056: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1060: -- Standard OUT Parameters :

1056: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1057: -- Based on this flag, the API will set the default attributes.
1058: -- p_module_type In VARCHAR2 Default NULL
1059: -- This will be null.
1060: -- Standard OUT Parameters :
1061: -- x_return_status OUT VARCHAR2 Required
1062: -- x_msg_count OUT NUMBER Required
1063: -- x_msg_data OUT VARCHAR2 Required
1064: --

Line 1091: --Standard local variables

1087: FROM AHL_VISIT_TASKS_B
1088: WHERE visit_id = c_visit_id
1089: AND status_code = 'PLANNING';
1090: l_dummy number;
1091: --Standard local variables
1092: l_api_name CONSTANT VARCHAR2(30) := 'Schedule_All_Materials';
1093: l_api_version CONSTANT NUMBER := 1.0;
1094: l_msg_count NUMBER;
1095: l_return_status VARCHAR2(1);

Line 1111: -- Standard Start of API savepoint

1107: 'At the start of PLSQL procedure'
1108: );
1109: END IF;
1110:
1111: -- Standard Start of API savepoint
1112: SAVEPOINT Schedule_All_Materials;
1113: -- Initialize message list if p_init_msg_list is set to TRUE.
1114: IF FND_API.to_boolean(p_init_msg_list)
1115: THEN

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

1116: FND_MSG_PUB.initialize;
1117: END IF;
1118: -- Initialize API return status to success
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120: -- Standard call to check for call compatibility.
1121: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1122: p_api_version,
1123: l_api_name,G_PKG_NAME)
1124: THEN

Line 1232: --Standard check for commit

1228:
1229: END LOOP;
1230: END IF;
1231:
1232: --Standard check for commit
1233: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1234: COMMIT;
1235: END IF;
1236: