APPS.CSD_RULES_ENGINE_PVT dependencies on CSD_REPAIRS

Line 483: l_repair_status_rec CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE;

479:
480: l_object_version_number NUMBER;
481: x_object_version_number number;
482:
483: l_repair_status_rec CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE;
484: l_status_upd_control_rec CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC_TYPE;
485:
486: BEGIN
487: SAVEPOINT PROCESS_SOO_RULE;

Line 484: l_status_upd_control_rec CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC_TYPE;

480: l_object_version_number NUMBER;
481: x_object_version_number number;
482:
483: l_repair_status_rec CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE;
484: l_status_upd_control_rec CSD_REPAIRS_PUB.STATUS_UPD_CONTROL_REC_TYPE;
485:
486: BEGIN
487: SAVEPOINT PROCESS_SOO_RULE;
488:

Line 511: from csd_repairs cr

507:
508: IF p_ro_flow_status_id is not null THEN
509: select cr.object_version_number
510: into l_object_version_number
511: from csd_repairs cr
512: where cr.repair_line_id = p_rule_input_rec.repair_line_id;
513:
514: l_repair_status_rec.repair_line_id := p_rule_input_rec.repair_line_id;
515: l_repair_status_rec.repair_status_id := p_ro_flow_status_id;

Line 521: csd_repairs_pvt.update_ro_status(p_api_version => p_api_version_number,

517: l_repair_status_rec.object_version_number := l_object_version_number;
518:
519: l_status_upd_control_rec.check_task_wip := 'N';
520:
521: csd_repairs_pvt.update_ro_status(p_api_version => p_api_version_number,
522: p_commit => fnd_api.g_false,
523: p_init_msg_list => p_init_msg_list,
524: p_validation_level => p_validation_level,
525: x_return_status => x_return_status,

Line 1659: FROM CSD_INCIDENTS_V a, CSD_REPAIRS b, CS_INCIDENTS_B_SEC c

1655: b.contract_line_id,
1656: b.flow_status_id,
1657: b.resource_id,
1658: b.ro_priority_code
1659: FROM CSD_INCIDENTS_V a, CSD_REPAIRS b, CS_INCIDENTS_B_SEC c
1660: WHERE a.incident_id = b.incident_id
1661: AND a.incident_id = c.incident_id
1662: AND b.repair_line_Id = p_repair_line_id;
1663:

Line 2027: FROM csd_repairs

2023:
2024: ---- cursors ----
2025: CURSOR cur_get_promise_date(p_repair_line_id NUMBER) IS
2026: SELECT promise_date
2027: FROM csd_repairs
2028: WHERE repair_line_id = p_repair_line_id
2029: ; --* end CURSOR get_promise_date *--
2030: BEGIN
2031: IF (p_repair_line_id IS NOT NULL) THEN

Line 2080: FROM csd_repairs

2076: l_date_field DATE := NULL;
2077: ---- cursors ----
2078: CURSOR cur_get_resolve_by_date(p_repair_line_id NUMBER) IS
2079: SELECT resolve_by_date
2080: FROM csd_repairs
2081: WHERE repair_line_id = p_repair_line_id
2082: ; --* end CURSOR get_resolve_by_date *--
2083:
2084: BEGIN

Line 2214: FROM csd_repairs a

2210: ---- cursors ----
2211: -- need to redo this query based on ship date, could return
2212: CURSOR cur_get_latest_repair_date(p_instance_id NUMBER) IS
2213: SELECT MAX(a.date_closed)
2214: FROM csd_repairs a
2215: WHERE a.customer_product_id = p_instance_id
2216: AND a.date_closed IS NOT NULL
2217: ; --* end cur_get_latest_repair_date *--
2218:

Line 2221: FROM csd_repairs

2217: ; --* end cur_get_latest_repair_date *--
2218:
2219: CURSOR cur_get_creation_date(p_repair_line_id NUMBER) IS
2220: SELECT creation_date
2221: FROM csd_repairs
2222: WHERE repair_line_id = p_repair_line_id
2223: ; -- end* cur_get_creation_date*--
2224: BEGIN
2225: IF (p_repair_Line_id IS NOT NULL) THEN

Line 2293: FROM csd_repairs a

2289: -- need to redo this query based on ship date
2290: CURSOR cur_get_chronic_repairs(p_instance_id NUMBER,
2291: p_period NUMBER) IS
2292: SELECT count(a.repair_line_id)
2293: FROM csd_repairs a
2294: WHERE a.customer_product_id = p_instance_id
2295: AND a.date_closed BETWEEN sysdate - p_period
2296: AND sysdate
2297: ; --* end cur_get_chronic_repairs *--

Line 2360: FROM csd_repairs

2356:
2357: ---- cursors ----
2358: CURSOR cur_get_ro_contract_id(p_repair_line_id NUMBER) IS
2359: SELECT contract_line_id
2360: FROM csd_repairs
2361: WHERE repair_line_id = p_repair_line_id
2362: ; --* end cur_get_ro_contract_id *--
2363:
2364: -- bug 7323831 - contract line can expire if either end date or termination date

Line 2434: FROM csd_repairs

2430: l_instance_id NUMBER := NULL;
2431: ---- cursors ----
2432: CURSOR cur_get_instance_id(p_repair_line_id NUMBER) IS
2433: SELECT customer_product_id
2434: FROM csd_repairs
2435: WHERE repair_line_id = p_repair_line_id
2436: ;--* end cur_get_instance_id *--
2437: BEGIN
2438: IF (p_repair_Line_id IS NOT NULL) THEN

Line 2508: l_sql_query := 'select dra.repair_line_id from csd_repairs dra, cs_incidents_b_sec csb '

2504: l_str_condition VARCHAR2(3000); -- for conditions that match a string type
2505: l_condition_count NUMBER :=0;
2506:
2507: BEGIN
2508: l_sql_query := 'select dra.repair_line_id from csd_repairs dra, cs_incidents_b_sec csb '
2509: || 'where csb.incident_id = dra.incident_id';
2510: OPEN c_rule_conditions(p_rule_id);
2511: LOOP
2512: FETCH c_rule_conditions into l_rule_condition_rec;

Line 2624: || ' FROM csd_repairs dra2 '

2620: || l_num_condition || ')';
2621: -- end swai: bug 7524870
2622: when 'RO_REPEAT_REPAIR_THRESHOLD' then
2623: l_join_stmt := 'sysdate - ( SELECT MAX(dra2.date_closed)'
2624: || ' FROM csd_repairs dra2 '
2625: || ' WHERE dra2.customer_product_id = dra.customer_product_id '
2626: || ' AND dra2.date_closed IS NOT NULL) '
2627: || l_num_condition;
2628: when 'RO_CHRONIC_REPAIR_THRESHOLD' then

Line 2630: || ' FROM csd_repairs dra2 '

2626: || ' AND dra2.date_closed IS NOT NULL) '
2627: || l_num_condition;
2628: when 'RO_CHRONIC_REPAIR_THRESHOLD' then
2629: l_join_stmt := '(SELECT count(dra2.repair_line_id) '
2630: || ' FROM csd_repairs dra2 '
2631: || ' WHERE dra2.customer_product_id = dra.customer_product_id '
2632: || ' AND dra2.date_closed BETWEEN sysdate - '
2633: || ' nvl(FND_PROFILE.VALUE(''CSD_QUALITY_CHECK_PERIOD''), 0) '
2634: || ' AND sysdate) ' || l_num_condition;