eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_AC_OPS dependencies on ZPB_ANALYSIS_CYCLES

Line 5: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1: PACKAGE zpb_ac_ops AS
2: /* $Header: zpbac.pls 120.9 2007/12/05 12:45:25 mbhat ship $ */
3:
4: PROCEDURE create_editable_copy (
5: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
6: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
7: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
8: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
9:

Line 6: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,

2: /* $Header: zpbac.pls 120.9 2007/12/05 12:45:25 mbhat ship $ */
3:
4: PROCEDURE create_editable_copy (
5: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
6: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
7: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
8: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
9:
10: PROCEDURE create_duplicate_copy (

Line 7: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,

3:
4: PROCEDURE create_editable_copy (
5: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
6: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
7: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
8: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
9:
10: PROCEDURE create_duplicate_copy (
11: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 8: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

4: PROCEDURE create_editable_copy (
5: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
6: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
7: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
8: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
9:
10: PROCEDURE create_duplicate_copy (
11: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
12: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,

Line 11: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

7: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
8: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
9:
10: PROCEDURE create_duplicate_copy (
11: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
12: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
13: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
14: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
15: is_comments_copied IN VARCHAR2 default 'true',

Line 12: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,

8: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
9:
10: PROCEDURE create_duplicate_copy (
11: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
12: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
13: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
14: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
15: is_comments_copied IN VARCHAR2 default 'true',
16: is_analy_excep_copied IN VARCHAR2 default 'true',

Line 13: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,

9:
10: PROCEDURE create_duplicate_copy (
11: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
12: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
13: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
14: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
15: is_comments_copied IN VARCHAR2 default 'true',
16: is_analy_excep_copied IN VARCHAR2 default 'true',
17: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

Line 14: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,

10: PROCEDURE create_duplicate_copy (
11: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
12: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
13: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
14: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
15: is_comments_copied IN VARCHAR2 default 'true',
16: is_analy_excep_copied IN VARCHAR2 default 'true',
17: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
18:

Line 17: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

13: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
14: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
15: is_comments_copied IN VARCHAR2 default 'true',
16: is_analy_excep_copied IN VARCHAR2 default 'true',
17: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
18:
19: PROCEDURE create_new_cycle (
20: ac_name_in IN zpb_analysis_cycles.name%TYPE,
21: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,

Line 20: ac_name_in IN zpb_analysis_cycles.name%TYPE,

16: is_analy_excep_copied IN VARCHAR2 default 'true',
17: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
18:
19: PROCEDURE create_new_cycle (
20: ac_name_in IN zpb_analysis_cycles.name%TYPE,
21: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,
22: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
23: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
24:

Line 21: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,

17: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
18:
19: PROCEDURE create_new_cycle (
20: ac_name_in IN zpb_analysis_cycles.name%TYPE,
21: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,
22: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
23: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
24:
25: PROCEDURE create_new_instance (

Line 23: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

19: PROCEDURE create_new_cycle (
20: ac_name_in IN zpb_analysis_cycles.name%TYPE,
21: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,
22: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
23: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
24:
25: PROCEDURE create_new_instance (
26: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
27: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

Line 26: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

22: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
23: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
24:
25: PROCEDURE create_new_instance (
26: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
27: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
28:
29: PROCEDURE create_tmp_cycle (
30: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 27: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

23: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
24:
25: PROCEDURE create_new_instance (
26: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
27: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
28:
29: PROCEDURE create_tmp_cycle (
30: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
31: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

Line 30: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

26: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
27: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
28:
29: PROCEDURE create_tmp_cycle (
30: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
31: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
32:
33: PROCEDURE delete_ac (
34: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 31: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

27: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
28:
29: PROCEDURE create_tmp_cycle (
30: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
31: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
32:
33: PROCEDURE delete_ac (
34: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
35: delete_tasks IN VARCHAR2 default FND_API.G_TRUE);

Line 34: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

30: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
31: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
32:
33: PROCEDURE delete_ac (
34: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
35: delete_tasks IN VARCHAR2 default FND_API.G_TRUE);
36:
37: PROCEDURE delete_published_ac (
38: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 38: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

34: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
35: delete_tasks IN VARCHAR2 default FND_API.G_TRUE);
36:
37: PROCEDURE delete_published_ac (
38: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
39: prev_instance_options_in IN VARCHAR2,
40: curr_instance_options_in IN VARCHAR2);
41:
42: PROCEDURE delete_tmp_ac (

Line 43: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE);

39: prev_instance_options_in IN VARCHAR2,
40: curr_instance_options_in IN VARCHAR2);
41:
42: PROCEDURE delete_tmp_ac (
43: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE);
44:
45: PROCEDURE get_cycle_type (
46: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
47: cycle_type_out OUT NOCOPY VARCHAR2);

Line 46: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

42: PROCEDURE delete_tmp_ac (
43: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE);
44:
45: PROCEDURE get_cycle_type (
46: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
47: cycle_type_out OUT NOCOPY VARCHAR2);
48:
49: PROCEDURE get_cycle_status (
50: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 50: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

46: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
47: cycle_type_out OUT NOCOPY VARCHAR2);
48:
49: PROCEDURE get_cycle_status (
50: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
51: cycle_status_out OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE get_lock_value (
54: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 54: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

50: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
51: cycle_status_out OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE get_lock_value (
54: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
55: lock_value_out OUT NOCOPY NUMBER);
56:
57: PROCEDURE lock_cycle (
58: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 58: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

54: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
55: lock_value_out OUT NOCOPY NUMBER);
56:
57: PROCEDURE lock_cycle (
58: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
59: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
60: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE);
61:
62: PROCEDURE mark_cycle_for_delete (

Line 59: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,

55: lock_value_out OUT NOCOPY NUMBER);
56:
57: PROCEDURE lock_cycle (
58: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
59: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
60: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE);
61:
62: PROCEDURE mark_cycle_for_delete (
63: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 60: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE);

56:
57: PROCEDURE lock_cycle (
58: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
59: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
60: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE);
61:
62: PROCEDURE mark_cycle_for_delete (
63: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
64: prev_instance_options_in IN VARCHAR2,

Line 63: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

59: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
60: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE);
61:
62: PROCEDURE mark_cycle_for_delete (
63: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
64: prev_instance_options_in IN VARCHAR2,
65: curr_instance_options_in IN VARCHAR2);
66:
67: PROCEDURE publish_cycle (

Line 68: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

64: prev_instance_options_in IN VARCHAR2,
65: curr_instance_options_in IN VARCHAR2);
66:
67: PROCEDURE publish_cycle (
68: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
69: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
70: publish_options_in IN VARCHAR2,
71: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
72:

Line 69: published_by_in IN zpb_analysis_cycles.published_by%TYPE,

65: curr_instance_options_in IN VARCHAR2);
66:
67: PROCEDURE publish_cycle (
68: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
69: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
70: publish_options_in IN VARCHAR2,
71: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
72:
73: -- overloaded proc to support external publish events

Line 71: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

67: PROCEDURE publish_cycle (
68: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
69: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
70: publish_options_in IN VARCHAR2,
71: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
72:
73: -- overloaded proc to support external publish events
74: PROCEDURE publish_cycle (
75: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 75: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

71: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
72:
73: -- overloaded proc to support external publish events
74: PROCEDURE publish_cycle (
75: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
76: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
77: publish_options_in IN VARCHAR2,
78: p_bp_name_in IN VARCHAR2,
79: p_external IN VARCHAR2,

Line 76: published_by_in IN zpb_analysis_cycles.published_by%TYPE,

72:
73: -- overloaded proc to support external publish events
74: PROCEDURE publish_cycle (
75: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
76: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
77: publish_options_in IN VARCHAR2,
78: p_bp_name_in IN VARCHAR2,
79: p_external IN VARCHAR2,
80: p_start_mem_in IN VARCHAR2 DEFAULT NULL,

Line 83: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE,

79: p_external IN VARCHAR2,
80: p_start_mem_in IN VARCHAR2 DEFAULT NULL,
81: p_end_mem_in IN VARCHAR2 DEFAULT NULL,
82: p_send_date_in IN DATE DEFAULT NULL,
83: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE,
84: x_item_key_out OUT NOCOPY VARCHAR2
85: );
86:
87: PROCEDURE save_tmp_cycle (

Line 88: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

84: x_item_key_out OUT NOCOPY VARCHAR2
85: );
86:
87: PROCEDURE save_tmp_cycle (
88: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
89: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
90: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
91: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
92: x_return_status OUT NOCOPY VARCHAR2 ,

Line 89: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,

85: );
86:
87: PROCEDURE save_tmp_cycle (
88: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
89: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
90: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
91: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
92: x_return_status OUT NOCOPY VARCHAR2 ,
93: x_msg_count OUT NOCOPY NUMBER,

Line 90: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,

86:
87: PROCEDURE save_tmp_cycle (
88: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
89: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
90: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
91: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
92: x_return_status OUT NOCOPY VARCHAR2 ,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,

Line 91: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

87: PROCEDURE save_tmp_cycle (
88: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
89: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
90: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
91: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
92: x_return_status OUT NOCOPY VARCHAR2 ,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

Line 95: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

91: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
92: x_return_status OUT NOCOPY VARCHAR2 ,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
96:
97: PROCEDURE enable_cycle (
98: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
99: enable_status_in IN VARCHAR2);

Line 98: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

94: x_msg_data OUT NOCOPY VARCHAR2,
95: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
96:
97: PROCEDURE enable_cycle (
98: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
99: enable_status_in IN VARCHAR2);
100:
101: PROCEDURE getEditableCopyID (
102: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 102: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

98: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
99: enable_status_in IN VARCHAR2);
100:
101: PROCEDURE getEditableCopyID (
102: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
103: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
104:
105: PROCEDURE recoverCycleObjects (
106: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 103: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

99: enable_status_in IN VARCHAR2);
100:
101: PROCEDURE getEditableCopyID (
102: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
103: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
104:
105: PROCEDURE recoverCycleObjects (
106: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
107: is_published_out OUT NOCOPY VARCHAR2);

Line 106: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

102: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
103: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
104:
105: PROCEDURE recoverCycleObjects (
106: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
107: is_published_out OUT NOCOPY VARCHAR2);
108:
109: PROCEDURE getPubIdFromEditId (
110: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 110: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

106: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
107: is_published_out OUT NOCOPY VARCHAR2);
108:
109: PROCEDURE getPubIdFromEditId (
110: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
111: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
112:
113: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER;
114:

Line 111: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);

107: is_published_out OUT NOCOPY VARCHAR2);
108:
109: PROCEDURE getPubIdFromEditId (
110: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
111: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
112:
113: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER;
114:
115: FUNCTION getUniqueName(

Line 113: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER;

109: PROCEDURE getPubIdFromEditId (
110: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
111: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE);
112:
113: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER;
114:
115: FUNCTION getUniqueName(
116: p_bus_area_id IN zpb_analysis_cycles.business_area_id%TYPE,
117: p_cycle_name IN varchar2)RETURN VARCHAR;

Line 116: p_bus_area_id IN zpb_analysis_cycles.business_area_id%TYPE,

112:
113: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER;
114:
115: FUNCTION getUniqueName(
116: p_bus_area_id IN zpb_analysis_cycles.business_area_id%TYPE,
117: p_cycle_name IN varchar2)RETURN VARCHAR;
118:
119: -- this procedure creates a partial business cycle . It is used as a placeholder
120: -- for any BP that is migrated.

Line 211: p_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

207: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
212: x_vm_instance_id OUT NOCOPY NUMBER
213: ) ;
214:
215: END zpb_ac_ops;