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

Line 43: -- Standard IN Parameters :

39: -- Type : Private
40: -- Function : To push a visit to production
41: -- Parameters :
42: --
43: -- Standard IN Parameters :
44: -- p_api_version IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
46: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
47: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 51: -- Standard OUT Parameters :

47: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
48: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
49: -- p_module_type IN VARCHAR2 Default NULL.
50: --
51: -- Standard OUT Parameters :
52: -- x_return_status OUT VARCHAR2 Required
53: -- x_msg_count OUT NUMBER Required
54: -- x_msg_data OUT VARCHAR2 Required
55: --

Line 84: -- Standard IN Parameters :

80: -- Type : Private
81: -- Function : To push a MR to production
82: -- Parameters :
83: --
84: -- Standard IN Parameters :
85: -- p_api_version IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
87: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 91: -- Standard OUT Parameters :

87: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
89: -- p_module_type IN VARCHAR2 Default NULL.
90: --
91: -- Standard OUT Parameters :
92: -- x_return_status OUT VARCHAR2 Required
93: -- x_msg_count OUT NUMBER Required
94: -- x_msg_data OUT VARCHAR2 Required
95: --

Line 128: -- Standard IN Parameters :

124: -- Function : To add Project Task for all the tasks for a given MR
125: -- when SR tasks are created in prodution
126: -- Parameters :
127: --
128: -- Standard IN Parameters :
129: -- p_api_version IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
131: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 136: -- Standard OUT Parameters :

132: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
133: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
134: -- p_module_type IN VARCHAR2 Default NULL.
135: --
136: -- Standard OUT Parameters :
137: -- x_return_status OUT VARCHAR2 Required
138: -- x_msg_count OUT NUMBER Required
139: -- x_msg_data OUT VARCHAR2 Required
140: --

Line 180: -- Standard OUT Parameters :

176: -- Type : Private
177: -- Function : Validate the tasks before pushing the tasks to prodn.
178: -- Parameters :
179: --
180: -- Standard OUT Parameters :
181: -- x_return_status OUT VARCHAR2 Required
182: -- x_msg_count OUT NUMBER Required
183: -- x_msg_data OUT VARCHAR2 Required
184: --

Line 209: -- Standard IN Parameters :

205: -- Type : Private
206: -- Function : Push the selected tasks to production.
207: -- Parameters :
208: --
209: -- Standard IN Parameters :
210: -- p_api_version IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 216: -- Standard OUT Parameters :

212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214: -- p_module_type IN VARCHAR2 Default Null
215: --
216: -- Standard OUT Parameters :
217: -- x_return_status OUT VARCHAR2 Required
218: -- x_msg_count OUT NUMBER Required
219: -- x_msg_data OUT VARCHAR2 Required
220: --

Line 264: -- Standard OUT Parameters :

260: -- Function : Find the total requirment of a specific
261: -- item at the task level
262: -- Parameters :
263: --
264: -- Standard OUT Parameters :
265: -- x_return_status OUT VARCHAR2 Required
266: -- x_msg_count OUT NUMBER Required
267: -- x_msg_data OUT VARCHAR2 Required
268: --

Line 320: -- Standard OUT Parameters :

316: -- p_task_completion_date IN DATE Required
317: -- p_parent_task_reference IN VARCHAR2 Required
318: -- x_task_id OUT NOCOPY NUMBER Required
319: --
320: -- Standard OUT Parameters :
321: -- x_return_status OUT VARCHAR2 Required
322: -- x_msg_count OUT NUMBER Required
323: -- x_msg_data OUT VARCHAR2 Required
324: --

Line 386: -- Standard IN Parameters :

382: -- PURPOSE
383: -- To carry push to Production and Plan Visit as background processes
384: -- Parameters :
385:
386: -- Standard IN Parameters :
387: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
388: --
389: -- Standard OUT Parameters :
390: -- x_return_status OUT VARCHAR2 Required

Line 389: -- Standard OUT Parameters :

385:
386: -- Standard IN Parameters :
387: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
388: --
389: -- Standard OUT Parameters :
390: -- x_return_status OUT VARCHAR2 Required
391: -- x_msg_count OUT NUMBER Required
392: -- x_msg_data OUT VARCHAR2 Required
393:

Line 419: --Standard local variables

415: x_msg_count OUT NOCOPY NUMBER,
416: x_msg_data OUT NOCOPY VARCHAR2
417: )
418: IS
419: --Standard local variables
420: L_API_NAME CONSTANT VARCHAR2(30) := 'BG_Release_Visit';
421: L_API_VERSION CONSTANT NUMBER := 1.0;
422: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
423: l_msg_data VARCHAR2(2000);

Line 486: -- Standard start of API savepoint

482:
483: IF (l_log_procedure >= l_log_current_level) THEN
484: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure. Visit Id = ' || p_visit_id);
485: END IF;
486: -- Standard start of API savepoint
487: SAVEPOINT BG_Release_Visit_Pvt;
488:
489: -- Initialize message list if p_init_msg_list is set to TRUE
490: IF FND_API.To_Boolean(p_init_msg_list) THEN

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

492: END IF;
493: -- Initialize API return status to success
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495:
496: -- Standard call to check for call compatibility.
497: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
498: p_api_version,
499: l_api_name,G_PKG_NAME) THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 751: -- Standard start of API savepoint

747: l_visit_id NUMBER;
748:
749: BEGIN
750:
751: -- Standard start of API savepoint
752: SAVEPOINT BG_Push_to_Production;
753:
754: -- 1. Initialize error message stack by default
755: FND_MSG_PUB.Initialize;

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

753:
754: -- 1. Initialize error message stack by default
755: FND_MSG_PUB.Initialize;
756:
757: -- Standard call to check for call compatibility
758: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
759: retcode := 2;
760: errbuf := FND_MSG_PUB.Get;
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

930:
931: -- Initialize API return status to success
932: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
933:
934: -- Standard call to check for call compatibility.
935: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
936: p_api_version,
937: l_api_name,G_PKG_NAME)
938: THEN

Line 993: -- Standard check of p_commit.

989: ---------------------------End of Body-------------------------------------
990: --
991: -- END of API body.
992: --
993: -- Standard check of p_commit.
994: IF Fnd_Api.To_Boolean ( p_commit ) THEN
995: COMMIT WORK;
996: END IF;
997:

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

1109:
1110: -- Initialize API return status to success
1111: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1112:
1113: -- Standard call to check for call compatibility.
1114: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1115: p_api_version,
1116: L_API_NAME,G_PKG_NAME) THEN
1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1344: -- Standard check of p_commit.

1340: ---------------------------End of Body-------------------------------------
1341: --
1342: -- END of API body.
1343: --
1344: -- Standard check of p_commit.
1345:
1346: IF Fnd_Api.To_Boolean (p_commit) THEN
1347: COMMIT WORK;
1348: END IF;

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

2672:
2673: -- Initialize API return status to success
2674: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2675:
2676: -- Standard call to check for call compatibility.
2677: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2678: p_api_version,
2679: l_api_name,G_PKG_NAME)
2680: THEN

Line 3797: --Standard check to count messages

3793: END IF; -- check for visit's start date time
3794: END IF; -- l_chk_project
3795:
3796: ---------------------------End of API Body---------------------------------------
3797: --Standard check to count messages
3798: l_msg_count := Fnd_Msg_Pub.count_msg;
3799:
3800: IF l_msg_count > 0 THEN
3801: X_msg_count := l_msg_count;

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

3898:
3899: -- Initialize API return status to success
3900: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3901:
3902: -- Standard call to check for call compatibility.
3903: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
3904: p_api_version,
3905: L_API_NAME,G_PKG_NAME) THEN
3906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3999: --Standard check to count messages

3995: END IF;
3996: END IF;
3997:
3998: ---------------------------End of API Body---------------------------------------
3999: --Standard check to count messages
4000: l_msg_count := Fnd_Msg_Pub.count_msg;
4001:
4002: IF l_msg_count > 0 THEN
4003: X_msg_count := l_msg_count;

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

4683:
4684: -- Initialize API return status to success
4685: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4686:
4687: -- Standard call to check for call compatibility.
4688: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
4689: p_api_version,
4690: l_api_name,G_PKG_NAME) THEN
4691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5455: -- Standard check of p_commit.

5451: x_error_tbl := l_error_tbl;
5452:
5453: -------------------- finish --------------------------
5454: -- END of API body.
5455: -- Standard check of p_commit.
5456:
5457: IF Fnd_Api.To_Boolean (p_commit) THEN
5458: COMMIT WORK;
5459: END IF;

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

6355:
6356: -- Initialize API return status to success
6357: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6358:
6359: -- Standard call to check for call compatibility.
6360: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
6361: p_api_version,
6362: l_api_name,G_PKG_NAME)
6363: THEN

Line 7640: -- Standard check of p_commit.

7636: END IF; -- if l_is_comp_visit = 'N'
7637:
7638: ---------------------------End of Body-------------------------------------
7639: -- END of API body.
7640: -- Standard check of p_commit.
7641:
7642: IF Fnd_Api.To_Boolean (p_commit) THEN
7643: COMMIT WORK;
7644: END IF;

Line 7700: -- Standard IN Parameters :

7696: --
7697: -- Pre-reqs :
7698: -- Parameters :
7699: --
7700: -- Standard IN Parameters :
7701: -- p_api_version IN NUMBER Required
7702: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
7703: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
7704: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 7706: -- Standard OUT Parameters :

7702: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
7703: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
7704: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
7705: --
7706: -- Standard OUT Parameters :
7707: -- x_return_status OUT VARCHAR2 Required
7708: -- x_msg_count OUT NUMBER Required
7709: -- x_msg_data OUT VARCHAR2 Required
7710: --

Line 7730: --Standard local variables

7726: x_return_status OUT NOCOPY VARCHAR2,
7727: x_msg_count OUT NOCOPY NUMBER,
7728: x_msg_data OUT NOCOPY VARCHAR2)
7729: IS
7730: --Standard local variables
7731: L_API_NAME CONSTANT VARCHAR2(30) := 'Release_Visit';
7732: L_API_VERSION CONSTANT NUMBER := 1.0;
7733: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
7734: l_msg_data VARCHAR2(2000);

Line 7815: -- Standard start of API savepoint

7811: IF (l_log_procedure >= l_log_current_level) THEN
7812: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure');
7813: END IF;
7814:
7815: -- Standard start of API savepoint
7816: SAVEPOINT Release_Visit_Pvt;
7817:
7818:
7819:

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

7828: END IF;
7829: -- Initialize API return status to success
7830: x_return_status := FND_API.G_RET_STS_SUCCESS;
7831:
7832: -- Standard call to check for call compatibility.
7833: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
7834: p_api_version,
7835: l_api_name,G_PKG_NAME) THEN
7836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8104: -- Standard check of p_commit

8100: -- RROY
8101: -- TCHIMIRA :: Bug 8594339 :: 19-NOV-2009
8102: CLOSE c_visit;
8103:
8104: -- Standard check of p_commit
8105: IF FND_API.TO_BOOLEAN(p_commit) THEN
8106: COMMIT WORK;
8107: END IF;
8108:

Line 8150: -- Standard IN Parameters :

8146: -- Type : Private
8147: -- Function : Validate the tasks and then push tasks to production
8148: -- Parameters :
8149: --
8150: -- Standard IN Parameters :
8151: -- p_api_version IN NUMBER Required
8152: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
8153: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
8154: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 8156: -- Standard OUT Parameters :

8152: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
8153: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
8154: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
8155: --
8156: -- Standard OUT Parameters :
8157: -- x_return_status OUT VARCHAR2 Required
8158: -- x_msg_count OUT NUMBER Required
8159: -- x_msg_data OUT VARCHAR2 Required
8160: --

Line 8223: -- Standard start of API savepoint

8219: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id ||
8220: 'p_tasks_tbl.COUNT = ' || p_tasks_tbl.COUNT);
8221: END IF;
8222:
8223: -- Standard start of API savepoint
8224: SAVEPOINT Release_Tasks_Pvt;
8225:
8226: -- Initialize message list if p_init_msg_list is set to TRUE
8227: IF FND_API.To_Boolean(p_init_msg_list) THEN

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

8230:
8231: -- Initialize API return status to success
8232: x_return_status := FND_API.G_RET_STS_SUCCESS;
8233:
8234: -- Standard call to check for call compatibility.
8235: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
8236: p_api_version,
8237: l_api_name,G_PKG_NAME)
8238: THEN

Line 8628: -- Standard check of p_commit

8624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8625: END IF;
8626: END IF;*/
8627:
8628: -- Standard check of p_commit
8629: IF FND_API.TO_BOOLEAN(p_commit) THEN
8630: COMMIT WORK;
8631: END IF;
8632:

Line 8681: -- Standard OUT Parameters :

8677: -- Type : Private
8678: -- Function : Validate the tasks before pushing the tasks to prodn.
8679: -- Parameters :
8680: --
8681: -- Standard OUT Parameters :
8682: -- x_return_status OUT VARCHAR2 Required
8683: -- x_msg_count OUT NUMBER Required
8684: -- x_msg_data OUT VARCHAR2 Required
8685: --

Line 8834: -- Standard start of API savepoint

8830: 'At the start of PL SQL procedure. Visit Id = ' ||
8831: p_visit_id || ', p_tasks_tbl.COUNT = ' || p_tasks_tbl.COUNT);
8832: END IF;
8833:
8834: -- Standard start of API savepoint
8835: SAVEPOINT Validate_tasks_bef_prodn_pvt;
8836:
8837: -- Initialize API return status to success
8838: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9205: -- Standard IN Parameters :

9201: -- Type : Private
9202: -- Function : Push the selected tasks to production.
9203: -- Parameters :
9204: --
9205: -- Standard IN Parameters :
9206: -- p_api_version IN NUMBER Required
9207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
9208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
9209: -- p_module_type IN VARCHAR2 Default Null

Line 9211: -- Standard OUT Parameters :

9207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
9208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
9209: -- p_module_type IN VARCHAR2 Default Null
9210: --
9211: -- Standard OUT Parameters :
9212: -- x_return_status OUT VARCHAR2 Required
9213: -- x_msg_count OUT NUMBER Required
9214: -- x_msg_data OUT VARCHAR2 Required
9215: --

Line 9470: -- Standard start of API savepoint

9466: 'At the start of PL SQL procedure. Visit Id = ' ||
9467: p_visit_id || ', p_tasks_tbl.COUNT = ' || p_tasks_tbl.COUNT);
9468: END IF;
9469:
9470: -- Standard start of API savepoint
9471: SAVEPOINT Push_tasks_to_prodn_pvt;
9472:
9473: -- Initialize message list if p_init_msg_list is set to TRUE
9474: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 10356: -- Standard IN Parameters :

10352: -- responsible to check return status ('V') and read from error stack.
10353: -- Pre-reqs :
10354: -- Parameters :
10355: --
10356: -- Standard IN Parameters :
10357: -- p_api_version IN NUMBER Required
10358: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
10359: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
10360: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 10362: -- Standard OUT Parameters :

10358: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
10359: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
10360: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
10361: --
10362: -- Standard OUT Parameters :
10363: -- x_return_status OUT VARCHAR2 Required ='V' if validation fails
10364: -- x_msg_count OUT NUMBER Required
10365: -- x_msg_data OUT VARCHAR2 Required
10366: -- x_workorder_id OUT NUMBER Required

Line 10395: --Standard local variables

10391: x_return_status OUT NOCOPY VARCHAR2,
10392: x_msg_count OUT NOCOPY NUMBER,
10393: x_msg_data OUT NOCOPY VARCHAR2)
10394: IS
10395: --Standard local variables
10396: l_api_name CONSTANT VARCHAR2(30) := 'Release_MR';
10397: l_api_version CONSTANT NUMBER := 1.0;
10398: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
10399: l_msg_data VARCHAR2(2000);

Line 10508: -- Standard start of API savepoint

10504: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id ||
10505: ', p_recalculate_dates = ' || p_recalculate_dates);
10506: END IF;
10507:
10508: -- Standard start of API savepoint
10509: SAVEPOINT Release_MR;
10510:
10511: -- Initialize message list if p_init_msg_list is set to TRUE
10512: IF FND_API.To_Boolean( p_init_msg_list) THEN

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

10515:
10516: -- Initialize API return status to success
10517: x_return_status := FND_API.G_RET_STS_SUCCESS;
10518:
10519: -- Standard call to check for call compatibility.
10520: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
10521: p_api_version,
10522: l_api_name,G_PKG_NAME)THEN
10523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 10723: -- Standard check of p_commit

10719: FETCH get_wo INTO x_workorder_id;
10720: CLOSE get_wo;
10721: END IF;
10722:
10723: -- Standard check of p_commit
10724: IF FND_API.TO_BOOLEAN(p_commit) THEN
10725: COMMIT WORK;
10726: END IF;
10727:

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

11302:
11303: -- Initialize API return status to success
11304: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
11305:
11306: -- Standard call to check for call compatibility.
11307: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
11308: p_api_version,
11309: l_api_name,G_PKG_NAME) THEN
11310: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 11726: -- Standard check of p_commit.

11722:
11723: END IF; -- IF Component Visit
11724:
11725: ---------------------------End of Body-------------------------------------
11726: -- Standard check of p_commit.
11727: IF Fnd_Api.To_Boolean (p_commit) THEN
11728: COMMIT WORK;
11729: END IF;
11730:

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

11907:
11908: -- Initialize API return status to success
11909: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
11910:
11911: -- Standard call to check for call compatibility.
11912: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
11913: p_api_version,
11914: l_api_name,G_PKG_NAME) THEN
11915: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 12238: -- Standard check of p_commit.

12234: -- PRAKKUM :: PIE Changes :: 13-OCT-2010 :: END
12235: END IF; -- l_chk_project
12236:
12237: ---------------------------End of Body-------------------------------------
12238: -- Standard check of p_commit.
12239:
12240: IF Fnd_Api.To_Boolean ( p_commit ) THEN
12241: COMMIT WORK;
12242: END IF;

Line 12322: -- Standard start of API savepoint

12318: l_scheduled_matrial_id NUMBER;
12319: l_previous_item NUMBER := NULL;
12320:
12321: BEGIN
12322: -- Standard start of API savepoint
12323: SAVEPOINT AGGREGATE_MATERIAL_REQRS;
12324:
12325: -- Initialize return status to success before any code logic/validation
12326: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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

12324:
12325: -- Initialize return status to success before any code logic/validation
12326: x_return_status:= FND_API.G_RET_STS_SUCCESS;
12327:
12328: -- Standard call to check for call compatibility
12329: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
12330: THEN
12331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12332: END IF;

Line 12401: -- Standard OUT Parameters :

12397: -- Function : Find the total requirment of a specific
12398: -- item at the task level
12399: -- Parameters :
12400: --
12401: -- Standard OUT Parameters :
12402: -- x_return_status OUT VARCHAR2 Required
12403: -- x_msg_count OUT NUMBER Required
12404: -- x_msg_data OUT VARCHAR2 Required
12405: --

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

12473: L_DEBUG_KEY ||'.begin',
12474: 'At the start of PL SQL procedure. Visit Task Id = ' || p_task_id);
12475: END IF;
12476:
12477: -- Standard call to check for call compatibility
12478: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
12479: THEN
12480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12481: END IF;

Line 12619: -- Standard IN Parameters :

12615: -- Type : Private
12616: -- Function : Update the project task start/end dates
12617: -- with the workorder schedule start/end dates
12618: -- Parameters :
12619: -- Standard IN Parameters :
12620: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
12621: --
12622: -- Update_Project_Task_Times Parameters
12623: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required

Line 12625: -- Standard OUT Parameters :

12621: --
12622: -- Update_Project_Task_Times Parameters
12623: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required
12624: --
12625: -- Standard OUT Parameters :
12626: -- x_return_status OUT VARCHAR2 Required
12627: -- x_msg_count OUT NUMBER Required
12628: -- x_msg_data OUT VARCHAR2 Required
12629: --

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

13122:
13123: -- Initialize API return status to success
13124: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
13125:
13126: -- Standard call to check for call compatibility.
13127: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
13128: p_api_version,
13129: l_api_name,G_PKG_NAME) THEN
13130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 13482: -- Standard check of p_commit.

13478: -- yazhou Jul-20-2005 end
13479: -- RROY
13480: ---------------------------End of Body-------------------------------------
13481: -- END of API body.
13482: -- Standard check of p_commit.
13483:
13484: IF Fnd_Api.To_Boolean (p_commit) THEN
13485: COMMIT WORK;
13486: END IF;

Line 13546: -- Standard OUT Parameters :

13542: -- p_task_completion_date IN DATE Required
13543: -- p_parent_task_reference IN VARCHAR2 Required
13544: -- x_task_id OUT NOCOPY NUMBER Required
13545: --
13546: -- Standard OUT Parameters :
13547: -- x_return_status OUT VARCHAR2 Required
13548: -- x_msg_count OUT NUMBER Required
13549: -- x_msg_data OUT VARCHAR2 Required
13550: --

Line 13701: -- Standard OUT Parameters :

13697: -- Parameters :
13698: -- Update_Project_Task_Times Parameters
13699: -- p_task_id IN NUMBER Required
13700: --
13701: -- Standard OUT Parameters :
13702: -- x_return_status OUT VARCHAR2 Required
13703: -- x_msg_count OUT NUMBER Required
13704: -- x_msg_data OUT VARCHAR2 Required
13705: --

Line 13896: -- Standard IN Parameters :

13892: -- Function : To determine whether the new structure should be used for
13893: -- the project tasks. It is a helper function that will be
13894: -- used by other APIs in this package.
13895: -- Parameters :
13896: -- Standard IN Parameters :
13897: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
13898: --
13899: -- Update_Project_Task_Times Parameters :
13900: -- p_visit_id IN NUMBER Required

Line 13902: -- Standard OUT Parameters :

13898: --
13899: -- Update_Project_Task_Times Parameters :
13900: -- p_visit_id IN NUMBER Required
13901: --
13902: -- Standard OUT Parameters :
13903: -- x_return_status OUT VARCHAR2 Required
13904: -- x_msg_count OUT NUMBER Required
13905: -- x_msg_data OUT VARCHAR2 Required
13906: --

Line 14125: -- Standard variables

14121: p_visit_id IN NUMBER,
14122: x_warranty_entl_tbl OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type
14123: ) IS
14124:
14125: -- Standard variables
14126: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Entl_rec_for_Delete';
14127: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
14128: -- Local variables defined for the procedure
14129: l_warranty_entl_id NUMBER := null;

Line 14200: -- Standard IN Parameters :

14196: -- Function : Procedure to plan a visit i.e. to move the visit from draft to planning status
14197: -- and create draft WOs for all its tasks
14198: -- Parameters :
14199: --
14200: -- Standard IN Parameters :
14201: -- p_api_version IN NUMBER Required
14202: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
14203: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
14204: --

Line 14205: -- Standard OUT Parameters :

14201: -- p_api_version IN NUMBER Required
14202: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
14203: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
14204: --
14205: -- Standard OUT Parameters :
14206: -- x_return_status OUT VARCHAR2 Required
14207: -- x_msg_count OUT NUMBER Required
14208: -- x_msg_data OUT VARCHAR2 Required
14209: --

Line 14228: -- Standard in/out parameters

14224: x_msg_data OUT NOCOPY VARCHAR2)IS
14225:
14226: -- Local Variables
14227:
14228: -- Standard in/out parameters
14229: l_api_name VARCHAR2(30) := 'PLAN_VISIT';
14230: l_api_version NUMBER := 1.0;
14231: l_msg_count NUMBER;
14232: l_msg_data VARCHAR2(2000);

Line 14259: -- Standard start of API savepoint

14255: 'At the start of PLSQL procedure, Visit ID : ' || p_visit_id
14256: );
14257: END IF;
14258:
14259: -- Standard start of API savepoint
14260: SAVEPOINT plan_visit_pvt;
14261:
14262: -- Initialize message list if p_init_msg_list is set to TRUE
14263:

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

14267:
14268: -- Initialize API return status to success
14269: x_return_status := FND_API.G_RET_STS_SUCCESS;
14270:
14271: -- Standard call to check for call compatibility.
14272: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
14273: p_api_version,
14274: l_api_name,G_PKG_NAME)
14275: THEN

Line 14471: -- Standard IN Parameters :

14467: -- Type : Private
14468: -- Function : Push the selected stages to production.
14469: -- Parameters :
14470: --
14471: -- Standard IN Parameters :
14472: -- p_api_version IN NUMBER Required
14473: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
14474: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
14475: -- p_module_type IN VARCHAR2 Default Null

Line 14477: -- Standard OUT Parameters :

14473: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
14474: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
14475: -- p_module_type IN VARCHAR2 Default Null
14476: --
14477: -- Standard OUT Parameters :
14478: -- x_return_status OUT VARCHAR2 Required
14479: -- x_msg_count OUT NUMBER Required
14480: -- x_msg_data OUT VARCHAR2 Required
14481: --

Line 14696: -- Standard start of API savepoint

14692: 'At the start of PL SQL procedure. Visit Id = ' ||
14693: p_visit_id || ', p_stages_tbl.COUNT = ' || p_stages_tbl.COUNT);
14694: END IF;
14695:
14696: -- Standard start of API savepoint
14697: SAVEPOINT Push_stages_to_prodn_pvt;
14698:
14699: -- Initialize message list if p_init_msg_list is set to TRUE
14700: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 15353: -- Standard check of p_commit.

15349: END IF;
15350:
15351: ---------------------------End of Body-------------------------------------
15352: -- END of API body.
15353: -- Standard check of p_commit.
15354:
15355: IF Fnd_Api.To_Boolean (p_commit) THEN
15356: COMMIT WORK;
15357: END IF;