[Home] [Help]
104: edt.quantity_required,
105: edt.selling_price,
106: nvl(edt.contract_discount_amount,0) contract_discount_amount,
107: edt.after_warranty_cost
108: FROM cs_estimate_details edt,
109: cs_incidents_all_b inc,
110: hz_parties hzp
111: WHERE edt.incident_id = inc.incident_id
112: AND edt.bill_to_party_id = hzp.party_id;
132: ced.currency_code,
133: sum(ced.after_warranty_cost) Total_Charges
134: FROM cs_incidents_all_b ciab,
135: cs_incident_types cit,
136: cs_estimate_details ced
137: WHERE ciab.incident_id = ced.incident_id
138: AND ciab.incident_type_id = cit.incident_type_id
139: AND ced.charge_line_type IN ('ACTUAL','IN_PROGRESS')
140: AND ced.incident_id = p_incident_id
153: edt.currency_code,
154: inc.incident_number,
155: inc.incident_date,
156: inc.incident_id
157: FROM cs_estimate_details edt,
158: cs_incidents_all_b inc
159: WHERE edt.incident_id = p_incident_id
160: AND inc.incident_id = edt.incident_id
161: GROUP BY currency_code,inc.incident_id,inc.incident_number,inc.incident_date;
187: -- Cursor for deriving no_charge_flag
188: CURSOR cs_charge_flags(p_estimate_detail_id number) IS
189: SELECT nvl(edt.no_charge_flag,'N') chg_no_charge_flag,
190: nvl(tt.no_charge_flag,'N') txn_no_charge_flag
191: FROM cs_estimate_details edt,
192: cs_transaction_types tt
193: WHERE edt.estimate_detail_id = p_estimate_detail_id
194: AND tt.transaction_type_id = edt.transaction_type_id;
195: --
304: ced.selling_price,
305: nvl(ced.contract_discount_amount,0) contract_discount_amount,
306: ced.after_warranty_cost
307: FROM cs_incidents_all_b ciab,
308: cs_estimate_details ced,
309: hz_parties hzp
310: WHERE ciab.incident_id = ced.incident_id
311: AND ced.bill_to_party_id = hzp.party_id
312: AND ced.line_submitted = 'N'
335: ced.selling_price,
336: nvl(ced.contract_discount_amount,0) contract_discount_amount,
337: ced.after_warranty_cost
338: FROM cs_incidents_all_b ciab,
339: cs_estimate_details ced,
340: hz_parties hzp
341: WHERE ciab.incident_id = ced.incident_id
342: AND ced.bill_to_party_id = hzp.party_id
343: AND ced.line_submitted = 'N'
377: ced.selling_price,
378: nvl(ced.contract_discount_amount,0) contract_discount_amount,
379: ced.after_warranty_cost
380: FROM cs_incidents_all_b ciab,
381: cs_estimate_details ced,
382: hz_parties hzp
383: WHERE ciab.incident_id = ced.incident_id
384: AND ced.bill_to_party_id = hzp.party_id
385: AND ced.line_submitted = 'N'
421: nvl(ced.contract_discount_amount,0) contract_discount_amount,
422: ced.after_warranty_cost
423: FROM cs_incidents_all_b ciab,
424: hz_parties hzp,
425: cs_estimate_details ced
426: WHERE ciab.incident_id = ced.incident_id
427: AND ced.bill_to_party_id = hzp.party_id
428: AND ciab.status_flag = 'C'
429: AND ced.line_submitted = 'N'
1293: -- Only actual charge lines are stamped with the restriction message
1294: -- Bug fix:3608980
1295: CURSOR Charge_Line_Count(p_incident_id NUMBER,p_currency_code VARCHAR2) IS
1296: SELECT estimate_detail_id
1297: FROM cs_estimate_details
1298: WHERE incident_id = p_incident_id
1299: AND charge_line_type = 'ACTUAL'
1300: AND source_code = 'SD'
1301: AND original_source_code = 'SR'
1328:
1329:
1330: IF p_restriction_type = 'LINE' THEN
1331:
1332: UPDATE CS_ESTIMATE_DETAILS
1333: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1334: line_submitted = p_line_submitted,
1335: last_update_date = sysdate, -- bug 8838622
1336: last_update_login = fnd_global.login_id, -- bug 8838622
1349: INTO chglnctTAB(t);
1350: EXIT WHEN Charge_Line_Count%NOTFOUND;
1351:
1352:
1353: UPDATE CS_ESTIMATE_DETAILS
1354: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1355: line_submitted = p_line_submitted,
1356: last_update_date = sysdate, -- bug 8838622
1357: last_update_login = fnd_global.login_id, -- bug 8838622
1374: FETCH Charge_Line_Count
1375: INTO chglnctTAB(t);
1376: EXIT WHEN Charge_Line_Count%NOTFOUND;
1377:
1378: UPDATE CS_ESTIMATE_DETAILS
1379: SET submit_restriction_message = NULL,
1380: line_submitted = p_line_submitted,
1381: last_update_date = sysdate, -- bug 8838622
1382: last_update_login = fnd_global.login_id, -- bug 8838622