APPS.CSD_HV_WIP_JOB_PVT dependencies on CSD_REPAIRS

Line 6349: from csd_repairs

6345:
6346: CURSOR c_repair_line_info(p_repair_line_id IN NUMBER) IS
6347: select inventory_item_id, unit_of_measure, quantity, serial_number
6348: -- , inventory_org_id -- swai: bug 9954780
6349: from csd_repairs
6350: where repair_line_id = p_repair_line_id;
6351:
6352: --bug#13472453
6353: CURSOR c_repair_project_info(p_repair_line_id IN NUMBER) IS

Line 6355: from csd_repairs

6351:
6352: --bug#13472453
6353: CURSOR c_repair_project_info(p_repair_line_id IN NUMBER) IS
6354: select project_id, task_id, unit_number
6355: from csd_repairs
6356: where repair_line_id = p_repair_line_id;
6357:
6358: l_org_id NUMBER;
6359: --bug#13472453

Line 7159: from csd_repairs

7155:
7156: CURSOR c_repair_line_info(p_repair_line_id IN NUMBER) IS
7157: select inventory_item_id, unit_of_measure, quantity, serial_number
7158: --, inventory_org_id -- swai: bug 10137471
7159: from csd_repairs
7160: where repair_line_id = p_repair_line_id;
7161:
7162: --bug#13472453
7163: CURSOR c_repair_project_info(p_repair_line_id IN NUMBER) IS

Line 7165: from csd_repairs

7161:
7162: --bug#13472453
7163: CURSOR c_repair_project_info(p_repair_line_id IN NUMBER) IS
7164: select project_id, task_id, unit_number
7165: from csd_repairs
7166: where repair_line_id = p_repair_line_id;
7167:
7168: l_org_id NUMBER;
7169: --bug#13472453

Line 8992: from csd_repairs

8988: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_comp_work_ro_status';
8989:
8990: cursor c_get_repair_info is
8991: select repair_type_id, flow_status_id, object_version_number
8992: from csd_repairs
8993: where repair_line_id = p_repair_line_id;
8994:
8995: cursor c_get_to_flow_status_id is
8996: select flow_status_id

Line 9002: from csd_repairs dra, csd_flow_statuses_b flb

8998: where flow_status_code = fnd_profile.value('CSD_COMPLETE_WORK_RO_STATUS');
8999:
9000: cursor c_get_repair_status is
9001: select flb.flow_status_code, dra.status
9002: from csd_repairs dra, csd_flow_statuses_b flb
9003: where dra.repair_line_id = p_repair_line_id
9004: and dra.flow_status_id = flb.flow_status_id;
9005:
9006: --

Line 9051: csd_repairs_pvt.update_flow_status

9047: into l_to_flow_status_id;
9048: close c_get_to_flow_status_id;
9049:
9050:
9051: csd_repairs_pvt.update_flow_status
9052: (
9053: p_api_version => p_api_version_number,
9054: p_commit => p_commit,
9055: p_init_msg_list => p_init_msg_list,

Line 9436: from csd_repair_job_xref xref, csd_repairs csd

9432: ) RETURN VARCHAR2
9433: IS
9434: cursor c_get_ro_status is
9435: select csd.status
9436: from csd_repair_job_xref xref, csd_repairs csd
9437: where xref.wip_entity_id = p_wip_entity_id
9438: and xref.repair_line_id = csd.repair_line_id;
9439:
9440: cursor c_time_clock_entries_exist is

Line 10392: from csd_repairs dra, csd_repair_types_b rt

10388: into l_repair_type_id,
10389: l_business_process_id,
10390: l_currency_code,
10391: l_incident_id
10392: from csd_repairs dra, csd_repair_types_b rt
10393: where rt.repair_type_id = dra.repair_type_id
10394: and repair_line_id = p_repair_line_id;
10395:
10396: l_organization_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');