DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_ORDER_GROUPS

Line 7356: FROM csd_repair_order_groups crog, csd_repair_types_vl crt

7352: CURSOR get_rep_group(p_incident_id IN NUMBER) IS
7353: SELECT crog.repair_group_id,
7354: crt.repair_type_ref,
7355: crog.group_txn_status
7356: FROM csd_repair_order_groups crog, csd_repair_types_vl crt
7357: WHERE crog.repair_type_id = crt.repair_type_id
7358: AND crog.incident_id = p_incident_id;
7359:
7360: CURSOR get_ro_order(p_repair_group_id IN NUMBER) IS

Line 7495: FROM csd_repair_order_groups

7491:
7492: BEGIN
7493: SELECT object_version_number
7494: INTO l_grp_obj_version_number
7495: FROM csd_repair_order_groups
7496: WHERE repair_group_id = grp.repair_group_id;
7497: EXCEPTION
7498: WHEN OTHERS THEN
7499: RAISE Fnd_Api.G_EXC_ERROR;

Line 7589: FROM csd_repair_order_groups

7585:
7586: BEGIN
7587: SELECT object_version_number
7588: INTO l_grp_obj_version_number
7589: FROM csd_repair_order_groups
7590: WHERE repair_group_id = grp.repair_group_id;
7591: EXCEPTION
7592: WHEN OTHERS THEN
7593: RAISE Fnd_Api.G_EXC_ERROR;

Line 7835: FROM csd_repair_order_groups

7831:
7832: BEGIN
7833: SELECT object_version_number
7834: INTO l_grp_obj_version_number
7835: FROM csd_repair_order_groups
7836: WHERE repair_group_id = l_repair_group_id;
7837: EXCEPTION
7838: WHEN OTHERS THEN
7839: RAISE Fnd_Api.G_EXC_ERROR;