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 568: P_REPLN_Rec IN OUT NOCOPY Csd_Repairs_Pub.REPLN_Rec_Type,

564: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
565: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
566: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
567: p_REPAIR_LINE_ID IN NUMBER,
568: P_REPLN_Rec IN OUT NOCOPY Csd_Repairs_Pub.REPLN_Rec_Type,
569: X_Return_Status OUT NOCOPY VARCHAR2,
570: X_Msg_Count OUT NOCOPY NUMBER,
571: X_Msg_Data OUT NOCOPY VARCHAR2
572: )

Line 644: l_OLD_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type;

640: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
641:
642: l_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Order';
643: l_api_version_number CONSTANT NUMBER := 1.0;
644: l_OLD_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type;
645: l_NEW_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type := P_REPLN_Rec;
646: l_rowid ROWID;
647: l_repair_line_id NUMBER;
648: l_OBJECT_VERSION_NUMBER NUMBER;

Line 645: l_NEW_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type := P_REPLN_Rec;

641:
642: l_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Order';
643: l_api_version_number CONSTANT NUMBER := 1.0;
644: l_OLD_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type;
645: l_NEW_REPLN_rec Csd_Repairs_Pub.REPLN_Rec_Type := P_REPLN_Rec;
646: l_rowid ROWID;
647: l_repair_line_id NUMBER;
648: l_OBJECT_VERSION_NUMBER NUMBER;
649:

Line 2254: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,

2250: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
2251: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2252: P_Validation_mode IN VARCHAR2,
2253: p_repair_line_id IN NUMBER := Fnd_Api.G_MISS_NUM,
2254: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
2255: P_OLD_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type := Csd_Repairs_Pub.G_MISS_REPLN_Rec,
2256: x_return_status OUT NOCOPY VARCHAR2,
2257: x_msg_count OUT NOCOPY NUMBER,
2258: x_msg_data OUT NOCOPY VARCHAR2,

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

2251: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2252: P_Validation_mode IN VARCHAR2,
2253: p_repair_line_id IN NUMBER := Fnd_Api.G_MISS_NUM,
2254: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
2255: P_OLD_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type := Csd_Repairs_Pub.G_MISS_REPLN_Rec,
2256: x_return_status OUT NOCOPY VARCHAR2,
2257: x_msg_count OUT NOCOPY NUMBER,
2258: x_msg_data OUT NOCOPY VARCHAR2,
2259: -- bug#7242791, subhat

Line 3759: -- p_repair_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC,

3755: -- p_api_version IN NUMBER,
3756: -- p_commit IN VARCHAR2,
3757: -- p_init_msg_list IN VARCHAR2,
3758: -- p_validation_level IN NUMBER,
3759: -- p_repair_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC,
3760: -- p_status_control_rec IN CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC,
3761: -- OUT
3762: -- x_return_status
3763: -- x_msg_count

Line 3760: -- p_status_control_rec IN CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC,

3756: -- p_commit IN VARCHAR2,
3757: -- p_init_msg_list IN VARCHAR2,
3758: -- p_validation_level IN NUMBER,
3759: -- p_repair_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC,
3760: -- p_status_control_rec IN CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC,
3761: -- OUT
3762: -- x_return_status
3763: -- x_msg_count
3764: -- x_msg_data

Line 3785: p_repair_status_Rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,

3781: p_validation_level IN NUMBER,
3782: x_return_status OUT NOCOPY VARCHAR2,
3783: x_msg_count OUT NOCOPY NUMBER,
3784: x_msg_data OUT NOCOPY VARCHAR2,
3785: p_repair_status_Rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
3786: p_status_control_rec IN Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE,
3787: x_object_version_number OUT NOCOPY NUMBER
3788: ) IS
3789: l_api_version_number CONSTANT NUMBER := 1.0;

Line 3786: p_status_control_rec IN Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE,

3782: x_return_status OUT NOCOPY VARCHAR2,
3783: x_msg_count OUT NOCOPY NUMBER,
3784: x_msg_data OUT NOCOPY VARCHAR2,
3785: p_repair_status_Rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
3786: p_status_control_rec IN Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE,
3787: x_object_version_number OUT NOCOPY NUMBER
3788: ) IS
3789: l_api_version_number CONSTANT NUMBER := 1.0;
3790: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_RO_STATUS';

Line 3798: l_repair_status_Rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;

3794: l_msg_data VARCHAR2 (2000);
3795: l_incident_id NUMBER;
3796: l_repair_type_id NUMBER;
3797: l_object_version_number NUMBER;
3798: l_repair_status_Rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;
3799:
3800: --Define cursors
3801:
3802: --Get the flow status id from csd_repairs

Line 5527: l_repair_status_rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;

5523: p_check_task_wip IN VARCHAR2,
5524: p_object_version_number IN NUMBER
5525:
5526: ) IS
5527: l_repair_status_rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;
5528: l_status_upd_control_rec Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE;
5529: l_object_Version_number NUMBER;
5530: l_return_status VARCHAR2(1);
5531:

Line 5528: l_status_upd_control_rec Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE;

5524: p_object_version_number IN NUMBER
5525:
5526: ) IS
5527: l_repair_status_rec Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE;
5528: l_status_upd_control_rec Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE;
5529: l_object_Version_number NUMBER;
5530: l_return_status VARCHAR2(1);
5531:
5532: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_pvt.update_ro_status_websrvc';