APPS.CSD_REPAIR_GROUPS_PVT dependencies on CSD_REPAIRS

Line 97: CSD_REPAIRS_UTIL.check_reqd_param

93: csd_gen_utility_pvt.ADD('Check reqd parameter : Incident Id');
94: END IF;
95:
96:
97: CSD_REPAIRS_UTIL.check_reqd_param
98: (p_param_value => x_repair_order_group_rec.incident_id,
99: p_param_name => 'INCIDENT_ID',
100: p_api_name => l_api_name
101: );

Line 108: CSD_REPAIRS_UTIL.check_reqd_param

104: csd_gen_utility_pvt.ADD('Check reqd parameter : Inventory Item Id');
105: END IF;
106:
107:
108: CSD_REPAIRS_UTIL.check_reqd_param
109: (p_param_value => x_repair_order_group_rec.inventory_item_id,
110: p_param_name => 'INVENTORY_ITEM_ID',
111: p_api_name => l_api_name
112: );

Line 119: CSD_REPAIRS_UTIL.check_reqd_param

115: csd_gen_utility_pvt.ADD('Check reqd parameter : Unit of Measure');
116: END IF;
117:
118:
119: CSD_REPAIRS_UTIL.check_reqd_param
120: (p_param_value => x_repair_order_group_rec.unit_of_measure,
121: p_param_name => 'UNIT_OF_MEASURE',
122: p_api_name => l_api_name
123: );

Line 130: CSD_REPAIRS_UTIL.check_reqd_param

126: csd_gen_utility_pvt.ADD('Check reqd parameter : Repair Type Id');
127: END IF;
128:
129:
130: CSD_REPAIRS_UTIL.check_reqd_param
131: (p_param_value => x_repair_order_group_rec.repair_type_id,
132: p_param_name => 'REPAIR_TYPE_ID',
133: p_api_name => l_api_name
134: );

Line 517: FROM csd_repairs

513: BEGIN
514: SELECT
515: count(*)
516: INTO l_count
517: FROM csd_repairs
518: WHERE repair_group_id = x_repair_order_group_rec.repair_group_id;
519:
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN

Line 767: FROM csd_repairs

763: BEGIN
764: SELECT
765: count(*)
766: INTO l_count
767: FROM csd_repairs
768: WHERE repair_group_id = p_repair_group_id;
769:
770: EXCEPTION
771: WHEN NO_DATA_FOUND THEN

Line 984: l_ro_rec csd_repairs_pub.repln_rec_type := csd_process_util.repair_order_rec;

980: l_msg_count NUMBER;
981: l_msg_data VARCHAR2(100);
982: l_msg_index NUMBER;
983: l_dummy VARCHAR2(10);
984: l_ro_rec csd_repairs_pub.repln_rec_type := csd_process_util.repair_order_rec;
985: l_object_version_number NUMBER;
986: l_group_object_version_number NUMBER;
987: l_group_ro_rec csd_repair_groups_pvt.repair_order_group_rec;
988: l_return_status Varchar2(10);

Line 998: SELECT repair_line_id,repair_number from csd_repairs

994:
995:
996: Cursor Repair_Orders(p_repair_order_group in Number)
997: IS
998: SELECT repair_line_id,repair_number from csd_repairs
999: WHERE repair_group_id = p_repair_order_group
1000: FOR UPDATE NOWAIT;
1001:
1002: BEGIN

Line 1131: from csd_repairs

1127: l_object_version_number := 0;
1128:
1129: select object_version_number
1130: into l_object_version_number
1131: from csd_repairs
1132: where repair_line_id = RO_record.repair_line_id;
1133:
1134: Exception
1135: when others then

Line 1141: CSD_REPAIRS_PVT.Update_Repair_Order

1137: End;
1138:
1139: l_ro_rec.object_version_number := l_object_version_number;
1140:
1141: CSD_REPAIRS_PVT.Update_Repair_Order
1142: (P_Api_Version_Number => 1.0,
1143: P_Init_Msg_List => 'T',
1144: P_Commit => 'F',
1145: p_validation_level => 0,

Line 1197: FROM csd_repairs

1193:
1194: BEGIN
1195: SELECT COUNT(*)
1196: INTO l_tot_approved
1197: FROM csd_repairs
1198: WHERE repair_group_id = p_repair_group_id
1199: AND approval_status = 'A'
1200: AND approval_required_flag = 'Y';
1201: EXCEPTION

Line 1213: FROM csd_repairs

1209:
1210: BEGIN
1211: SELECT COUNT(*)
1212: INTO l_tot_rejected
1213: FROM csd_repairs
1214: WHERE repair_group_id = p_repair_group_id
1215: AND approval_status = 'R'
1216: AND approval_required_flag = 'Y';
1217: EXCEPTION

Line 1228: FROM csd_repairs

1224:
1225: BEGIN
1226: SELECT COUNT(*)
1227: INTO l_tot_no_approval
1228: FROM csd_repairs
1229: WHERE repair_group_id = p_repair_group_id
1230: AND approval_required_flag = 'N';
1231: EXCEPTION
1232: WHEN OTHERS THEN