DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CSD_REPAIRS_PUB

Line 69: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,

65: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
66: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
67: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
68: p_REPAIR_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
69: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
70: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
71: X_REPAIR_NUMBER OUT NOCOPY VARCHAR2,
72: X_Return_Status OUT NOCOPY VARCHAR2,
73: X_Msg_Count OUT NOCOPY NUMBER,

Line 96: l_REPLN_Rec Csd_Repairs_Pub.REPLN_Rec_Type; -- swai bug 7657379

92: l_date_closed DATE;
93: l_resolve_by_date DATE; --rfieldma: 5355051
94: l_business_process_id NUMBER; -- rfieldma: 5355051
95: l_severity_id NUMBER; -- rfieldma: 5355051
96: l_REPLN_Rec Csd_Repairs_Pub.REPLN_Rec_Type; -- swai bug 7657379
97:
98: -- bug#7043215, subhat
99: -- new DFF value rec.
100: x_dff_value_rec CSD_REPAIRS_UTIL.DEF_Rec_Type;

Line 748: P_REPLN_Rec IN OUT NOCOPY Csd_Repairs_Pub.REPLN_Rec_Type,

744: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
745: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
746: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
747: p_REPAIR_LINE_ID IN NUMBER,
748: P_REPLN_Rec IN OUT NOCOPY Csd_Repairs_Pub.REPLN_Rec_Type,
749: X_Return_Status OUT NOCOPY VARCHAR2,
750: X_Msg_Count OUT NOCOPY NUMBER,
751: X_Msg_Data OUT NOCOPY VARCHAR2
752: )

Line 858: l_OLD_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type;

854: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
855:
856: l_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Order';
857: l_api_version_number CONSTANT NUMBER := 1.0;
858: l_OLD_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type;
859: l_NEW_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type := P_REPLN_Rec;
860: l_rowid ROWID;
861: l_repair_line_id NUMBER;
862: l_OBJECT_VERSION_NUMBER NUMBER;

Line 859: l_NEW_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type := P_REPLN_Rec;

855:
856: l_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Order';
857: l_api_version_number CONSTANT NUMBER := 1.0;
858: l_OLD_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type;
859: l_NEW_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type := P_REPLN_Rec;
860: l_rowid ROWID;
861: l_repair_line_id NUMBER;
862: l_OBJECT_VERSION_NUMBER NUMBER;
863:

Line 1023: -- should use csd_repairs_pub.update_repair_type to update repair type, not this function

1019: END IF;
1020: CLOSE C_Get_repairs;
1021:
1022: -- bug#12884352
1023: -- should use csd_repairs_pub.update_repair_type to update repair type, not this function
1024: IF P_REPLN_rec.repair_type_id is not NULL and P_REPLN_rec.repair_type_id <> Fnd_Api.G_MISS_NUM and l_OLD_REPLN_rec.repair_type_id <> P_REPLN_Rec.repair_type_id THEN
1025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1026: Fnd_Message.Set_Name('CSD', 'CSD_UPDATE_REPAIR_TYPE');
1027: Fnd_Msg_Pub.ADD;

Line 2562: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,

2558: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
2559: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2560: P_Validation_mode IN VARCHAR2,
2561: p_repair_line_id IN NUMBER := Fnd_Api.G_MISS_NUM,
2562: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
2563: P_OLD_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type := Csd_Repairs_Pub.G_MISS_REPLN_Rec,
2564: x_return_status OUT NOCOPY VARCHAR2,
2565: x_msg_count OUT NOCOPY NUMBER,
2566: x_msg_data OUT NOCOPY VARCHAR2,

Line 2563: P_OLD_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type := Csd_Repairs_Pub.G_MISS_REPLN_Rec,

2559: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2560: P_Validation_mode IN VARCHAR2,
2561: p_repair_line_id IN NUMBER := Fnd_Api.G_MISS_NUM,
2562: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
2563: P_OLD_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type := Csd_Repairs_Pub.G_MISS_REPLN_Rec,
2564: x_return_status OUT NOCOPY VARCHAR2,
2565: x_msg_count OUT NOCOPY NUMBER,
2566: x_msg_data OUT NOCOPY VARCHAR2,
2567: -- bug#7242791, subhat

Line 4067: -- p_repair_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC,

4063: -- p_api_version IN NUMBER,
4064: -- p_commit IN VARCHAR2,
4065: -- p_init_msg_list IN VARCHAR2,
4066: -- p_validation_level IN NUMBER,
4067: -- p_repair_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC,
4068: -- p_status_control_rec IN CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC,
4069: -- OUT
4070: -- x_return_status
4071: -- x_msg_count

Line 4068: -- p_status_control_rec IN CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC,

4064: -- p_commit IN VARCHAR2,
4065: -- p_init_msg_list IN VARCHAR2,
4066: -- p_validation_level IN NUMBER,
4067: -- p_repair_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC,
4068: -- p_status_control_rec IN CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC,
4069: -- OUT
4070: -- x_return_status
4071: -- x_msg_count
4072: -- x_msg_data

Line 4093: p_repair_status_Rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,

4089: p_validation_level IN NUMBER,
4090: x_return_status OUT NOCOPY VARCHAR2,
4091: x_msg_count OUT NOCOPY NUMBER,
4092: x_msg_data OUT NOCOPY VARCHAR2,
4093: p_repair_status_Rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
4094: p_status_control_rec IN Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE,
4095: x_object_version_number OUT NOCOPY NUMBER
4096: ) IS
4097: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4094: p_status_control_rec IN Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE,

4090: x_return_status OUT NOCOPY VARCHAR2,
4091: x_msg_count OUT NOCOPY NUMBER,
4092: x_msg_data OUT NOCOPY VARCHAR2,
4093: p_repair_status_Rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
4094: p_status_control_rec IN Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE,
4095: x_object_version_number OUT NOCOPY NUMBER
4096: ) IS
4097: l_api_version_number CONSTANT NUMBER := 1.0;
4098: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_RO_STATUS';

Line 4106: l_repair_status_Rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;

4102: l_msg_data VARCHAR2 (2000);
4103: l_incident_id NUMBER;
4104: l_repair_type_id NUMBER;
4105: l_object_version_number NUMBER;
4106: l_repair_status_Rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;
4107:
4108: --Define cursors
4109:
4110: --Get the flow status id from csd_repairs

Line 5838: l_repair_status_rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;

5834: p_check_task_wip IN VARCHAR2,
5835: p_object_version_number IN NUMBER
5836:
5837: ) IS
5838: l_repair_status_rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;
5839: l_status_upd_control_rec Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE;
5840: l_object_Version_number NUMBER;
5841: l_return_status VARCHAR2(1);
5842:

Line 5839: l_status_upd_control_rec Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE;

5835: p_object_version_number IN NUMBER
5836:
5837: ) IS
5838: l_repair_status_rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;
5839: l_status_upd_control_rec Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE;
5840: l_object_Version_number NUMBER;
5841: l_return_status VARCHAR2(1);
5842:
5843: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_pvt.update_ro_status_websrvc';