DBA Data[Home] [Help]

APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on STANDARD

Line 319: -- Standard IN Parameters :

315: -- Function : Derive the start and end times/hours of task associated with a visit
316: -- Pre-reqs :
317: -- Parameters :
318: --
319: -- Standard IN Parameters :
320: -- p_api_version IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 327: -- Standard OUT Parameters :

323: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
324: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
325: -- p_module_type IN VARCHAR2 Default NULL.
326: --
327: -- Standard OUT Parameters :
328: -- x_return_status OUT VARCHAR2 Required
329: -- x_msg_count OUT NUMBER Required
330: -- x_msg_data OUT VARCHAR2 Required
331: --

Line 391: -- Standard start of API savepoint

387: l_junk VARCHAR2(1);
388:
389: BEGIN
390: -- dbms_output.put_line('Entering Derive_Visit_Task_Times');
391: -- Standard start of API savepoint
392: SAVEPOINT Derive_Visit_Task_Times_pvt;
393:
394: -- Standard call to check for call compatibility
395: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 394: -- Standard call to check for call compatibility

390: -- dbms_output.put_line('Entering Derive_Visit_Task_Times');
391: -- Standard start of API savepoint
392: SAVEPOINT Derive_Visit_Task_Times_pvt;
393:
394: -- Standard call to check for call compatibility
395: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
396: G_PKG_NAME) THEN
397: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
398: END IF;

Line 465: -- Standard check of p_commit

461: IF x_msg_count > 0 THEN
462: RAISE Fnd_Api.G_EXC_ERROR;
463: END IF;
464:
465: -- Standard check of p_commit
466: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
467: COMMIT WORK;
468: END IF;
469:

Line 470: -- Standard call to get message count and if count is 1, get message info

466: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
467: COMMIT WORK;
468: END IF;
469:
470: -- Standard call to get message count and if count is 1, get message info
471: Fnd_Msg_Pub.Count_And_Get
472: ( p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => Fnd_Api.g_false

Line 522: -- Standard IN Parameters :

518: -- department during a given period for a given Plan
519: -- Pre-reqs :
520: -- Parameters :
521: --
522: -- Standard IN Parameters :
523: -- p_api_version IN NUMBER Required
524: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
525: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
526: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 530: -- Standard OUT Parameters :

526: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
527: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
528: -- p_module_type IN VARCHAR2 Default NULL.
529: --
530: -- Standard OUT Parameters :
531: -- x_return_status OUT VARCHAR2 Required
532: -- x_msg_count OUT NUMBER Required
533: -- x_msg_data OUT VARCHAR2 Required
534: --

Line 606: -- Standard start of API savepoint

602: l_dummy_table Time_Period_Details_Tbl_Type;
603: l_required_capacity NUMBER;
604: BEGIN
605: -- dbms_output.put_line('Entering Get_Plan_Resources');
606: -- Standard start of API savepoint
607: SAVEPOINT Get_Plan_Resources_pvt;
608:
609: -- Standard call to check for call compatibility
610: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 609: -- Standard call to check for call compatibility

605: -- dbms_output.put_line('Entering Get_Plan_Resources');
606: -- Standard start of API savepoint
607: SAVEPOINT Get_Plan_Resources_pvt;
608:
609: -- Standard call to check for call compatibility
610: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
611: G_PKG_NAME) THEN
612: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
613: END IF;

Line 730: -- Standard check of p_commit

726: IF x_msg_count > 0 THEN
727: RAISE Fnd_Api.G_EXC_ERROR;
728: END IF;
729:
730: -- Standard check of p_commit
731: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
732: COMMIT WORK;
733: END IF;
734:

Line 735: -- Standard call to get message count and if count is 1, get message info

731: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
732: COMMIT WORK;
733: END IF;
734:
735: -- Standard call to get message count and if count is 1, get message info
736: Fnd_Msg_Pub.Count_And_Get
737: ( p_count => x_msg_count,
738: p_data => x_msg_data,
739: p_encoded => Fnd_Api.g_false

Line 783: -- Standard IN Parameters :

779: -- for a given Plan
780: -- Pre-reqs :
781: -- Parameters :
782: --
783: -- Standard IN Parameters :
784: -- p_api_version IN NUMBER Required
785: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
786: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
787: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 791: -- Standard OUT Parameters :

787: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
788: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
789: -- p_module_type IN VARCHAR2 Default NULL.
790: --
791: -- Standard OUT Parameters :
792: -- x_return_status OUT VARCHAR2 Required
793: -- x_msg_count OUT NUMBER Required
794: -- x_msg_data OUT VARCHAR2 Required
795: --

Line 932: -- Standard start of API savepoint

928: l_junk VARCHAR2(1);
929: l_dept_name bom_departments.description%type;
930:
931: BEGIN
932: -- Standard start of API savepoint
933: SAVEPOINT Get_Rsrc_Req_By_Period_pvt;
934:
935: -- Standard call to check for call compatibility
936: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 935: -- Standard call to check for call compatibility

931: BEGIN
932: -- Standard start of API savepoint
933: SAVEPOINT Get_Rsrc_Req_By_Period_pvt;
934:
935: -- Standard call to check for call compatibility
936: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
937: G_PKG_NAME) THEN
938: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
939: END IF;

Line 1430: -- Standard check of p_commit

1426: RAISE Fnd_Api.G_EXC_ERROR;
1427: END IF;
1428:
1429:
1430: -- Standard check of p_commit
1431: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1432: COMMIT WORK;
1433: END IF;
1434:

Line 1435: -- Standard call to get message count and if count is 1, get message info

1431: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1432: COMMIT WORK;
1433: END IF;
1434:
1435: -- Standard call to get message count and if count is 1, get message info
1436: Fnd_Msg_Pub.Count_And_Get
1437: ( p_count => x_msg_count,
1438: p_data => x_msg_data,
1439: p_encoded => Fnd_Api.g_false

Line 1484: -- Standard IN Parameters :

1480: -- for a given Plan
1481: -- Pre-reqs :
1482: -- Parameters :
1483: --
1484: -- Standard IN Parameters :
1485: -- p_api_version IN NUMBER Required
1486: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1487: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1488: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1492: -- Standard OUT Parameters :

1488: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1489: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1490: -- p_module_type IN VARCHAR2 Default NULL.
1491: --
1492: -- Standard OUT Parameters :
1493: -- x_return_status OUT VARCHAR2 Required
1494: -- x_msg_count OUT NUMBER Required
1495: -- x_msg_data OUT VARCHAR2 Required
1496: --

Line 1582: -- Standard start of API savepoint

1578: l_end_time DATE;
1579: l_aso_resource_id NUMBER;
1580: BEGIN
1581: -- dbms_output.put_line('Entering Get_Task_Requirements');
1582: -- Standard start of API savepoint
1583: SAVEPOINT Get_Task_Requirements_pvt;
1584:
1585: -- Standard call to check for call compatibility
1586: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 1585: -- Standard call to check for call compatibility

1581: -- dbms_output.put_line('Entering Get_Task_Requirements');
1582: -- Standard start of API savepoint
1583: SAVEPOINT Get_Task_Requirements_pvt;
1584:
1585: -- Standard call to check for call compatibility
1586: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1587: G_PKG_NAME) THEN
1588: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1589: END IF;

Line 1719: -- Standard check of p_commit

1715: IF x_msg_count > 0 THEN
1716: RAISE Fnd_Api.G_EXC_ERROR;
1717: END IF;
1718:
1719: -- Standard check of p_commit
1720: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1721: COMMIT WORK;
1722: END IF;
1723:

Line 1724: -- Standard call to get message count and if count is 1, get message info

1720: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1721: COMMIT WORK;
1722: END IF;
1723:
1724: -- Standard call to get message count and if count is 1, get message info
1725: Fnd_Msg_Pub.Count_And_Get
1726: ( p_count => x_msg_count,
1727: p_data => x_msg_data,
1728: p_encoded => Fnd_Api.g_false