DBA Data[Home] [Help]

APPS.HR_WIP_TXNS dependencies on HR_WIP_TRANSACTIONS

Line 20: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

16: (p_item_type IN wf_items.item_type%TYPE
17: ,p_item_key IN wf_items.item_key%TYPE
18: ,p_function_id IN fnd_form_functions.function_id%TYPE
19: ,p_creator_user_id IN fnd_user.user_id%TYPE
20: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
21: ,p_vo_xml IN VARCHAR2
22: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
23: ) RETURN hr_wip_transactions.transaction_id%TYPE;
24: --

Line 22: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

18: ,p_function_id IN fnd_form_functions.function_id%TYPE
19: ,p_creator_user_id IN fnd_user.user_id%TYPE
20: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
21: ,p_vo_xml IN VARCHAR2
22: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
23: ) RETURN hr_wip_transactions.transaction_id%TYPE;
24: --
25: --
26: -- ----------------------------------------------------------------------------

Line 23: ) RETURN hr_wip_transactions.transaction_id%TYPE;

19: ,p_creator_user_id IN fnd_user.user_id%TYPE
20: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
21: ,p_vo_xml IN VARCHAR2
22: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
23: ) RETURN hr_wip_transactions.transaction_id%TYPE;
24: --
25: --
26: -- ----------------------------------------------------------------------------
27: -- |-----------------------< create_transaction >-----------------------|

Line 34: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

30: (p_item_type IN wf_items.item_type%TYPE
31: ,p_item_key IN wf_items.item_key%TYPE
32: ,p_function_id IN fnd_form_functions.function_id%TYPE
33: ,p_creator_user_id IN fnd_user.user_id%TYPE
34: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
35: ,p_vo_xml IN VARCHAR2
36: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
37: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
38: );

Line 36: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

32: ,p_function_id IN fnd_form_functions.function_id%TYPE
33: ,p_creator_user_id IN fnd_user.user_id%TYPE
34: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
35: ,p_vo_xml IN VARCHAR2
36: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
37: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
38: );
39: --
40: -- ----------------------------------------------------------------------------

Line 37: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE

33: ,p_creator_user_id IN fnd_user.user_id%TYPE
34: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
35: ,p_vo_xml IN VARCHAR2
36: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
37: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
38: );
39: --
40: -- ----------------------------------------------------------------------------
41: -- |-----------------------< create_query_only_transaction >-----------------|

Line 49: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

45: ,p_item_key IN wf_items.item_key%TYPE
46: ,p_function_id IN fnd_form_functions.function_id%TYPE
47: ,p_creator_user_id IN fnd_user.user_id%TYPE
48: ,p_vo_xml IN VARCHAR2
49: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
50: ) RETURN hr_wip_transactions.transaction_id%TYPE;
51: --
52: -- ----------------------------------------------------------------------------
53: -- |-----------------------< create_query_only_transaction >-----------------|

Line 50: ) RETURN hr_wip_transactions.transaction_id%TYPE;

46: ,p_function_id IN fnd_form_functions.function_id%TYPE
47: ,p_creator_user_id IN fnd_user.user_id%TYPE
48: ,p_vo_xml IN VARCHAR2
49: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
50: ) RETURN hr_wip_transactions.transaction_id%TYPE;
51: --
52: -- ----------------------------------------------------------------------------
53: -- |-----------------------< create_query_only_transaction >-----------------|
54: -- ----------------------------------------------------------------------------

Line 61: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

57: ,p_item_key IN wf_items.item_key%TYPE
58: ,p_function_id IN fnd_form_functions.function_id%TYPE
59: ,p_creator_user_id IN fnd_user.user_id%TYPE
60: ,p_vo_xml IN VARCHAR2
61: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
62: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
63: );
64: --
65: -- ----------------------------------------------------------------------------

Line 62: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE

58: ,p_function_id IN fnd_form_functions.function_id%TYPE
59: ,p_creator_user_id IN fnd_user.user_id%TYPE
60: ,p_vo_xml IN VARCHAR2
61: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
62: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
63: );
64: --
65: -- ----------------------------------------------------------------------------
66: -- |-----------------------< save_for_later >-----------------------|

Line 73: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

69: (p_item_type IN wf_items.item_type%TYPE
70: ,p_item_key IN wf_items.item_key%TYPE
71: ,p_current_user_id IN fnd_user.user_id%TYPE
72: ,p_vo_xml IN VARCHAR2
73: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
74: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
75: default hr_api.g_varchar2
76: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
77: default hr_api.g_varchar2

Line 74: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

70: ,p_item_key IN wf_items.item_key%TYPE
71: ,p_current_user_id IN fnd_user.user_id%TYPE
72: ,p_vo_xml IN VARCHAR2
73: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
74: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
75: default hr_api.g_varchar2
76: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
77: default hr_api.g_varchar2
78: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE

Line 76: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

72: ,p_vo_xml IN VARCHAR2
73: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
74: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
75: default hr_api.g_varchar2
76: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
77: default hr_api.g_varchar2
78: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
79: );
80: --

Line 78: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE

74: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
75: default hr_api.g_varchar2
76: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
77: default hr_api.g_varchar2
78: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
79: );
80: --
81: -- ----------------------------------------------------------------------------
82: -- |-----------------------< save_for_later >-----------------------|

Line 85: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE

81: -- ----------------------------------------------------------------------------
82: -- |-----------------------< save_for_later >-----------------------|
83: -- ----------------------------------------------------------------------------
84: Procedure save_for_later
85: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
86: ,p_current_user_id IN fnd_user.user_id%TYPE
87: ,p_vo_xml IN VARCHAR2
88: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
89: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 88: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

84: Procedure save_for_later
85: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
86: ,p_current_user_id IN fnd_user.user_id%TYPE
87: ,p_vo_xml IN VARCHAR2
88: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
89: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
90: default hr_api.g_varchar2
91: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
92: default hr_api.g_varchar2

Line 89: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

85: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
86: ,p_current_user_id IN fnd_user.user_id%TYPE
87: ,p_vo_xml IN VARCHAR2
88: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
89: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
90: default hr_api.g_varchar2
91: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
92: default hr_api.g_varchar2
93: );

Line 91: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

87: ,p_vo_xml IN VARCHAR2
88: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
89: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
90: default hr_api.g_varchar2
91: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
92: default hr_api.g_varchar2
93: );
94: --
95: -- ----------------------------------------------------------------------------

Line 99: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE

95: -- ----------------------------------------------------------------------------
96: -- |-----------------------< save_for_later_append >-----------------------|
97: -- ----------------------------------------------------------------------------
98: Procedure save_for_later_append
99: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
100: ,p_vo_xml IN VARCHAR2
101: );
102: --
103: -- ----------------------------------------------------------------------------

Line 111: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

107: (p_item_type IN wf_items.item_type%TYPE
108: ,p_item_key IN wf_items.item_key%TYPE
109: ,p_current_user_id IN fnd_user.user_id%TYPE
110: ,p_vo_xml IN VARCHAR2
111: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
112: default hr_api.g_varchar2
113: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
114: default hr_api.g_varchar2
115: );

Line 113: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

109: ,p_current_user_id IN fnd_user.user_id%TYPE
110: ,p_vo_xml IN VARCHAR2
111: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
112: default hr_api.g_varchar2
113: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
114: default hr_api.g_varchar2
115: );
116: -- ----------------------------------------------------------------------------
117: -- |-----------------------< pending_approval >-----------------------|

Line 120: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE

116: -- ----------------------------------------------------------------------------
117: -- |-----------------------< pending_approval >-----------------------|
118: -- ----------------------------------------------------------------------------
119: Procedure pending_approval
120: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
121: ,p_current_user_id IN fnd_user.user_id%TYPE
122: ,p_vo_xml IN VARCHAR2
123: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
124: default hr_api.g_varchar2

Line 123: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

119: Procedure pending_approval
120: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
121: ,p_current_user_id IN fnd_user.user_id%TYPE
122: ,p_vo_xml IN VARCHAR2
123: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
124: default hr_api.g_varchar2
125: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
126: default hr_api.g_varchar2
127: );

Line 125: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

121: ,p_current_user_id IN fnd_user.user_id%TYPE
122: ,p_vo_xml IN VARCHAR2
123: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
124: default hr_api.g_varchar2
125: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
126: default hr_api.g_varchar2
127: );
128: --
129: -- ----------------------------------------------------------------------------

Line 140: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE

136: -- ----------------------------------------------------------------------------
137: -- |-----------------------< reject_for_correction >-----------------------|
138: -- ----------------------------------------------------------------------------
139: Procedure reject_for_correction
140: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
141: );
142: --
143: -- ----------------------------------------------------------------------------
144: -- |-----------------------< delete_transaction >-----------------------|

Line 155: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE

151: -- ----------------------------------------------------------------------------
152: -- |-----------------------< delete_transaction >-----------------------|
153: -- ----------------------------------------------------------------------------
154: Procedure delete_transaction
155: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
156: );
157: --
158: --
159: -- ----------------------------------------------------------------------------

Line 165: ,p_state IN hr_wip_transactions.state%TYPE

161: -- ----------------------------------------------------------------------------
162: Procedure update_transaction
163: (p_item_type IN wf_items.item_type%TYPE
164: ,p_item_key IN wf_items.item_key%TYPE
165: ,p_state IN hr_wip_transactions.state%TYPE
166: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
167: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
168: default hr_api.g_varchar2
169: ,p_vo_xml IN VARCHAR2

Line 166: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

162: Procedure update_transaction
163: (p_item_type IN wf_items.item_type%TYPE
164: ,p_item_key IN wf_items.item_key%TYPE
165: ,p_state IN hr_wip_transactions.state%TYPE
166: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
167: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
168: default hr_api.g_varchar2
169: ,p_vo_xml IN VARCHAR2
170: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

Line 167: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

163: (p_item_type IN wf_items.item_type%TYPE
164: ,p_item_key IN wf_items.item_key%TYPE
165: ,p_state IN hr_wip_transactions.state%TYPE
166: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
167: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
168: default hr_api.g_varchar2
169: ,p_vo_xml IN VARCHAR2
170: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
171: default hr_api.g_varchar2

Line 170: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

166: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
167: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
168: default hr_api.g_varchar2
169: ,p_vo_xml IN VARCHAR2
170: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
171: default hr_api.g_varchar2
172: );
173: --
174: -- ----------------------------------------------------------------------------

Line 178: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE

174: -- ----------------------------------------------------------------------------
175: -- |-----------------------< update_transaction >-----------------------|
176: -- ----------------------------------------------------------------------------
177: Procedure update_transaction
178: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
179: ,p_state IN hr_wip_transactions.state%TYPE
180: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
181: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
182: default hr_api.g_varchar2

Line 179: ,p_state IN hr_wip_transactions.state%TYPE

175: -- |-----------------------< update_transaction >-----------------------|
176: -- ----------------------------------------------------------------------------
177: Procedure update_transaction
178: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
179: ,p_state IN hr_wip_transactions.state%TYPE
180: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
181: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
182: default hr_api.g_varchar2
183: ,p_vo_xml IN VARCHAR2

Line 180: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

176: -- ----------------------------------------------------------------------------
177: Procedure update_transaction
178: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
179: ,p_state IN hr_wip_transactions.state%TYPE
180: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
181: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
182: default hr_api.g_varchar2
183: ,p_vo_xml IN VARCHAR2
184: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

Line 181: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

177: Procedure update_transaction
178: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
179: ,p_state IN hr_wip_transactions.state%TYPE
180: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
181: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
182: default hr_api.g_varchar2
183: ,p_vo_xml IN VARCHAR2
184: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
185: default hr_api.g_varchar2

Line 184: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

180: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
181: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
182: default hr_api.g_varchar2
183: ,p_vo_xml IN VARCHAR2
184: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
185: default hr_api.g_varchar2
186: );
187: --
188: END hr_wip_txns;