APPS.GMP_RESOURCES_PUB dependencies on CR_RSRC_MST

Line 11: /* header (cr_rsrc_mst ) table is successfully. */

7: /* */
8: /* DESCRIPTION: */
9: /* */
10: /* API returns (x_return_code) = 'S' if the insert into resources */
11: /* header (cr_rsrc_mst ) table is successfully. */
12: /* */
13: /* History : */
14: /* Sridhar 03-SEP-2002 Initial implementation */
15: /* =============================================================== */

Line 20: , p_resources IN cr_rsrc_mst%ROWTYPE

16: PROCEDURE insert_resources
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_mst%ROWTYPE
21: , x_message_count OUT NOCOPY NUMBER
22: , x_message_list OUT NOCOPY VARCHAR2
23: , x_return_status IN OUT NOCOPY VARCHAR2
24: ) IS

Line 33: l_resources_rec cr_rsrc_mst%ROWTYPE;

29: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
30:
31:
32: /* get a record type */
33: l_resources_rec cr_rsrc_mst%ROWTYPE;
34:
35: /* Define Exceptions */
36: resource_creation_failure EXCEPTION;
37: RESOURCE_REQUIRED EXCEPTION;

Line 101: CR_RSRC_MST_PKG.insert_row

97: IF l_resources_rec.capacity_constraint = 0 THEN
98: l_resources_rec.capacity_tolerance := NULL;
99: END IF;
100: --
101: CR_RSRC_MST_PKG.insert_row
102: ( l_row_id,
103: l_resources_rec.resources,
104: l_resources_rec.resource_class,
105: l_resources_rec.trans_cnt,

Line 185: /* the row into cr_rsrc_mst table and Returns S code if inserted */

181: /* */
182: /* DESCRIPTION: */
183: /* */
184: /* The following Procedure checks the Record and then Inserts */
185: /* the row into cr_rsrc_mst table and Returns S code if inserted */
186: /* Successfully */
187: /* */
188: /* History : */
189: /* Sgidugu 09/03/2002 Initial implementation */

Line 206: FROM cr_rsrc_mst

202: x_message_list OUT NOCOPY VARCHAR2,
203: x_return_status OUT NOCOPY VARCHAR2) IS
204: CURSOR Cur_resources IS
205: SELECT COUNT(1)
206: FROM cr_rsrc_mst
207: where resources = p_resources
208: and delete_mark = 0;
209:
210: CURSOR Cur_std_usage_um IS

Line 452: , p_resources IN cr_rsrc_mst%ROWTYPE

448: PROCEDURE update_resources
449: ( p_api_version IN NUMBER := 1
450: , p_init_msg_list IN BOOLEAN := TRUE
451: , p_commit IN BOOLEAN := FALSE
452: , p_resources IN cr_rsrc_mst%ROWTYPE
453: , x_message_count OUT NOCOPY NUMBER
454: , x_message_list OUT NOCOPY VARCHAR2
455: , x_return_status OUT NOCOPY VARCHAR2
456: ) IS

Line 512: CR_RSRC_MST_PKG.update_row(

508: FND_MSG_PUB.ADD;
509: RAISE resource_update_failure;
510: ELSE
511: /* Update the Resource Data now */
512: CR_RSRC_MST_PKG.update_row(
513: p_resources.resources,
514: p_resources.resource_class,
515: p_resources.trans_cnt,
516: NVL(p_resources.delete_mark,0),

Line 592: , p_resources IN cr_rsrc_mst.resources%TYPE

588: PROCEDURE delete_resources
589: ( p_api_version IN NUMBER := 1
590: , p_init_msg_list IN BOOLEAN := TRUE
591: , p_commit IN BOOLEAN := FALSE
592: , p_resources IN cr_rsrc_mst.resources%TYPE
593: , x_message_count OUT NOCOPY NUMBER
594: , x_message_list OUT NOCOPY VARCHAR2
595: , x_return_status OUT NOCOPY VARCHAR2
596: ) IS

Line 599: FROM cr_rsrc_mst

595: , x_return_status OUT NOCOPY VARCHAR2
596: ) IS
597: CURSOR Cur_resources IS
598: SELECT count(1)
599: FROM cr_rsrc_mst
600: where resources = p_resources;
601:
602: l_counter number;
603:

Line 642: delete from cr_rsrc_mst_tl

638: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');
639: FND_MSG_PUB.ADD;
640: RAISE resource_delete_failure;
641: ELSE
642: delete from cr_rsrc_mst_tl
643: where resources = p_resources;
644: --
645: delete from cr_rsrc_mst_b
646: where resources = p_resources;

Line 645: delete from cr_rsrc_mst_b

641: ELSE
642: delete from cr_rsrc_mst_tl
643: where resources = p_resources;
644: --
645: delete from cr_rsrc_mst_b
646: where resources = p_resources;
647: l_return_status := 'S';
648: END IF;
649: --