APPS.GME_CREATE_STEP_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 7: TYPE gme_batch_step_resources_tab IS TABLE OF gme_batch_step_resources%ROWTYPE;

3: TYPE gme_batch_steps_tab IS TABLE OF gme_batch_steps%ROWTYPE;
4:
5: TYPE gme_batch_step_activities_tab IS TABLE OF gme_batch_step_activities%ROWTYPE;
6:
7: TYPE gme_batch_step_resources_tab IS TABLE OF gme_batch_step_resources%ROWTYPE;
8:
9: TYPE gme_batch_step_dep_tab IS TABLE OF gme_batch_step_dependencies%ROWTYPE;
10:
11: TYPE gme_batch_step_items_tab IS TABLE OF gme_batch_step_items%ROWTYPE;

Line 26: TYPE resources_tab IS TABLE OF gme_batch_step_resources%ROWTYPE

22:
23: TYPE activities_tab IS TABLE OF gme_batch_step_activities%ROWTYPE
24: INDEX BY BINARY_INTEGER;
25:
26: TYPE resources_tab IS TABLE OF gme_batch_step_resources%ROWTYPE
27: INDEX BY BINARY_INTEGER;
28:
29: TYPE rsrc_txns_tab IS TABLE OF gme_resource_txns%ROWTYPE
30: INDEX BY BINARY_INTEGER;

Line 41: resources gme_batch_step_resources.resources%TYPE

37: TYPE charge_tab IS TABLE OF step_charge_rec
38: INDEX BY BINARY_INTEGER;
39:
40: TYPE step_charge_rsrc_rec IS RECORD (
41: resources gme_batch_step_resources.resources%TYPE
42: );
43:
44: TYPE step_charge_rsrc_tab IS TABLE OF step_charge_rsrc_rec
45: INDEX BY BINARY_INTEGER;

Line 99: p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE

95: ,x_batch_duration OUT NOCOPY NUMBER
96: ,x_return_status OUT NOCOPY VARCHAR2);
97:
98: PROCEDURE get_usage_in_hours (
99: p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE
100: ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE
101: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
102: ,x_return_status OUT NOCOPY VARCHAR2);
103:

Line 100: ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE

96: ,x_return_status OUT NOCOPY VARCHAR2);
97:
98: PROCEDURE get_usage_in_hours (
99: p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE
100: ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE
101: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
102: ,x_return_status OUT NOCOPY VARCHAR2);
103:
104: FUNCTION get_max_duration (v_step_id IN NUMBER, v_batch_id IN NUMBER)

Line 101: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE

97:
98: PROCEDURE get_usage_in_hours (
99: p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE
100: ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE
101: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
102: ,x_return_status OUT NOCOPY VARCHAR2);
103:
104: FUNCTION get_max_duration (v_step_id IN NUMBER, v_batch_id IN NUMBER)
105: RETURN NUMBER;

Line 111: ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE

107: -- Bug 9212573 - add parameter p_trans_count.
108: PROCEDURE insert_resource_txns (
109: p_gme_batch_header_rec IN gme_batch_header%ROWTYPE
110: ,p_doc_type IN VARCHAR2
111: ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
112: ,p_trans_count IN NUMBER
113: ,x_return_status OUT NOCOPY VARCHAR2);
114:
115: FUNCTION get_max_step_date (