DBA Data[Home] [Help]

APPS.GMP_RESOURCES_PUB dependencies on CR_RSRC_MST

Line 18: TYPE gmp_resources_tab IS TABLE OF cr_rsrc_mst%ROWTYPE

14: m_api_version CONSTANT NUMBER := 1;
15: m_pkg_name CONSTANT VARCHAR2 (30) := 'GMP_RESOURCES_PUB';
16: v_insert_flag varchar2(1) := '';
17:
18: TYPE gmp_resources_tab IS TABLE OF cr_rsrc_mst%ROWTYPE
19: INDEX BY BINARY_INTEGER;
20:
21: TYPE gmp_resources_dtl_tab IS TABLE OF cr_rsrc_dtl%ROWTYPE
22: INDEX BY BINARY_INTEGER;

Line 38: * input after validating it. It inserts a row in Resource table cr_rsrc_mst

34:
35: /*#
36: * API for INSERT_RESOURCES
37: * This API creates a generic resource based on the data provided as
38: * input after validating it. It inserts a row in Resource table cr_rsrc_mst
39: * @param p_api_version Version Number of the API
40: * @param p_init_msg_list Flag for initializing message list BOOLEAN
41: * @param p_commit This is the commmit flag BOOLEAN.
42: * @param p_resources This is the resource information is prescribed format

Line 56: , p_resources IN cr_rsrc_mst%ROWTYPE

52: PROCEDURE insert_resources
53: ( p_api_version IN NUMBER := 1
54: , p_init_msg_list IN BOOLEAN := TRUE
55: , p_commit IN BOOLEAN := FALSE
56: , p_resources IN cr_rsrc_mst%ROWTYPE
57: , x_message_count OUT NOCOPY NUMBER
58: , x_message_list OUT NOCOPY VARCHAR2
59: , x_return_status IN OUT NOCOPY VARCHAR2
60: );

Line 122: , p_resources IN cr_rsrc_mst%ROWTYPE

118: PROCEDURE update_resources
119: ( p_api_version IN NUMBER := 1
120: , p_init_msg_list IN BOOLEAN := TRUE
121: , p_commit IN BOOLEAN := FALSE
122: , p_resources IN cr_rsrc_mst%ROWTYPE
123: , x_message_count OUT NOCOPY NUMBER
124: , x_message_list OUT NOCOPY VARCHAR2
125: , x_return_status OUT NOCOPY VARCHAR2
126: );

Line 147: , p_resources IN cr_rsrc_mst.resources%TYPE := NULL

143: PROCEDURE delete_resources
144: ( p_api_version IN NUMBER := 1
145: , p_init_msg_list IN BOOLEAN := TRUE
146: , p_commit IN BOOLEAN := FALSE
147: , p_resources IN cr_rsrc_mst.resources%TYPE := NULL
148: , x_message_count OUT NOCOPY NUMBER
149: , x_message_list OUT NOCOPY VARCHAR2
150: , x_return_status OUT NOCOPY VARCHAR2
151: );