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

Line 113: -- Standard Start of API savepoint

109: */
110: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name;
111: BEGIN
112: --------------------Initialize ----------------------------------
113: -- Standard Start of API savepoint
114: SAVEPOINT unschedule_visit;
115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string(fnd_log.level_procedure, L_DEBUG_KEY || '.begin',
117: 'At the start of PLSQL procedure');

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

115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string(fnd_log.level_procedure, L_DEBUG_KEY || '.begin',
117: 'At the start of PLSQL procedure');
118: END IF;
119: -- Standard call to check for call compatibility.
120: IF FND_API.to_boolean(p_init_msg_list)THEN
121: FND_MSG_PUB.initialize;
122: END IF;
123: -- Initialize API return status to success

Line 377: --Standard local variables

373: association_type_code
374: FROM ahl_rt_oper_materials
375: WHERE rt_oper_material_id = c_rt_oper_mat_id;
376:
377: --Standard local variables
378: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Planned_Matrls';
379: l_api_version CONSTANT NUMBER := 1.0;
380: l_msg_data VARCHAR2(2000);
381: l_return_status VARCHAR2(1);

Line 419: -- Standard start of API savepoint

415: IF (l_log_procedure >= l_log_current_level)THEN
416: fnd_log.string(fnd_log.level_procedure, L_DEBUG_KEY || '.begin',
417: 'At the start of PLSQL procedure');
418: END IF;
419: -- Standard start of API savepoint
420: SAVEPOINT Insert_Planned_Matrls;
421: -- Initialize message list if p_init_msg_list is set to TRUE
422: IF FND_API.To_Boolean( l_init_msg_list) THEN
423: FND_MSG_PUB.Initialize;

Line 737: -- Standard IN Parameters :

733: -- visit, which are defined at Route Operation and Disposition level
734: -- Pre-reqs :
735: -- Parameters :
736: --
737: -- Standard IN Parameters :
738: -- p_api_version IN NUMBER Required
739: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
740: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
741: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 745: -- Standard out Parameters :

741: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
742: -- Based on this flag, the API will set the default attributes.
743: -- p_module_type In VARCHAR2 Default NULL
744: -- This will be null.
745: -- Standard out Parameters :
746: -- x_return_status OUT VARCHAR2 Required
747: -- x_msg_count OUT NUMBER Required
748: -- x_msg_data OUT VARCHAR2 Required
749: --

Line 797: --Standard local variables

793: WHERE visit_id = c_visit_id;
794:
795: -- Serial Number Resrvation Change ends
796:
797: --Standard local variables
798: l_api_name CONSTANT VARCHAR2(30) := 'Update_Planned_Materials';
799: l_api_version CONSTANT NUMBER := 1.0;
800: l_msg_data VARCHAR2(2000);
801: l_return_status VARCHAR2(1);

Line 824: -- Standard start of API savepoint

820: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name || '.begin',
821: 'At the start of PLSQL procedure'
822: );
823: END IF;
824: -- Standard start of API savepoint
825: SAVEPOINT Update_Planned_Materials;
826: -- Initialize message list if p_init_msg_list is set to TRUE
827: IF FND_API.To_Boolean( p_init_msg_list) THEN
828: FND_MSG_PUB.Initialize;

Line 1066: -- Standard check of p_commit

1062: IF x_msg_count > 0 THEN
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:
1066: -- Standard check of p_commit
1067: IF FND_API.TO_BOOLEAN(p_commit) THEN
1068: COMMIT WORK;
1069: END IF;
1070:

Line 1119: -- Standard IN Parameters :

1115: -- visit, which are defined at Route Operation and Disposition level
1116: -- Pre-reqs :
1117: -- Parameters :
1118: --
1119: -- Standard IN Parameters :
1120: -- p_api_version IN NUMBER Required
1121: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1122: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1123: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1127: -- Standard out Parameters :

1123: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1124: -- Based on this flag, the API will set the default attributes.
1125: -- p_module_type In VARCHAR2 Default NULL
1126: -- This will be null.
1127: -- Standard out Parameters :
1128: -- x_return_status OUT VARCHAR2 Required
1129: -- x_msg_count OUT NUMBER Required
1130: -- x_msg_data OUT VARCHAR2 Required
1131: --

Line 1180: --Standard local variables

1176: WHERE visit_id = C_VISIT_ID
1177: AND (organization_id IS NULL
1178: OR start_date_time IS NULL);
1179:
1180: --Standard local variables
1181: l_api_name CONSTANT VARCHAR2(30) := 'Create_Task_Materials';
1182: l_api_version CONSTANT NUMBER := 1.0;
1183: l_msg_data VARCHAR2(2000);
1184: l_return_status VARCHAR2(1);

Line 1206: -- Standard start of API savepoint

1202: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1203: 'At the start of PLSQL procedure'
1204: );
1205: END IF;
1206: -- Standard start of API savepoint
1207: SAVEPOINT Create_Task_Materials;
1208: -- Initialize message list if p_init_msg_list is set to TRUE
1209: IF FND_API.To_Boolean( p_init_msg_list) THEN
1210: FND_MSG_PUB.Initialize;

Line 1412: -- Standard check of p_commit

1408: END IF;
1409: END IF;
1410:
1411:
1412: -- Standard check of p_commit
1413: IF FND_API.TO_BOOLEAN(p_commit) THEN
1414: COMMIT WORK;
1415: END IF;
1416:

Line 1465: -- Standard IN Parameters :

1461: -- visit, which are defined at Route Operation and Disposition level
1462: -- Pre-reqs :
1463: -- Parameters :
1464: --
1465: -- Standard IN Parameters :
1466: -- p_api_version IN NUMBER Required
1467: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1468: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1469: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1473: -- Standard out Parameters :

1469: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1470: -- Based on this flag, the API will set the default attributes.
1471: -- p_module_type In VARCHAR2 Default NULL
1472: -- This will be null.
1473: -- Standard out Parameters :
1474: -- x_return_status OUT VARCHAR2 Required
1475: -- x_msg_count OUT NUMBER Required
1476: -- x_msg_data OUT VARCHAR2 Required
1477: --

Line 1644: --Standard local variables

1640: AND asm.inventory_item_id = wip.inventory_item_id
1641: AND asm.organization_id = wip.organization_id
1642: AND asm.scheduled_material_id = c_scheduled_material_id;
1643:
1644: --Standard local variables
1645: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Visit_Task_Matrls';
1646: l_api_version CONSTANT NUMBER := 1.0;
1647: l_msg_data VARCHAR2(2000);
1648: l_return_status VARCHAR2(1);

Line 1677: -- Standard start of API savepoint

1673: ', p_visit_task_id = ' || p_visit_task_id ||
1674: ', p_start_time = ' || p_start_time ||
1675: ', p_org_id = ' || p_org_id);
1676: END IF;
1677: -- Standard start of API savepoint
1678: SAVEPOINT Modify_Visit_Task_Matrls;
1679: -- Initialize message list if p_init_msg_list is set to TRUE
1680: IF FND_API.To_Boolean( p_init_msg_list) THEN
1681: FND_MSG_PUB.Initialize;

Line 2044: -- Standard check of p_commit

2040: IF x_msg_count > 0 THEN
2041: RAISE FND_API.G_EXC_ERROR;
2042: END IF;
2043:
2044: -- Standard check of p_commit
2045: IF FND_API.TO_BOOLEAN(p_commit) THEN
2046: COMMIT WORK;
2047: END IF;
2048:

Line 2093: -- Standard IN Parameters :

2089: -- which are defined at Route Operation and Disposition level
2090: -- Pre-reqs :
2091: -- Parameters :
2092: --
2093: -- Standard IN Parameters :
2094: -- p_api_version IN NUMBER Required
2095: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2096: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2097: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2100: -- Standard out Parameters :

2096: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2097: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2098: -- Based on this flag, the API will set the default attributes.
2099: -- This will be null.
2100: -- Standard out Parameters :
2101: -- x_return_status OUT VARCHAR2 Required
2102: -- x_msg_count OUT NUMBER Required
2103: -- x_msg_data OUT VARCHAR2 Required
2104: --

Line 2158: -- Standard Start of API savepoint

2154: l_req_material_rec ahl_ltp_reqst_matrl_pub.Schedule_Mr_Rec;
2155: --
2156: BEGIN
2157: --------------------Initialize ----------------------------------
2158: -- Standard Start of API savepoint
2159: SAVEPOINT Unschedule_Task_Items;
2160: -- Check if API is called in debug mode. If yes, enable debug.
2161: IF G_DEBUG='Y' THEN
2162: AHL_DEBUG_PUB.enable_debug;

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

2164: -- Debug info.
2165: IF G_DEBUG='Y' THEN
2166: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');
2167: END IF;
2168: -- Standard call to check for call compatibility.
2169: IF FND_API.to_boolean(p_init_msg_list)
2170: THEN
2171: FND_MSG_PUB.initialize;
2172: END IF;

Line 2212: --Standard check to count messages

2208: END LOOP;
2209: CLOSE check_items_cur;
2210:
2211: ---------------------------End of Body---------------------------------------
2212: --Standard check to count messages
2213: l_msg_count := Fnd_Msg_Pub.count_msg;
2214:
2215: IF l_msg_count > 0 THEN
2216: X_msg_count := l_msg_count;

Line 2221: --Standard check for commit

2217: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2218: RAISE Fnd_Api.G_EXC_ERROR;
2219: END IF;
2220:
2221: --Standard check for commit
2222: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2223: COMMIT;
2224: END IF;
2225: -- Debug info

Line 2296: -- Standard IN Parameters :

2292: -- visit, which are defined at Route Operation and Disposition level
2293: -- Pre-reqs :
2294: -- Parameters :
2295: --
2296: -- Standard IN Parameters :
2297: -- p_api_version IN NUMBER Required
2298: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2299: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2300: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2304: -- Standard out Parameters :

2300: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2301: -- Based on this flag, the API will set the default attributes.
2302: -- p_module_type In VARCHAR2 Default NULL
2303: -- This will be null.
2304: -- Standard out Parameters :
2305: -- x_return_status OUT VARCHAR2 Required
2306: -- x_msg_count OUT NUMBER Required
2307: -- x_msg_data OUT VARCHAR2 Required
2308: --

Line 2330: --Standard local variables

2326: x_msg_count OUT NOCOPY NUMBER,
2327: x_msg_data OUT NOCOPY VARCHAR2
2328: ) IS
2329:
2330: --Standard local variables
2331: l_api_name CONSTANT VARCHAR2(30) := 'Process_Planned_Materials';
2332: l_api_version CONSTANT NUMBER := 1.0;
2333: l_msg_data VARCHAR2(2000);
2334: l_return_status VARCHAR2(1);

Line 2358: -- Standard start of API savepoint

2354: ', p_visit_task_id = ' || p_visit_task_id ||
2355: ', p_operation_flag = ' || p_operation_flag);
2356: END IF;
2357:
2358: -- Standard start of API savepoint
2359: SAVEPOINT Process_Planned_Materials;
2360: -- Initialize message list if p_init_msg_list is set to TRUE
2361: IF FND_API.To_Boolean( p_init_msg_list) THEN
2362: FND_MSG_PUB.Initialize;

Line 2564: -- Standard check of p_commit

2560: END IF;
2561: END IF;
2562: END IF;
2563:
2564: -- Standard check of p_commit
2565: IF FND_API.TO_BOOLEAN(p_commit) THEN
2566: COMMIT WORK;
2567: END IF;
2568:

Line 2613: -- Standard IN Parameters :

2609: -- visit, which are defined at Route Operation and Disposition level
2610: -- Pre-reqs :
2611: -- Parameters :
2612: --
2613: -- Standard IN Parameters :
2614: -- p_api_version IN NUMBER Required
2615: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2616: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2617: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2621: -- Standard out Parameters :

2617: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2618: -- Based on this flag, the API will set the default attributes.
2619: -- p_module_type In VARCHAR2 Default NULL
2620: -- This will be null.
2621: -- Standard out Parameters :
2622: -- x_return_status OUT VARCHAR2 Required
2623: -- x_msg_count OUT NUMBER Required
2624: -- x_msg_data OUT VARCHAR2 Required
2625: --

Line 2698: --Standard local variables

2694: ahl_schedule_materials asm
2695: WHERE vtm.visit_id = c_visit_id
2696: AND asm.scheduled_material_id = vtm.schedule_material_id;
2697:
2698: --Standard local variables
2699: l_api_name CONSTANT VARCHAR2(30) := 'Remove_Visit_Task_Matrls';
2700: l_api_version CONSTANT NUMBER := 1.0;
2701: l_msg_data VARCHAR2(2000);
2702: l_return_status VARCHAR2(1);

Line 2721: -- Standard start of API savepoint

2717: fnd_log.string(fnd_log.level_procedure, L_DEBUG_KEY || '.begin',
2718: 'At the start of PLSQL procedure.');
2719: END IF;
2720:
2721: -- Standard start of API savepoint
2722: SAVEPOINT Remove_Visit_Task_Matrls;
2723:
2724: -- Initialize message list if p_init_msg_list is set to TRUE
2725: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 2874: --Standard check to count messages

2870:
2871: END IF;
2872: x_planned_order_flag := l_planned_order_flag;
2873:
2874: --Standard check to count messages
2875: l_msg_count := Fnd_Msg_Pub.count_msg;
2876:
2877: IF l_msg_count > 0 THEN
2878: X_msg_count := l_msg_count;

Line 2883: -- Standard check of p_commit

2879: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2880: RAISE Fnd_Api.G_EXC_ERROR;
2881: END IF;
2882:
2883: -- Standard check of p_commit
2884: IF FND_API.TO_BOOLEAN(p_commit) THEN
2885: COMMIT WORK;
2886: END IF;
2887:

Line 2932: -- Standard IN Parameters :

2928: -- visit, which are defined at Route Operation and Disposition level
2929: -- Pre-reqs :
2930: -- Parameters :
2931: --
2932: -- Standard IN Parameters :
2933: -- p_api_version IN NUMBER Required
2934: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2935: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2936: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2940: -- Standard out Parameters :

2936: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2937: -- Based on this flag, the API will set the default attributes.
2938: -- p_module_type In VARCHAR2 Default NULL
2939: -- This will be null.
2940: -- Standard out Parameters :
2941: -- x_return_status OUT VARCHAR2 Required
2942: -- x_msg_count OUT NUMBER Required
2943: -- x_msg_data OUT VARCHAR2 Required
2944: --

Line 2969: --Standard local variables

2965: FROM ahl_schedule_materials
2966: WHERE visit_id = c_visit_id
2967: AND status = 'ACTIVE';
2968:
2969: --Standard local variables
2970: l_api_name CONSTANT VARCHAR2(30) := 'Update_Unplanned_Matrls';
2971: l_api_version CONSTANT NUMBER := 1.0;
2972: l_msg_data VARCHAR2(2000);
2973: l_return_status VARCHAR2(1);

Line 2987: -- Standard start of API savepoint

2983: 'At the start of PLSQL procedure'
2984: );
2985: END IF;
2986:
2987: -- Standard start of API savepoint
2988: SAVEPOINT Update_Unplanned_Matrls;
2989:
2990: -- Initialize message list if p_init_msg_list is set to TRUE
2991: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 3039: -- Standard check of p_commit

3035: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3036: RAISE Fnd_Api.g_exc_error;
3037: END IF;
3038:
3039: -- Standard check of p_commit
3040: IF FND_API.TO_BOOLEAN(p_commit) THEN
3041: COMMIT WORK;
3042: END IF;
3043:

Line 3088: -- Standard out Parameters :

3084: --
3085: -- Pre-reqs :
3086: -- Parameters :
3087: --
3088: -- Standard out Parameters :
3089: -- x_return_status OUT VARCHAR2 Required
3090: --
3091: -- Modify_Visit_Reservations Parameters :
3092: -- p_visit_id IN NUMBER,Required

Line 3128: --Standard local variables

3124: WHERE external_source_code = 'AHL'
3125: AND demand_source_header_id in ( SELECT visit_task_id
3126: FROM ahl_visit_tasks_b
3127: WHERE visit_id = p_visit_id);
3128: --Standard local variables
3129: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Visit_Reservations';
3130: l_api_version CONSTANT NUMBER := 1.0;
3131: l_msg_data VARCHAR2(2000);
3132: l_return_status VARCHAR2(1);

Line 3306: -- Standard start of API savepoint

3302: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3303: l_sch_material_id NUMBER := 0;
3304:
3305: BEGIN
3306: -- Standard start of API savepoint
3307: SAVEPOINT Update_Material_Reqrs_sts;
3308:
3309: -- Initialize return status to success before any code logic/validation
3310: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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

3308:
3309: -- Initialize return status to success before any code logic/validation
3310: x_return_status:= FND_API.G_RET_STS_SUCCESS;
3311:
3312: -- Standard call to check for call compatibility
3313: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3315: END IF;
3316:

Line 3346: -- Standard check of p_commit

3342: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3343: WHERE visit_task_id = p_visit_task_id
3344: AND STATUS = 'ACTIVE';
3345:
3346: -- Standard check of p_commit
3347: IF Fnd_Api.To_Boolean (p_commit) THEN
3348: COMMIT WORK;
3349: END IF;
3350:

Line 3486: -- Standard IN Parameters :

3482: -- Type : Private
3483: -- Function : Procedure to associate materials, based on NR profile, to stage tasks
3484: -- Parameters :
3485: --
3486: -- Standard IN Parameters :
3487: -- p_api_version IN NUMBER Required
3488: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3489: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3490: -- p_module_type IN VARCHAR2 Default Null

Line 3492: -- Standard OUT Parameters :

3488: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3489: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3490: -- p_module_type IN VARCHAR2 Default Null
3491: --
3492: -- Standard OUT Parameters :
3493: -- x_return_status OUT VARCHAR2 Required
3494: -- x_msg_count OUT NUMBER Required
3495: -- x_msg_data OUT VARCHAR2 Required
3496: --

Line 3521: -- Standard in/out parameters

3517: x_msg_data OUT NOCOPY VARCHAR2)IS
3518:
3519: -- Local Variables
3520:
3521: -- Standard in/out parameters
3522: l_api_name VARCHAR2(30) := 'Associate_Stage_Materials';
3523: l_api_version NUMBER := 1.0;
3524: l_msg_count NUMBER;
3525: l_msg_data VARCHAR2(2000);

Line 3615: -- Standard start of API savepoint

3611: l_debug_key,
3612: 'At the start of PLSQL procedure');
3613: END IF;
3614:
3615: -- Standard start of API savepoint
3616: SAVEPOINT Associate_Stage_Materials_pvt;
3617:
3618: -- Initialize message list if p_init_msg_list is set to TRUE
3619:

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

3623:
3624: -- Initialize API return status to success
3625: x_return_status := FND_API.G_RET_STS_SUCCESS;
3626:
3627: -- Standard call to check for call compatibility.
3628: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
3629: p_api_version,
3630: l_api_name,G_PKG_NAME)
3631: THEN

Line 3960: -- Standard IN Parameters :

3956: -- Type : Private
3957: -- Function : Procedure to remove materials, based on NR profile, from stage tasks
3958: -- Parameters :
3959: --
3960: -- Standard IN Parameters :
3961: -- p_api_version IN NUMBER Required
3962: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3963: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3964: -- p_module_type IN VARCHAR2 Default Null

Line 3966: -- Standard OUT Parameters :

3962: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3963: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3964: -- p_module_type IN VARCHAR2 Default Null
3965: --
3966: -- Standard OUT Parameters :
3967: -- x_return_status OUT VARCHAR2 Required
3968: -- x_msg_count OUT NUMBER Required
3969: -- x_msg_data OUT VARCHAR2 Required
3970: --

Line 3995: -- Standard in/out parameters

3991: x_msg_data OUT NOCOPY VARCHAR2)IS
3992:
3993: -- Local Variables
3994:
3995: -- Standard in/out parameters
3996: l_api_name VARCHAR2(30) := 'Remove_Stage_Materials';
3997: l_api_version NUMBER := 1.0;
3998: l_msg_count NUMBER;
3999: l_msg_data VARCHAR2(2000);

Line 4067: -- Standard start of API savepoint

4063: L_DEBUG_KEY,
4064: 'At the start of PLSQL procedure');
4065: END IF;
4066:
4067: -- Standard start of API savepoint
4068: SAVEPOINT Remove_Stage_Materials_pvt;
4069:
4070: -- Initialize message list if p_init_msg_list is set to TRUE
4071:

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

4075:
4076: -- Initialize API return status to success
4077: x_return_status := FND_API.G_RET_STS_SUCCESS;
4078:
4079: -- Standard call to check for call compatibility.
4080: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
4081: p_api_version,
4082: l_api_name,G_PKG_NAME)
4083: THEN

Line 4328: -- Standard IN Parameters :

4324: -- Type : Private
4325: -- Function : Procedure to delete materials of default stage task when a visit is P2Ped
4326: -- Parameters :
4327: --
4328: -- Standard IN Parameters :
4329: -- p_api_version IN NUMBER Required
4330: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4331: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4332: -- p_module_type IN VARCHAR2 Default Null

Line 4334: -- Standard OUT Parameters :

4330: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4331: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4332: -- p_module_type IN VARCHAR2 Default Null
4333: --
4334: -- Standard OUT Parameters :
4335: -- x_return_status OUT VARCHAR2 Required
4336: -- x_msg_count OUT NUMBER Required
4337: -- x_msg_data OUT VARCHAR2 Required
4338: --

Line 4356: -- Standard in/out parameters

4352: x_msg_data OUT NOCOPY VARCHAR2)IS
4353:
4354: -- Local Variables
4355:
4356: -- Standard in/out parameters
4357: l_api_name VARCHAR2(30) := 'Delete_Default_Stage_Materials';
4358: l_api_version NUMBER := 1.0;
4359: l_msg_count NUMBER;
4360: l_msg_data VARCHAR2(2000);

Line 4399: -- Standard start of API savepoint

4395: L_DEBUG_KEY,
4396: 'At the start of PLSQL procedure');
4397: END IF;
4398:
4399: -- Standard start of API savepoint
4400: SAVEPOINT Delete_Default_Stage_Materials;
4401:
4402: -- Initialize message list if p_init_msg_list is set to TRUE
4403:

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

4407:
4408: -- Initialize API return status to success
4409: x_return_status := FND_API.G_RET_STS_SUCCESS;
4410:
4411: -- Standard call to check for call compatibility.
4412: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
4413: p_api_version,
4414: l_api_name,G_PKG_NAME)
4415: THEN