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

Line 36: -- Standard OUT Parameters :

32: -- for Routine jobs derived requested quantity and task start date
33: -- Pre-reqs :
34: -- Parameters :
35: --
36: -- Standard OUT Parameters :
37: -- x_return_status OUT VARCHAR2 Required
38: --
39: -- Check_Material_Aval Parameters :
40: -- p_calling_module IN NUMBER ,

Line 106: -- Standard Start of API savepoint

102: 'At the start of PL SQL procedure. Inventory item ID : ' || p_inventory_item_id);
103: END IF;
104:
105: --------------------Initialize ----------------------------------
106: -- Standard Start of API savepoint
107: SAVEPOINT check_availability;
108: -- Initialize API return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 397: -- Standard IN Parameters :

393: -- for Routine jobs derived requested quantity and task start date
394: -- Pre-reqs :
395: -- Parameters :
396: --
397: -- Standard IN Parameters :
398: -- p_api_version IN NUMBER Required
399: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
400: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
401: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 405: -- Standard OUT Parameters :

401: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
402: -- Based on this flag, the API will set the default attributes.
403: -- p_module_type In VARCHAR2 Default NULL
404: -- This will be null.
405: -- Standard OUT Parameters :
406: -- x_return_status OUT VARCHAR2 Required
407: -- x_msg_count OUT NUMBER Required
408: -- x_msg_data OUT VARCHAR2 Required
409: --

Line 469: -- Standard Start of API savepoint

465: END IF;
466: -- dbms_output.put_line( 'start private API:');
467:
468: --------------------Initialize ----------------------------------
469: -- Standard Start of API savepoint
470: SAVEPOINT check_material_aval;
471: -- Standard call to check for call compatibility.
472: IF FND_API.to_boolean(p_init_msg_list)
473: THEN

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

467:
468: --------------------Initialize ----------------------------------
469: -- Standard Start of API savepoint
470: SAVEPOINT check_material_aval;
471: -- Standard call to check for call compatibility.
472: IF FND_API.to_boolean(p_init_msg_list)
473: THEN
474: FND_MSG_PUB.initialize;
475: END IF;

Line 669: -- Standard IN Parameters :

665: -- visit, which are defined at Route Operation level
666: -- Pre-reqs :
667: -- Parameters :
668: --
669: -- Standard IN Parameters :
670: -- p_api_version IN NUMBER Required
671: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
672: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
673: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 677: -- Standard OUT Parameters :

673: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
674: -- Based on this flag, the API will set the default attributes.
675: -- p_module_type In VARCHAR2 Default NULL
676: -- This will be null.
677: -- Standard OUT Parameters :
678: -- x_return_status OUT VARCHAR2 Required
679: -- x_msg_count OUT NUMBER Required
680: -- x_msg_data OUT VARCHAR2 Required
681: --

Line 722: --Standard local variables

718: AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'
719: AND LOOKUP_code = task_status_code;
720: c_Visit_Task_Matrl_Rec Visit_Task_Matrl_Cur%ROWTYPE;
721:
722: --Standard local variables
723: l_api_name CONSTANT VARCHAR2(30) := 'Get_Visit_Task_Materials';
724: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
725: l_api_version CONSTANT NUMBER := 1.0;
726: l_return_status VARCHAR2(1);

Line 738: -- Standard Start of API savepoint

734: fnd_log.string(l_log_procedure,
735: L_DEBUG_KEY ||'.begin',
736: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
737: END IF;
738: -- Standard Start of API savepoint
739: SAVEPOINT Get_Visit_Task_Materials;
740: -- Initialize message list if p_init_msg_list is set to TRUE.
741: IF FND_API.to_boolean(p_init_msg_list) THEN
742: FND_MSG_PUB.initialize;

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

742: FND_MSG_PUB.initialize;
743: END IF;
744: -- Initialize API return status to success
745: x_return_status := FND_API.G_RET_STS_SUCCESS;
746: -- Standard call to check for call compatibility.
747: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
748: l_api_version,
749: l_api_name,G_PKG_NAME)
750: THEN

Line 902: -- Standard IN Parameters :

898: -- for Routine jobs derived requested quantity and task start date
899: -- Pre-reqs :
900: -- Parameters :
901: --
902: -- Standard IN Parameters :
903: -- p_api_version IN NUMBER Required
904: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
905: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
906: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 910: -- Standard OUT Parameters :

906: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
907: -- Based on this flag, the API will set the default attributes.
908: -- p_module_type In VARCHAR2 Default NULL
909: -- This will be null.
910: -- Standard OUT Parameters :
911: -- x_return_status OUT VARCHAR2 Required
912: -- x_msg_count OUT NUMBER Required
913: -- x_msg_data OUT VARCHAR2 Required
914: --

Line 974: --Standard local variables

970: CURSOR Instance_Id_Cur IS
971: SELECT instance_id
972: FROM MRP_AP_APPS_INSTANCES;
973:
974: --Standard local variables
975: l_api_name CONSTANT VARCHAR2(30) := 'CALL_ATP';
976: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
977: l_api_version CONSTANT NUMBER := 1.0;
978: l_return_status VARCHAR2(1);

Line 1007: -- Standard Start of API savepoint

1003: fnd_log.string(l_log_procedure,
1004: L_DEBUG_KEY ||'.begin',
1005: 'At the start of PL SQL procedure. Number of Records : ' || l_planned_matrl_tbl.COUNT);
1006: END IF;
1007: -- Standard Start of API savepoint
1008: SAVEPOINT Call_ATP;
1009: -- Initialize message list if p_init_msg_list is set to TRUE.
1010: IF FND_API.to_boolean(p_init_msg_list) THEN
1011: FND_MSG_PUB.initialize;

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

1011: FND_MSG_PUB.initialize;
1012: END IF;
1013: -- Initialize API return status to success
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015: -- Standard call to check for call compatibility.
1016: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1017: l_api_version,
1018: l_api_name,G_PKG_NAME)
1019: THEN

Line 1311: -- Standard IN Parameters :

1307: -- for Routine jobs derived requested quantity and task start date
1308: -- Pre-reqs :
1309: -- Parameters :
1310: --
1311: -- Standard IN Parameters :
1312: -- p_api_version IN NUMBER Required
1313: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1314: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1315: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1319: -- Standard OUT Parameters :

1315: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1316: -- Based on this flag, the API will set the default attributes.
1317: -- p_module_type In VARCHAR2 Default NULL
1318: -- This will be null.
1319: -- Standard OUT Parameters :
1320: -- x_return_status OUT VARCHAR2 Required
1321: -- x_msg_count OUT NUMBER Required
1322: -- x_msg_data OUT VARCHAR2 Required
1323: --

Line 1370: --Standard local variables

1366: WHERE schedule_material_id = c_sch_mat_id
1367: AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'
1368: AND LOOKUP_code = task_status_code;
1369:
1370: --Standard local variables
1371: l_api_name CONSTANT VARCHAR2(30) := 'Schedule_Planned_Matrls';
1372: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
1373: l_api_version CONSTANT NUMBER := 1.0;
1374: l_return_status VARCHAR2(1);

Line 1390: -- Standard Start of API savepoint

1386: fnd_log.string(l_log_procedure,
1387: L_DEBUG_KEY ||'.begin',
1388: 'At the start of PL SQL procedure. Number of Records : ' || l_planned_matrl_tbl.COUNT);
1389: END IF;
1390: -- Standard Start of API savepoint
1391: SAVEPOINT schedule_planned_matrls;
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_boolean(p_init_msg_list) THEN
1394: FND_MSG_PUB.initialize;

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

1394: FND_MSG_PUB.initialize;
1395: END IF;
1396: -- Initialize API return status to success
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398: -- Standard call to check for call compatibility.
1399: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1400: l_api_version,
1401: l_api_name,G_PKG_NAME)
1402: THEN

Line 1530: -- Standard check of p_commit

1526: END IF;
1527: END LOOP;
1528: END IF;
1529:
1530: -- Standard check of p_commit
1531: IF FND_API.TO_BOOLEAN(p_commit) THEN
1532: COMMIT WORK;
1533: END IF;
1534:

Line 1579: -- Standard IN Parameters :

1575: -- for Routine jobs derived requested quantity and task start date
1576: -- Pre-reqs :
1577: -- Parameters :
1578: --
1579: -- Standard IN Parameters :
1580: -- p_api_version IN NUMBER Required
1581: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1582: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1583: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1587: -- Standard OUT Parameters :

1583: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1584: -- Based on this flag, the API will set the default attributes.
1585: -- p_module_type In VARCHAR2 Default NULL
1586: -- This will be null.
1587: -- Standard OUT Parameters :
1588: -- x_return_status OUT VARCHAR2 Required
1589: -- x_msg_count OUT NUMBER Required
1590: -- x_msg_data OUT VARCHAR2 Required
1591: --

Line 1631: --Standard local variables

1627: AND NVL(schm.status, 'X') <> 'IN-SERVICE' --Added by sowsubra for Issue 105
1628: AND schm.visit_id = C_VISIT_ID;
1629: -- yazhou 03-JUL-2006 ends
1630:
1631: --Standard local variables
1632: l_api_name CONSTANT VARCHAR2(30) := 'Schedule_All_Materials';
1633: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
1634: l_api_version CONSTANT NUMBER := 1.0;
1635: l_return_status VARCHAR2(1);

Line 1649: -- Standard Start of API savepoint

1645: fnd_log.string(l_log_procedure,
1646: L_DEBUG_KEY ||'.begin',
1647: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
1648: END IF;
1649: -- Standard Start of API savepoint
1650: SAVEPOINT Schedule_All_Materials;
1651: -- Initialize message list if p_init_msg_list is set to TRUE.
1652: IF FND_API.to_boolean(p_init_msg_list) THEN
1653: FND_MSG_PUB.initialize;

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

1653: FND_MSG_PUB.initialize;
1654: END IF;
1655: -- Initialize API return status to success
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657: -- Standard call to check for call compatibility.
1658: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1659: l_api_version,
1660: l_api_name,G_PKG_NAME)
1661: THEN

Line 1751: -- Standard check of p_commit

1747: ', Error Message : ' || x_planned_matrl_tbl(i).error_message);
1748: END IF;
1749: END LOOP;
1750: END IF;
1751: -- Standard check of p_commit
1752: IF FND_API.TO_BOOLEAN(p_commit) THEN
1753: COMMIT WORK;
1754: END IF;
1755: