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.CSD_SPLIT_PKG dependencies on CSD_REPAIRS

Line 33: l_rep_line_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;

29: IS
30: l_api_name CONSTANT VARCHAR2(30) := 'Split_Repair_Order' ;
31: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
32: l_api_version CONSTANT NUMBER := 1.0 ;
33: l_rep_line_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
34: l_original_rep_line_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
35: l_total_original_quantity NUMBER;
36: l_org_new_quantity NUMBER;
37: l_repair_history_Rec CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type;

Line 34: l_original_rep_line_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;

30: l_api_name CONSTANT VARCHAR2(30) := 'Split_Repair_Order' ;
31: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
32: l_api_version CONSTANT NUMBER := 1.0 ;
33: l_rep_line_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
34: l_original_rep_line_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
35: l_total_original_quantity NUMBER;
36: l_org_new_quantity NUMBER;
37: l_repair_history_Rec CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type;
38: l_repair_history_id NUMBER;

Line 57: from csd_repair_types_vl crtv, csd_repairs cr

53: l_msg_data VARCHAR2 (2000);
54:
55: CURSOR c_repair_type_name(p_original_repair_line_id IN NUMBER) IS
56: SELECT crtv.name
57: from csd_repair_types_vl crtv, csd_repairs cr
58: where cr.repair_line_id = p_original_repair_line_id and crtv.repair_type_id = cr.repair_type_id;
59:
60: Begin
61:

Line 119: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

115:
116: if (p_split_option = 1) then
117: --Update the current RO quantity. call update_repair_order
118: if (l_org_new_quantity = 0) then
119: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
120: (
121: p_QUANTITY => l_org_new_quantity,
122: p_STATUS => 'C',
123: p_object_version_number => l_rep_line_rec.object_version_number,

Line 127: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

123: p_object_version_number => l_rep_line_rec.object_version_number,
124: x_repln_rec => l_original_rep_line_rec
125: );
126: else
127: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
128: (
129: p_QUANTITY => l_org_new_quantity,
130: p_object_version_number => l_rep_line_rec.object_version_number,
131: x_repln_rec => l_original_rep_line_rec

Line 135: CSD_REPAIRS_PVT.Update_Repair_Order

131: x_repln_rec => l_original_rep_line_rec
132: );
133: end if;
134:
135: CSD_REPAIRS_PVT.Update_Repair_Order
136: (p_API_version_number => 1.0,
137: p_init_msg_list => FND_API.G_TRUE,
138: p_commit => FND_API.G_FALSE,
139: p_validation_level => null,

Line 148: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');

144: x_msg_data => x_msg_data
145: );
146: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: IF(l_statement_level >= l_debug_level) THEN
148: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
149: END IF;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:

Line 267: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

263: return;
264: end if;
265:
266: --Update the current RO quantity.
267: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
268: (
269: p_QUANTITY => 1,
270: p_object_version_number => l_rep_line_rec.object_version_number,
271: x_repln_rec => l_original_rep_line_rec

Line 274: CSD_REPAIRS_PVT.Update_Repair_Order

270: p_object_version_number => l_rep_line_rec.object_version_number,
271: x_repln_rec => l_original_rep_line_rec
272: );
273:
274: CSD_REPAIRS_PVT.Update_Repair_Order
275: (p_API_version_number => 1.0,
276: p_init_msg_list => FND_API.G_TRUE,
277: p_commit => FND_API.G_FALSE,
278: p_validation_level => null,

Line 287: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');

283: x_msg_data => x_msg_data
284: );
285: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
286: IF(l_statement_level >= l_debug_level) THEN
287: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
288: END IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:

Line 450: x_Repln_Rec OUT NOCOPY CSD_REPAIRS_PUB.Repln_Rec_Type,

446: End Split_Repair_Order;
447:
448: PROCEDURE Build_Repln_Record (
449: p_repair_line_id IN NUMBER,
450: x_Repln_Rec OUT NOCOPY CSD_REPAIRS_PUB.Repln_Rec_Type,
451: x_return_status OUT NOCOPY VARCHAR2
452: )
453: IS
454:

Line 528: FROM csd_repairs

524: ,attribute27
525: ,attribute28
526: ,attribute29
527: ,attribute30
528: FROM csd_repairs
529: where repair_line_id = p_repair_line_id;
530:
531: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
532: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 865: FROM csd_repairs_v crv, csd_repair_types_vl crtv

861: WHERE repair_line_id = p_repair_line_id and action_type = 'SHIP';
862:
863: CURSOR c_repair_type_ref(p_repair_line_id IN NUMBER) IS
864: SELECT crtv.repair_type_ref
865: FROM csd_repairs_v crv, csd_repair_types_vl crtv
866: WHERE repair_line_id = p_repair_line_id and crv.repair_type_id = crtv.repair_type_id;
867:
868: CURSOR c_wip_job(p_repair_line_id IN NUMBER) IS
869: SELECT count(*)

Line 1062: p_rep_line_rec IN CSD_REPAIRS_PUB.REPLN_REC_TYPE

1058: x_msg_data OUT NOCOPY VARCHAR2,
1059: x_repair_line_id OUT NOCOPY NUMBER,
1060: p_copy_attachment IN VARCHAR2,
1061: p_original_repair_line_id IN NUMBER,
1062: p_rep_line_rec IN CSD_REPAIRS_PUB.REPLN_REC_TYPE
1063: ) IS
1064:
1065: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Repair_Order' ;
1066: l_original_product_txn_rec CSD_PROCESS_PVT.PRODUCT_TXN_REC;

Line 1097: CSD_REPAIRS_PVT.Create_Repair_Order

1093: -- API body
1094: --
1095: -- Local Procedure
1096:
1097: CSD_REPAIRS_PVT.Create_Repair_Order
1098: (p_API_version_number => 1.0,
1099: p_init_msg_list => p_init_msg_list,
1100: p_commit => p_commit,
1101: p_validation_level => null,

Line 1112: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Create_Repair_Order','failed');

1108: x_msg_data => x_msg_data
1109: );
1110: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1111: IF(l_statement_level >= l_debug_level) THEN
1112: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Create_Repair_Order','failed');
1113: END IF;
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:

Line 1273: CSD_REPAIRS_PVT.Copy_Attachments

1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;
1271:
1272: If (p_copy_attachment = 'Y') THEN
1273: CSD_REPAIRS_PVT.Copy_Attachments
1274: ( p_api_version => 1.0,
1275: p_commit => p_commit,
1276: p_init_msg_list => p_init_msg_list,
1277: p_validation_level => p_validation_level,

Line 1286: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Copy_Attachments','failed');

1282: x_msg_data => x_msg_data);
1283:
1284: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1285: IF(l_statement_level >= l_debug_level) THEN
1286: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Copy_Attachments','failed');
1287: END IF;
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
1290: END if;

Line 1786: FROM csd_repairs cr,

1782: cr.inventory_org_id,
1783: cr.project_id,
1784: cr.task_id,
1785: cr.unit_number
1786: FROM csd_repairs cr,
1787: csd_repair_types_vl crt
1788: WHERE cr.repair_type_id = crt.repair_type_id
1789: and cr.repair_line_id = p_rep_line_id;
1790: