APPS.GMP_RESOURCE_DTL_PUB dependencies on CR_RSRC_DTL

Line 20: , p_resources IN cr_rsrc_dtl%ROWTYPE

16: PROCEDURE insert_resource_dtl
17: ( p_api_version IN NUMBER := 1
18: , p_init_msg_list IN BOOLEAN := TRUE
19: , p_commit IN BOOLEAN := FALSE
20: , p_resources IN cr_rsrc_dtl%ROWTYPE
21: , p_rsrc_instances IN resource_instances_tbl
22: , x_message_count OUT NOCOPY NUMBER
23: , x_message_list OUT NOCOPY VARCHAR2
24: , x_return_status IN OUT NOCOPY VARCHAR2

Line 38: l_resources_rec cr_rsrc_dtl%ROWTYPE;

34: v_std_usage_uom VARCHAR2(4);
35: v_capacity_uom VARCHAR2(4);
36: v_min_capacity NUMBER;
37: v_max_capacity NUMBER;
38: l_resources_rec cr_rsrc_dtl%ROWTYPE;
39: l_rsrc_instances resource_instances_tbl;
40:
41: /* Define Exceptions */
42: resource_dtl_creation_failure EXCEPTION;

Line 382: FROM cr_rsrc_dtl

378:
379: /* B4724360 Rajesh Patangya changed the where clause include org+id and resource_id*/
380: CURSOR Cur_check_dup IS
381: SELECT COUNT(1)
382: FROM cr_rsrc_dtl
383: WHERE organization_id = p_organization_id
384: AND resource_id = p_resource_id;
385:
386: /* Bug 13588606 - TST122:ABLE TO CREATE DUPLICATE PLANT RESOURCE USING GMP_RESOURCE_DTL_PUB API */

Line 389: FROM cr_rsrc_dtl

385:
386: /* Bug 13588606 - TST122:ABLE TO CREATE DUPLICATE PLANT RESOURCE USING GMP_RESOURCE_DTL_PUB API */
387: CURSOR Cur_check_dup_rsc IS
388: SELECT COUNT(1)
389: FROM cr_rsrc_dtl
390: WHERE organization_id = p_organization_id
391: AND resources = p_resources;
392:
393: /* B4724360 - INVCONV */

Line 755: /* the row into cr_rsrc_dtl table and Returns S code if inserted */

751: /* */
752: /* DESCRIPTION: */
753: /* */
754: /* The following Procedure checks the Record and then Inserts */
755: /* the row into cr_rsrc_dtl table and Returns S code if inserted */
756: /* Successfully */
757: /* */
758: /* History : */
759: /* Sgidugu 09/10/2002 Initial implementation */

Line 800: INSERT INTO CR_RSRC_DTL(

796: ) IS
797:
798: BEGIN
799:
800: INSERT INTO CR_RSRC_DTL(
801: ORGANIZATION_ID /* B4724360 - INVCONV */
802: ,RESOURCES
803: ,GROUP_RESOURCE
804: ,ASSIGNED_QTY

Line 876: /* the row into cr_rsrc_dtl table and Returns S code if inserted */

872: /* */
873: /* DESCRIPTION: */
874: /* */
875: /* The following Procedure checks the Record and then Inserts */
876: /* the row into cr_rsrc_dtl table and Returns S code if inserted */
877: /* Successfully */
878: /* */
879: /* History : */
880: /* Sgidugu 09/10/2002 Initial implementation */

Line 982: , p_resources IN cr_rsrc_dtl%ROWTYPE

978: PROCEDURE update_resource_dtl
979: ( p_api_version IN NUMBER := 1
980: , p_init_msg_list IN BOOLEAN := TRUE
981: , p_commit IN BOOLEAN := FALSE
982: , p_resources IN cr_rsrc_dtl%ROWTYPE
983: , x_message_count OUT NOCOPY NUMBER
984: , x_message_list OUT NOCOPY VARCHAR2
985: , x_return_status OUT NOCOPY VARCHAR2
986: ) IS

Line 1216: UPDATE cr_rsrc_dtl

1212:
1213: BEGIN
1214:
1215: IF p_schedule_ind = 2 THEN
1216: UPDATE cr_rsrc_dtl
1217: SET group_resource = p_group_resource,
1218: daily_avail_use = p_daily_avail_use,
1219: usage_uom = p_usage_um, /* B4724360 - INVCONV */
1220: nominal_cost = p_nominal_cost,

Line 1245: UPDATE cr_rsrc_dtl

1241: batch_window = p_batch_window /* BUG 4157063 */
1242: WHERE resource_id = p_resource_id
1243: AND organization_id = p_organization_id;
1244: ELSE
1245: UPDATE cr_rsrc_dtl
1246: SET group_resource = p_group_resource,
1247: assigned_qty = p_assigned_qty,
1248: daily_avail_use = p_daily_avail_use,
1249: usage_uom = p_usage_um, /* B4724360 - INVCONV */

Line 1574: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE

1570: PROCEDURE delete_resources
1571: ( p_api_version IN NUMBER := 1
1572: , p_init_msg_list IN BOOLEAN := TRUE
1573: , p_commit IN BOOLEAN := FALSE
1574: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE
1575: , p_resources IN cr_rsrc_dtl.resources%TYPE
1576: , x_message_count OUT NOCOPY NUMBER
1577: , x_message_list OUT NOCOPY VARCHAR2
1578: , x_return_status OUT NOCOPY VARCHAR2

Line 1575: , p_resources IN cr_rsrc_dtl.resources%TYPE

1571: ( p_api_version IN NUMBER := 1
1572: , p_init_msg_list IN BOOLEAN := TRUE
1573: , p_commit IN BOOLEAN := FALSE
1574: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE
1575: , p_resources IN cr_rsrc_dtl.resources%TYPE
1576: , x_message_count OUT NOCOPY NUMBER
1577: , x_message_list OUT NOCOPY VARCHAR2
1578: , x_return_status OUT NOCOPY VARCHAR2
1579: ) IS

Line 1594: FROM cr_rsrc_dtl

1590:
1591:
1592: CURSOR Cur_resource_id IS
1593: SELECT resource_id
1594: FROM cr_rsrc_dtl
1595: WHERE organization_id = p_organization_id
1596: AND resources = p_resources;
1597:
1598: BEGIN

Line 1655: delete from cr_rsrc_dtl

1651: and organization_id = p_organization_id
1652: and RESOURCE_INSTANCE_ID IS NOT NULL ;
1653:
1654: -- Resource details
1655: delete from cr_rsrc_dtl
1656: where resource_id = v_resource_id
1657: and organization_id = p_organization_id;
1658:
1659: END IF;