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 529: FROM csd_repairs

525: ,attribute28
526: ,attribute29
527: ,attribute30
528: ,parent_repair_line_id --bug#13698799 auto create ro, parent ro
529: FROM csd_repairs
530: where repair_line_id = p_repair_line_id;
531:
532: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
533: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 867: FROM csd_repairs_v crv, csd_repair_types_vl crtv

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

Line 1064: p_rep_line_rec IN CSD_REPAIRS_PUB.REPLN_REC_TYPE

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

Line 1099: CSD_REPAIRS_PVT.Create_Repair_Order

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

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

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

Line 1275: CSD_REPAIRS_PVT.Copy_Attachments

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

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

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

Line 1788: FROM csd_repairs cr,

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