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 381: FROM cr_rsrc_dtl

377:
378: /* B4724360 Rajesh Patangya changed the where clause include org+id and resource_id*/
379: CURSOR Cur_check_dup IS
380: SELECT COUNT(1)
381: FROM cr_rsrc_dtl
382: WHERE organization_id = p_organization_id
383: AND resource_id = p_resource_id;
384:
385: /* B4724360 - INVCONV */

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

732: /* */
733: /* DESCRIPTION: */
734: /* */
735: /* The following Procedure checks the Record and then Inserts */
736: /* the row into cr_rsrc_dtl table and Returns S code if inserted */
737: /* Successfully */
738: /* */
739: /* History : */
740: /* Sgidugu 09/10/2002 Initial implementation */

Line 780: INSERT INTO CR_RSRC_DTL(

776: ) IS
777:
778: BEGIN
779:
780: INSERT INTO CR_RSRC_DTL(
781: ORGANIZATION_ID /* B4724360 - INVCONV */
782: ,RESOURCES
783: ,GROUP_RESOURCE
784: ,ASSIGNED_QTY

Line 960: , p_resources IN cr_rsrc_dtl%ROWTYPE

956: PROCEDURE update_resource_dtl
957: ( p_api_version IN NUMBER := 1
958: , p_init_msg_list IN BOOLEAN := TRUE
959: , p_commit IN BOOLEAN := FALSE
960: , p_resources IN cr_rsrc_dtl%ROWTYPE
961: , x_message_count OUT NOCOPY NUMBER
962: , x_message_list OUT NOCOPY VARCHAR2
963: , x_return_status OUT NOCOPY VARCHAR2
964: ) IS

Line 1191: UPDATE cr_rsrc_dtl

1187:
1188: BEGIN
1189:
1190: IF p_schedule_ind = 2 THEN
1191: UPDATE cr_rsrc_dtl
1192: SET group_resource = p_group_resource,
1193: daily_avail_use = p_daily_avail_use,
1194: usage_uom = p_usage_um, /* B4724360 - INVCONV */
1195: nominal_cost = p_nominal_cost,

Line 1219: UPDATE cr_rsrc_dtl

1215: batch_window = p_batch_window /* BUG 4157063 */
1216: WHERE resource_id = p_resource_id
1217: AND organization_id = p_organization_id;
1218: ELSE
1219: UPDATE cr_rsrc_dtl
1220: SET group_resource = p_group_resource,
1221: assigned_qty = p_assigned_qty,
1222: daily_avail_use = p_daily_avail_use,
1223: usage_uom = p_usage_um, /* B4724360 - INVCONV */

Line 1547: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE

1543: PROCEDURE delete_resources
1544: ( p_api_version IN NUMBER := 1
1545: , p_init_msg_list IN BOOLEAN := TRUE
1546: , p_commit IN BOOLEAN := FALSE
1547: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE
1548: , p_resources IN cr_rsrc_dtl.resources%TYPE
1549: , x_message_count OUT NOCOPY NUMBER
1550: , x_message_list OUT NOCOPY VARCHAR2
1551: , x_return_status OUT NOCOPY VARCHAR2

Line 1548: , p_resources IN cr_rsrc_dtl.resources%TYPE

1544: ( p_api_version IN NUMBER := 1
1545: , p_init_msg_list IN BOOLEAN := TRUE
1546: , p_commit IN BOOLEAN := FALSE
1547: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE
1548: , p_resources IN cr_rsrc_dtl.resources%TYPE
1549: , x_message_count OUT NOCOPY NUMBER
1550: , x_message_list OUT NOCOPY VARCHAR2
1551: , x_return_status OUT NOCOPY VARCHAR2
1552: ) IS

Line 1567: FROM cr_rsrc_dtl

1563:
1564:
1565: CURSOR Cur_resource_id IS
1566: SELECT resource_id
1567: FROM cr_rsrc_dtl
1568: WHERE organization_id = p_organization_id
1569: AND resources = p_resources;
1570:
1571: BEGIN

Line 1628: delete from cr_rsrc_dtl

1624: and organization_id = p_organization_id
1625: and RESOURCE_INSTANCE_ID IS NOT NULL ;
1626:
1627: -- Resource details
1628: delete from cr_rsrc_dtl
1629: where resource_id = v_resource_id
1630: and organization_id = p_organization_id;
1631:
1632: END IF;