DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_ORDER_GROUPS

Line 7201: FROM csd_repair_order_groups crog, csd_repair_types_vl crt

7197: CURSOR get_rep_group(p_incident_id IN NUMBER) IS
7198: SELECT crog.repair_group_id,
7199: crt.repair_type_ref,
7200: crog.group_txn_status
7201: FROM csd_repair_order_groups crog, csd_repair_types_vl crt
7202: WHERE crog.repair_type_id = crt.repair_type_id
7203: AND crog.incident_id = p_incident_id;
7204:
7205: CURSOR get_ro_order(p_repair_group_id IN NUMBER) IS

Line 7340: FROM csd_repair_order_groups

7336:
7337: BEGIN
7338: SELECT object_version_number
7339: INTO l_grp_obj_version_number
7340: FROM csd_repair_order_groups
7341: WHERE repair_group_id = grp.repair_group_id;
7342: EXCEPTION
7343: WHEN OTHERS THEN
7344: RAISE Fnd_Api.G_EXC_ERROR;

Line 7434: FROM csd_repair_order_groups

7430:
7431: BEGIN
7432: SELECT object_version_number
7433: INTO l_grp_obj_version_number
7434: FROM csd_repair_order_groups
7435: WHERE repair_group_id = grp.repair_group_id;
7436: EXCEPTION
7437: WHEN OTHERS THEN
7438: RAISE Fnd_Api.G_EXC_ERROR;

Line 7680: FROM csd_repair_order_groups

7676:
7677: BEGIN
7678: SELECT object_version_number
7679: INTO l_grp_obj_version_number
7680: FROM csd_repair_order_groups
7681: WHERE repair_group_id = l_repair_group_id;
7682: EXCEPTION
7683: WHEN OTHERS THEN
7684: RAISE Fnd_Api.G_EXC_ERROR;