APPS.CSD_REPAIR_GROUPS_PVT dependencies on CSD_REPAIR_ORDER_GROUPS

Line 38: SELECT CSD_REPAIR_ORDER_GROUPS_S1.NEXTVAL

34: l_repair_group_number VARCHAR2(30);
35: l_count NUMBER;
36:
37: CURSOR C1 IS
38: SELECT CSD_REPAIR_ORDER_GROUPS_S1.NEXTVAL
39: FROM sys.dual;
40:
41:
42: BEGIN

Line 235: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row');

231:
232: x_repair_order_group_rec.object_version_number := 1;
233:
234: IF (g_debug > 0 ) THEN
235: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row');
236: END IF;
237:
238:
239: CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row

Line 239: CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row

235: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row');
236: END IF;
237:
238:
239: CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row
240: (px_REPAIR_GROUP_ID => l_repair_group_id,
241: p_INCIDENT_ID => x_repair_order_group_rec.incident_id,
242: p_REPAIR_GROUP_NUMBER => l_repair_group_number,
243: p_REPAIR_TYPE_ID => x_repair_order_group_rec.repair_type_id,

Line 373: FROM csd_repair_order_groups

369: CURSOR repair_order_group(p_repair_group_id IN NUMBER) IS
370: SELECT
371: repair_group_id,
372: object_version_number
373: FROM csd_repair_order_groups
374: WHERE repair_group_id = p_repair_group_id;
375:
376: BEGIN
377:

Line 540: from csd_repair_order_groups

536: l_inventory_item_id,
537: l_repair_type_id,
538: l_unit_of_measure,
539: l_group_quantity
540: from csd_repair_order_groups
541: where repair_group_id = x_repair_order_group_rec.repair_group_id;
542: END;
543: ------------------------------------------------
544: -- Update of item id, repair type,uom,grp qty

Line 571: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row');

567: -------------------
568: -- Update Call
569: -------------------
570: IF (g_debug > 0 ) THEN
571: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row');
572: END IF;
573:
574:
575: CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row(

Line 575: CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row(

571: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row');
572: END IF;
573:
574:
575: CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row(
576: p_REPAIR_GROUP_ID => x_repair_order_group_rec.repair_group_id,
577: p_INCIDENT_ID => x_repair_order_group_rec.incident_id,
578: p_REPAIR_GROUP_NUMBER => x_repair_order_group_rec.repair_group_number,
579: p_REPAIR_TYPE_ID => x_repair_order_group_rec.repair_type_id,

Line 788: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row');

784: -----------------------------
785: -- Calling the Delete api
786: -----------------------------
787: IF (g_debug > 0 ) THEN
788: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row');
789: END IF;
790:
791:
792: CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row

Line 792: CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row

788: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row');
789: END IF;
790:
791:
792: CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row
793: ( p_REPAIR_GROUP_ID => p_repair_group_id);
794:
795: -------------------------------
796: -- Standard check for p_commit

Line 901: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row ');

897: ----------------------------
898: -- Calling Lock Row
899: ----------------------------
900: IF (g_debug > 0 ) THEN
901: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row ');
902: END IF;
903:
904:
905: CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row(

Line 905: CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row(

901: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row ');
902: END IF;
903:
904:
905: CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row(
906: p_REPAIR_GROUP_ID => p_repair_order_group_rec.repair_group_id,
907: p_OBJECT_VERSION_NUMBER => p_repair_order_group_rec.object_version_number);
908:
909: --------------------------------

Line 1178: from csd_repair_order_groups_v

1174: select object_version_number,
1175: group_quantity
1176: into l_group_object_version_number,
1177: l_group_quantity
1178: from csd_repair_order_groups_v
1179: where repair_group_id = p_repair_group_id;
1180:
1181: Exception
1182: when others then