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 97: p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE

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

Line 98: ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE

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

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

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

Line 108: ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE

104:
105: PROCEDURE insert_resource_txns (
106: p_gme_batch_header_rec IN gme_batch_header%ROWTYPE
107: ,p_doc_type IN VARCHAR2
108: ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
109: ,x_return_status OUT NOCOPY VARCHAR2);
110:
111: FUNCTION get_max_step_date (
112: p_use_workday_cal IN VARCHAR2