163: -- end bug#13698799
164:
165: BEGIN
166:
167: -- Standard Start of API savepoint
168: SAVEPOINT CREATE_REPAIR_ORDER_PVT;
169: -- Standard call to check for call compatibility.
170: IF NOT Fnd_Api.Compatible_API_Call
171: (l_api_version_number,
165: BEGIN
166:
167: -- Standard Start of API savepoint
168: SAVEPOINT CREATE_REPAIR_ORDER_PVT;
169: -- Standard call to check for call compatibility.
170: IF NOT Fnd_Api.Compatible_API_Call
171: (l_api_version_number,
172: p_api_version_number,
173: l_api_name,
693:
694: --
695: -- End of API body
696: --
697: -- Standard check for p_commit
698: IF Fnd_Api.to_Boolean( p_commit )
699: THEN
700: COMMIT WORK;
701: END IF;
698: IF Fnd_Api.to_Boolean( p_commit )
699: THEN
700: COMMIT WORK;
701: END IF;
702: -- Standard call to get message count and if count is 1, get message info.
703: Fnd_Msg_Pub.Count_And_Get
704: (p_count => x_msg_count,
705: p_data => x_msg_data
706: );
866: x_dff_value_rec csd_repairs_util.def_rec_type;
867:
868: BEGIN
869:
870: -- Standard Start of API savepoint
871: SAVEPOINT UPDATE_REPAIR_ORDER_PVT;
872: -- Standard call to check for call compatibility.
873: IF NOT Fnd_Api.Compatible_API_Call
874: (l_api_version_number,
868: BEGIN
869:
870: -- Standard Start of API savepoint
871: SAVEPOINT UPDATE_REPAIR_ORDER_PVT;
872: -- Standard call to check for call compatibility.
873: IF NOT Fnd_Api.Compatible_API_Call
874: (l_api_version_number,
875: p_api_version_number,
876: l_api_name,
1198:
1199: --
1200: -- End of API body.
1201: --
1202: -- Standard check for p_commit
1203: IF Fnd_Api.to_Boolean(p_commit) THEN
1204: COMMIT WORK;
1205: END IF;
1206: -- Standard call to get message count and if count is 1, get message info.
1202: -- Standard check for p_commit
1203: IF Fnd_Api.to_Boolean(p_commit) THEN
1204: COMMIT WORK;
1205: END IF;
1206: -- Standard call to get message count and if count is 1, get message info.
1207: Fnd_Msg_Pub.Count_And_Get
1208: (p_count => x_msg_count,
1209: p_data => x_msg_data
1210: );
1258: l_api_version_number CONSTANT NUMBER := 1.0;
1259:
1260: BEGIN
1261: --
1262: -- Standard Start of API savepoint
1263: SAVEPOINT DELETE_REPAIR_ORDER_PVT;
1264: -- Standard call to check for call compatibility.
1265: IF NOT Fnd_Api.Compatible_API_Call
1266: (l_api_version_number,
1260: BEGIN
1261: --
1262: -- Standard Start of API savepoint
1263: SAVEPOINT DELETE_REPAIR_ORDER_PVT;
1264: -- Standard call to check for call compatibility.
1265: IF NOT Fnd_Api.Compatible_API_Call
1266: (l_api_version_number,
1267: p_api_version_number,
1268: l_api_name,
1284: p_REPAIR_LINE_ID => p_REPAIR_LINE_ID);
1285:
1286: -- End of API body
1287:
1288: -- Standard check for p_commit
1289: IF Fnd_Api.to_Boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292: -- Standard call to get message count and if count is 1, get message info.
1288: -- Standard check for p_commit
1289: IF Fnd_Api.to_Boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292: -- Standard call to get message count and if count is 1, get message info.
1293: Fnd_Msg_Pub.Count_And_Get
1294: (p_count => x_msg_count,
1295: p_data => x_msg_data
1296: );
2611: l_refurbished_repair_type_flag VARCHAR2(1);
2612:
2613: BEGIN
2614:
2615: -- Standard Start of API savepoint
2616: SAVEPOINT VALIDATE_REPAIRS_PVT;
2617: -- Standard call to check for call compatibility.
2618: IF NOT Fnd_Api.Compatible_API_Call
2619: (l_api_version_number,
2613: BEGIN
2614:
2615: -- Standard Start of API savepoint
2616: SAVEPOINT VALIDATE_REPAIRS_PVT;
2617: -- Standard call to check for call compatibility.
2618: IF NOT Fnd_Api.Compatible_API_Call
2619: (l_api_version_number,
2620: p_api_version_number,
2621: l_api_name,
3258: /* the original repair order to the new repair */
3259: /* order. */
3260: /* */
3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3259: /* order. */
3260: /* */
3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3260: /* */
3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */
3270: /* x_msg_data Standard OUT param */
3271: /* */
3272: /*-------------------------------------------------------------------*/
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */
3270: /* x_msg_data Standard OUT param */
3271: /* */
3272: /*-------------------------------------------------------------------*/
3273: PROCEDURE Copy_Attachments
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */
3270: /* x_msg_data Standard OUT param */
3271: /* */
3272: /*-------------------------------------------------------------------*/
3273: PROCEDURE Copy_Attachments
3274: ( p_api_version IN NUMBER,
3383: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3384:
3385: BEGIN
3386:
3387: -- Standard Start of API savepoint
3388: SAVEPOINT copy_Attachments;
3389:
3390: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3391: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3392: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3393: 'Entered Copy_Attachments API');
3394: END IF;
3395:
3396: -- Standard call to check for call compatibility.
3397: IF NOT Fnd_Api.Compatible_API_Call (l_api_version,
3398: p_api_version,
3399: l_api_name,
3400: G_PKG_NAME)
3720: END IF;
3721:
3722: -- Api body ends here
3723:
3724: -- Standard check of p_commit.
3725: IF Fnd_Api.To_Boolean( p_commit ) THEN
3726: COMMIT;
3727: END IF;
3728:
3725: IF Fnd_Api.To_Boolean( p_commit ) THEN
3726: COMMIT;
3727: END IF;
3728:
3729: -- Standard call to get message count and if count is 1, get message info
3730: Fnd_Msg_Pub.Count_And_Get
3731: (p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3787: /* procedure name: Delete_Attachments */
3788: /* description : This procedure deletes all the attachements */
3789: /* linked with the repair line id. */
3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3788: /* description : This procedure deletes all the attachements */
3789: /* linked with the repair line id. */
3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3789: /* linked with the repair line id. */
3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */
3799: /* */
3800: /*------------------------------------------------------------------*/
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */
3799: /* */
3800: /*------------------------------------------------------------------*/
3801: PROCEDURE Delete_Attachments
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */
3799: /* */
3800: /*------------------------------------------------------------------*/
3801: PROCEDURE Delete_Attachments
3802: (p_api_version IN NUMBER,
3817: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3818:
3819: BEGIN
3820:
3821: -- Standard Start of API savepoint
3822: SAVEPOINT Delete_Attachments;
3823:
3824: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3826: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3827: 'Entered Delete_Attachments API');
3828: END IF;
3829:
3830: -- Standard call to check for call compatibility.
3831: IF NOT Fnd_Api.Compatible_API_Call (l_api_version,
3832: p_api_version,
3833: l_api_name,
3834: G_PKG_NAME)
3989: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id);
3990:
3991: -- Api body ends here
3992:
3993: -- Standard check of p_commit.
3994: IF Fnd_Api.To_Boolean( p_commit ) THEN
3995: COMMIT;
3996: END IF;
3997:
3994: IF Fnd_Api.To_Boolean( p_commit ) THEN
3995: COMMIT;
3996: END IF;
3997:
3998: -- Standard call to get message count and if count is 1, get message info
3999: Fnd_Msg_Pub.Count_And_Get
4000: (p_count => x_msg_count,
4001: p_data => x_msg_data);
4002:
4120: WHERE FLOW_STATUS_ID = p_repair_status_id;
4121:
4122:
4123: BEGIN
4124: --------------------Standard stuff -------------------------
4125: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4126: Fnd_Log.STRING (Fnd_Log.level_procedure,
4127: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',
4128: 'Entering update_ro_status private api');
4245:
4246:
4247: -- Api body ends here
4248:
4249: -- Standard check of p_commit.
4250: IF Fnd_Api.to_boolean (p_commit) THEN
4251: COMMIT WORK;
4252: END IF;
4253:
4250: IF Fnd_Api.to_boolean (p_commit) THEN
4251: COMMIT WORK;
4252: END IF;
4253:
4254: -- Standard call to get message count and IF count is get message info.
4255: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4256:
4257: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4258: Fnd_Log.STRING (Fnd_Log.level_procedure,
4393: WHERE repair_line_id = p_repair_line_id;
4394:
4395: BEGIN
4396:
4397: -- Standard Start of API savepoint
4398: SAVEPOINT Update_Flow_Status;
4399:
4400: -- Standard call to check for call compatibility.
4401: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
4396:
4397: -- Standard Start of API savepoint
4398: SAVEPOINT Update_Flow_Status;
4399:
4400: -- Standard call to check for call compatibility.
4401: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
4402: p_api_version,
4403: lc_api_name ,
4404: G_PKG_NAME )
4809:
4810: -- Api body ends here
4811:
4812: --debug('update_flow_status: Step 13');
4813: -- Standard check of p_commit.
4814: IF Fnd_Api.To_Boolean( p_commit ) THEN
4815: COMMIT WORK;
4816: END IF;
4817: --debug('update_flow_status: Step 14');
4815: COMMIT WORK;
4816: END IF;
4817: --debug('update_flow_status: Step 14');
4818:
4819: -- Standard call to get message count and IF count is get message info.
4820: Fnd_Msg_Pub.Count_And_Get
4821: (p_count => x_msg_count,
4822: p_data => x_msg_data );
4823:
5037: CRTV1.REPAIR_TYPE_Id = p_to_repair_type_id;
5038:
5039: BEGIN
5040:
5041: -- Standard Start of API savepoint
5042: SAVEPOINT Update_Repair_Type;
5043:
5044: -- Standard call to check for call compatibility.
5045: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5040:
5041: -- Standard Start of API savepoint
5042: SAVEPOINT Update_Repair_Type;
5043:
5044: -- Standard call to check for call compatibility.
5045: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5046: p_api_version,
5047: lc_api_name ,
5048: G_PKG_NAME )
5334: END IF;
5335:
5336: -- Api body ends here
5337:
5338: -- Standard check of p_commit.
5339: IF Fnd_Api.To_Boolean( p_commit ) THEN
5340: COMMIT WORK;
5341: END IF;
5342:
5339: IF Fnd_Api.To_Boolean( p_commit ) THEN
5340: COMMIT WORK;
5341: END IF;
5342:
5343: -- Standard call to get message count and IF count is get message info.
5344: Fnd_Msg_Pub.Count_And_Get
5345: (p_count => x_msg_count,
5346: p_data => x_msg_data );
5347:
5533: l_wf_avalue_TabType Wf_Engine.NumTabTyp;
5534:
5535: BEGIN
5536:
5537: -- Standard Start of API savepoint
5538: SAVEPOINT Launch_Flwsts_Wf;
5539:
5540: -- Standard call to check for call compatibility.
5541: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5536:
5537: -- Standard Start of API savepoint
5538: SAVEPOINT Launch_Flwsts_Wf;
5539:
5540: -- Standard call to check for call compatibility.
5541: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5542: p_api_version,
5543: lc_api_name,
5544: G_PKG_NAME)
5704: -- Wf_Engine.threshold := l_wf_current_threshold;
5705:
5706: -- Api body ends here
5707:
5708: -- Standard check of p_commit.
5709: IF Fnd_Api.To_Boolean( p_commit ) THEN
5710: COMMIT WORK;
5711: END IF;
5712:
5709: IF Fnd_Api.To_Boolean( p_commit ) THEN
5710: COMMIT WORK;
5711: END IF;
5712:
5713: -- Standard call to get message count and IF count is get message info.
5714: Fnd_Msg_Pub.Count_And_Get
5715: (p_count => x_msg_count,
5716: p_data => x_msg_data );
5717:
5844: lc_api_name CONSTANT VARCHAR2(30) := 'update_ro_status_websrvc';
5845: lc_api_version CONSTANT NUMBER := 1.0;
5846:
5847: BEGIN
5848: -- Standard Start of API savepoint
5849: SAVEPOINT UPDATE_RO_STATUS_WEBSRVC_PVT;
5850:
5851: -- Standard call to check for call compatibility.
5852: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5847: BEGIN
5848: -- Standard Start of API savepoint
5849: SAVEPOINT UPDATE_RO_STATUS_WEBSRVC_PVT;
5850:
5851: -- Standard call to check for call compatibility.
5852: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5853: p_api_version,
5854: lc_api_name,
5855: G_PKG_NAME)
5904: P_STATUS_CONTROL_REC => l_status_upd_control_rec,
5905: X_OBJECT_VERSION_NUMBER => l_object_Version_number);
5906: --
5907:
5908: -- Standard check of p_commit.
5909: IF Fnd_Api.To_Boolean( p_commit ) THEN
5910: COMMIT WORK;
5911: END IF;
5912:
5909: IF Fnd_Api.To_Boolean( p_commit ) THEN
5910: COMMIT WORK;
5911: END IF;
5912:
5913: -- Standard call to get message count and IF count is get message info.
5914: Fnd_Msg_Pub.Count_And_Get
5915: (p_count => x_msg_count,
5916: p_data => x_msg_data );
5917:
6040: ( p_event_name => 'oracle.apps.csd.repair.status.change',
6041: p_event_key => l_event_key,
6042: p_parameters => l_param_list);
6043:
6044: -- Standard check of p_commit.
6045: If FND_API.To_Boolean( p_commit ) then
6046: commit;
6047: End if;
6048: