DBA Data[Home] [Help]

APPS.IEM_DPM_PP_QUEUE_PVT_W dependencies on IEM_DPM_PP_QUEUE_PVT

Line 1: package body iem_dpm_pp_queue_pvt_w as

1: package body iem_dpm_pp_queue_pvt_w as
2: /* $Header: iemvdprb.pls 120.0 2005/09/06 11:29 liangxia noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_300

Line 46: procedure rosetta_table_copy_out_p1(t iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 out nocopy JTF_NUMBER_TABLE

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p1;
46: procedure rosetta_table_copy_out_p1(t iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_NUMBER_TABLE
48: , a2 out nocopy JTF_VARCHAR2_TABLE_100
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 122: ddx_folder_work_list iem_dpm_pp_queue_pvt.folder_worklist_tbl;

118: , x_msg_data out nocopy VARCHAR2
119: )
120:
121: as
122: ddx_folder_work_list iem_dpm_pp_queue_pvt.folder_worklist_tbl;
123: ddindx binary_integer; indx binary_integer;
124: begin
125:
126: -- copy data to the local IN or IN-OUT args, if any

Line 135: iem_dpm_pp_queue_pvt.get_folder_work_list(p_api_version_number,

131:
132:
133:
134: -- here's the delegated call to the old PL/SQL routine
135: iem_dpm_pp_queue_pvt.get_folder_work_list(p_api_version_number,
136: p_init_msg_list,
137: p_commit,
138: ddx_folder_work_list,
139: x_return_status,

Line 147: iem_dpm_pp_queue_pvt_w.rosetta_table_copy_out_p1(ddx_folder_work_list, p3_a0

143: -- copy data back from the local variables to OUT or IN-OUT args, if any
144:
145:
146:
147: iem_dpm_pp_queue_pvt_w.rosetta_table_copy_out_p1(ddx_folder_work_list, p3_a0
148: , p3_a1
149: , p3_a2
150: , p3_a3
151: , p3_a4

Line 161: end iem_dpm_pp_queue_pvt_w;

157:
158:
159: end;
160:
161: end iem_dpm_pp_queue_pvt_w;