DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on STANDARD

Line 73: -- Standard IN Parameters :

69: --
70: -- Pre-reqs :
71: -- Parameters :
72: --
73: -- Standard IN Parameters :
74: -- p_api_version IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 79: -- Standard OUT Parameters :

75: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
78: --
79: -- Standard OUT Parameters :
80: -- x_return_status OUT VARCHAR2 Required
81: -- x_msg_count OUT NUMBER Required
82: -- x_msg_data OUT VARCHAR2 Required
83: --

Line 168: --Standard local variables

164: SELECT VISIT_TASK_NUMBER
165: FROM ahl_visit_tasks_b
166: where visit_task_id = p_task_id;
167:
168: --Standard local variables
169: l_task_number number;
170: l_api_name CONSTANT VARCHAR2(30) := 'Get_Task_Cost_Details';
171: l_api_version CONSTANT NUMBER := 1.0;
172:

Line 203: -- Standard start of API savepoint

199: 'At the start of PLSQL procedure'
200: );
201: END IF;
202:
203: -- Standard start of API savepoint
204: SAVEPOINT Get_Task_Cost_Details;
205:
206: -- Initialize message list if p_init_msg_list is set to TRUE
207: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 757: -- Standard check of p_commit

753: IF x_msg_count > 0 THEN
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756:
757: -- Standard check of p_commit
758: p_x_cost_price_rec:=l_cost_price_rec;
759: IF FND_API.TO_BOOLEAN(p_commit) THEN
760: COMMIT WORK;
761: END IF;

Line 812: -- Standard IN Parameters :

808: --
809: -- Pre-reqs :
810: -- Parameters :
811: --
812: -- Standard IN Parameters :
813: -- p_api_version IN NUMBER Required
814: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
815: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
816: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 818: -- Standard OUT Parameters :

814: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
815: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
816: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
817: --
818: -- Standard OUT Parameters :
819: -- x_return_status OUT VARCHAR2 Required
820: -- x_msg_count OUT NUMBER Required
821: -- x_msg_data OUT VARCHAR2 Required
822: --

Line 932: -- Standard start of API savepoint

928: );
929:
930: END IF;
931:
932: -- Standard start of API savepoint
933: SAVEPOINT Update_Task_Cost_Details;
934:
935: -- Initialize message list if p_init_msg_list is set to TRUE
936: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 1227: -- Standard check of p_commit

1223: IF x_msg_count > 0 THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:
1227: -- Standard check of p_commit
1228: IF FND_API.TO_BOOLEAN(p_commit) THEN
1229: COMMIT WORK;
1230: END IF;
1231:

Line 1282: -- Standard IN Parameters :

1278: --
1279: -- Pre-reqs :
1280: -- Parameters :
1281: --
1282: -- Standard IN Parameters :
1283: -- p_api_version IN NUMBER Required
1284: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1285: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1286: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1288: -- Standard OUT Parameters :

1284: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1285: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1286: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1287: --
1288: -- Standard OUT Parameters :
1289: -- x_return_status OUT VARCHAR2 Required
1290: -- x_msg_count OUT NUMBER Required
1291: -- x_msg_data OUT VARCHAR2 Required
1292: --

Line 1353: -- Standard start of API savepoint

1349: );
1350:
1351: END IF;
1352:
1353: -- Standard start of API savepoint
1354: SAVEPOINT Estimate_Task_Cost;
1355:
1356: -- Initialize message list if p_init_msg_list is set to TRUE
1357: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 1522: -- Standard check of p_commit

1518: p_x_cost_price_rec.cost_session_id := l_cost_price_rec.cost_session_id;
1519: p_x_cost_price_rec.mr_session_id := l_cost_price_rec.mr_session_id;
1520: p_x_cost_price_rec.Is_Cst_Struc_updated := l_cost_price_rec.Is_Cst_Struc_updated;
1521:
1522: -- Standard check of p_commit
1523: IF FND_API.TO_BOOLEAN(p_commit) THEN
1524: COMMIT WORK;
1525: END IF;
1526:

Line 1576: -- Standard IN Parameters :

1572: --
1573: -- Pre-reqs :
1574: -- Parameters :
1575: --
1576: -- Standard IN Parameters :
1577: -- p_api_version IN NUMBER Required
1578: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1579: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1580: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1582: -- Standard OUT Parameters :

1578: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1579: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1580: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1581: --
1582: -- Standard OUT Parameters :
1583: -- x_return_status OUT VARCHAR2 Required
1584: -- x_msg_count OUT NUMBER Required
1585: -- x_msg_data OUT VARCHAR2 Required
1586: --

Line 1662: --Standard local variables

1658: CONNECT BY PRIOR originating_task_id = visit_task_id;
1659:
1660: l_parent_task_rec Get_parent_task_cur%ROWTYPE;
1661:
1662: --Standard local variables
1663: l_api_name CONSTANT VARCHAR2(30) := 'Estimate_Task_Price';
1664: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
1665: l_api_version CONSTANT NUMBER := 1.0;
1666: l_msg_data VARCHAR2(2000);

Line 1701: -- Standard start of API savepoint

1697: 'At the start of PLSQL procedure'
1698: );
1699:
1700: END IF;
1701: -- Standard start of API savepoint
1702: SAVEPOINT Estimate_Task_Price;
1703: -- Initialize message list if p_init_msg_list is set to TRUE
1704: IF FND_API.To_Boolean( p_init_msg_list) THEN
1705: FND_MSG_PUB.Initialize;

Line 2567: -- Standard check of p_commit

2563: IF x_msg_count > 0 THEN
2564: RAISE FND_API.G_EXC_ERROR;
2565: END IF;
2566:
2567: -- Standard check of p_commit
2568: IF FND_API.TO_BOOLEAN(p_commit) THEN
2569: COMMIT WORK;
2570: END IF;
2571:

Line 2621: -- Standard IN Parameters :

2617: --
2618: -- Pre-reqs :
2619: -- Parameters :
2620: --
2621: -- Standard IN Parameters :
2622: -- p_api_version IN NUMBER Required
2623: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2624: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2625: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2627: -- Standard OUT Parameters :

2623: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2624: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2625: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2626: --
2627: -- Standard OUT Parameters :
2628: -- x_return_status OUT VARCHAR2 Required
2629: -- x_msg_count OUT NUMBER Required
2630: -- x_msg_data OUT VARCHAR2 Required
2631: --

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

2678: 'mr_Sesion_id'||l_cost_price_rec.mr_session_id|| ' cost session_id '||l_cost_price_rec.cost_Session_id
2679: );
2680: END IF;
2681:
2682: -- Standard call to check for call compatibility
2683: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2684: G_PKG_NAME) THEN
2685: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2686: END IF;

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

3022: END IF;
3023:
3024: SAVEPOINT GET_TASK_ITEMS_NO_PRICE_PVT;
3025:
3026: -- Standard call to check for call compatibility
3027: IF NOT Fnd_Api.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
3028: G_PKG_NAME) THEN
3029: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3030: END IF;

Line 3450: -- Standard check of p_commit

3446: END IF;
3447:
3448: x_cost_price_tbl:=l_cost_price_tbl;
3449:
3450: -- Standard check of p_commit
3451: IF FND_API.TO_BOOLEAN(p_commit) THEN
3452: COMMIT;
3453: END IF;
3454:

Line 3610: -- Standard check of p_commit

3606: END IF;
3607:
3608: x_item_tbl:=l_item_tbl;
3609:
3610: -- Standard check of p_commit
3611: IF FND_API.TO_BOOLEAN(p_commit) THEN
3612: COMMIT WORK;
3613: END IF;
3614:

Line 3930: -- Standard check of p_commit

3926: END IF;
3927:
3928: x_item_tbl:=l_item_tbl;
3929:
3930: -- Standard check of p_commit
3931: IF FND_API.TO_BOOLEAN(p_commit) THEN
3932: COMMIT WORK;
3933: END IF;
3934: