DBA Data[Home] [Help]

APPS.PQP_COPY_UDT dependencies on HR_UTILITY

Line 27: hr_utility.set_location('Entering:'|| l_proc, 10);

23:
24: l_proc VARCHAR2(72) := g_package||'add_id';
25:
26: BEGIN
27: hr_utility.set_location('Entering:'|| l_proc, 10);
28:
29:
30: IF p_type_flag ='C' THEN
31: -- Column

Line 38: hr_utility.set_location('Leaving:'|| l_proc, 20);

34: -- Row
35: t_RowId(p_curr_id) := p_new_id;
36: END IF;
37:
38: hr_utility.set_location('Leaving:'|| l_proc, 20);
39: END; -- add_id
40:
41: -- ---------------------------------------------------------------------------+
42: -- |------------------------< GET_NEW_USER_ROW_ID >---------------------------|

Line 52: hr_utility.set_location('Entering:'|| l_proc, 10);

48: l_proc VARCHAR2(72) := g_package||'get_new_user_row_id';
49:
50: BEGIN
51:
52: hr_utility.set_location('Entering:'|| l_proc, 10);
53:
54: l_new_pur_id := t_RowId(p_curr_pur_id);
55:
56: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 56: hr_utility.set_location('Leaving:'|| l_proc, 20);

52: hr_utility.set_location('Entering:'|| l_proc, 10);
53:
54: l_new_pur_id := t_RowId(p_curr_pur_id);
55:
56: hr_utility.set_location('Leaving:'|| l_proc, 20);
57:
58: RETURN l_new_pur_id;
59:
60: END; -- get_new_pur_id

Line 80: hr_utility.set_location('Entering:'|| l_proc, 10);

76:
77: l_proc VARCHAR2(72) := g_package||'copy_table';
78:
79: BEGIN
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81:
82: For r_user_table in c_user_table
83: Loop
84:

Line 116: hr_utility.set_location('Leaving:'|| l_proc, 20);

112: );
113:
114: End Loop;
115:
116: hr_utility.set_location('Leaving:'|| l_proc, 20);
117:
118: Return l_new_put_id;
119:
120: END; -- copy_table

Line 142: hr_utility.set_location('Entering:'|| l_proc, 10);

138: l_proc VARCHAR2(72) := g_package||'copy_columns';
139:
140: BEGIN
141:
142: hr_utility.set_location('Entering:'|| l_proc, 10);
143:
144: For r_user_columns in c_user_columns
145: Loop
146:

Line 176: hr_utility.set_location('Leaving:'|| l_proc, 20);

172: );
173:
174: End Loop;
175:
176: hr_utility.set_location('Leaving:'|| l_proc, 20);
177: END; -- copy_columns
178:
179: -- ---------------------------------------------------------------------------+
180: -- |------------------------< COPY_ROWS >-------------------------------------|

Line 203: hr_utility.set_location('Entering:'|| l_proc, 10);

199: l_proc VARCHAR2(72) := g_package||'copy_rows';
200:
201: BEGIN
202:
203: hr_utility.set_location('Entering:'|| l_proc, 10);
204:
205: For r_user_rows in c_user_rows
206: Loop
207:

Line 277: hr_utility.set_location('Leaving:'|| l_proc, 20);

273: END IF;
274: --
275: End Loop;
276:
277: hr_utility.set_location('Leaving:'|| l_proc, 20);
278:
279: END; -- copy_rows
280:
281: -- ---------------------------------------------------------------------------+

Line 310: hr_utility.set_location('Entering:'|| l_proc, 10);

306: l_proc VARCHAR2(72) := g_package||'copy_column_instances';
307:
308: BEGIN
309:
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311:
312: For l_cntr IN nvl(t_ColId.FIRST,-1)..nvl(t_ColId.LAST,-2)
313: Loop -- 1
314:

Line 388: hr_utility.set_location('Leaving:'|| l_proc, 20);

384: End if; -- t_ColId.EXISTS
385: --
386: End Loop; -- 1
387:
388: hr_utility.set_location('Leaving:'|| l_proc, 20);
389:
390: END; -- copy_column_instances
391:
392: -- ---------------------------------------------------------------------------+

Line 406: hr_utility.set_location('Entering:'|| l_proc, 10);

402: l_proc VARCHAR2(72) := g_package||'copy_user_table';
403:
404: BEGIN
405:
406: hr_utility.set_location('Entering:'|| l_proc, 10);
407:
408: -- Set package variables
409: g_target_bg_id := p_business_group_id;
410: g_udt_prefix := upper(p_udt_prefix);

Line 428: hr_utility.set_location('Leaving:'|| l_proc, 20);

424:
425: -- Copy PAY_USER_COLUMN_INSTANCES_F data
426: copy_column_instances;
427:
428: hr_utility.set_location('Leaving:'|| l_proc, 20);
429:
430: -- Return the Id of the new User Table
431: RETURN l_new_put_id;
432: