APPS.IEM_TAGPROCESS_PUB_W dependencies on IEM_TAGPROCESS_PUB

Line 1: package body iem_tagprocess_pub_w as

1: package body iem_tagprocess_pub_w as
2: /* $Header: IEMPTGWB.pls 115.2 2002/12/12 22:54:44 txliu 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_p2(t out nocopy iem_tagprocess_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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_p2(t out nocopy iem_tagprocess_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
14: , a1 JTF_VARCHAR2_TABLE_300
15: , a2 JTF_VARCHAR2_TABLE_100
16: ) as
17: ddindx binary_integer; indx binary_integer;

Line 36: procedure rosetta_table_copy_out_p2(t iem_tagprocess_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p2;
36: procedure rosetta_table_copy_out_p2(t iem_tagprocess_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_VARCHAR2_TABLE_300
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: ) as
40: ddindx binary_integer; indx binary_integer;

Line 86: ddp_biz_keyval_tab iem_tagprocess_pub.keyvals_tbl_type;

82: , x_msg_data out nocopy VARCHAR2
83: )
84:
85: as
86: ddp_biz_keyval_tab iem_tagprocess_pub.keyvals_tbl_type;
87: ddindx binary_integer; indx binary_integer;
88: begin
89:
90: -- copy data to the local IN or IN-OUT args, if any

Line 97: iem_tagprocess_pub_w.rosetta_table_copy_in_p2(ddp_biz_keyval_tab, p6_a0

93:
94:
95:
96:
97: iem_tagprocess_pub_w.rosetta_table_copy_in_p2(ddp_biz_keyval_tab, p6_a0
98: , p6_a1
99: , p6_a2
100: );
101:

Line 107: iem_tagprocess_pub.getencryptid(p_api_version_number,

103:
104:
105:
106: -- here's the delegated call to the old PL/SQL routine
107: iem_tagprocess_pub.getencryptid(p_api_version_number,
108: p_init_msg_list,
109: p_commit,
110: p_email_account_id,
111: p_agent_id,

Line 146: ddx_key_value iem_tagprocess_pub.keyvals_tbl_type;

142: , x_msg_data out nocopy VARCHAR2
143: )
144:
145: as
146: ddx_key_value iem_tagprocess_pub.keyvals_tbl_type;
147: ddindx binary_integer; indx binary_integer;
148: begin
149:
150: -- copy data to the local IN or IN-OUT args, if any

Line 161: iem_tagprocess_pub.gettagvalues(p_api_version_number,

157:
158:
159:
160: -- here's the delegated call to the old PL/SQL routine
161: iem_tagprocess_pub.gettagvalues(p_api_version_number,
162: p_init_msg_list,
163: p_commit,
164: p_encrypted_id,
165: p_message_id,

Line 177: iem_tagprocess_pub_w.rosetta_table_copy_out_p2(ddx_key_value, p5_a0

173:
174:
175:
176:
177: iem_tagprocess_pub_w.rosetta_table_copy_out_p2(ddx_key_value, p5_a0
178: , p5_a1
179: , p5_a2
180: );
181:

Line 200: ddx_key_value iem_tagprocess_pub.keyvals_tbl_type;

196: , x_msg_data out nocopy VARCHAR2
197: )
198:
199: as
200: ddx_key_value iem_tagprocess_pub.keyvals_tbl_type;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:
204: -- copy data to the local IN or IN-OUT args, if any

Line 215: iem_tagprocess_pub.gettagvalues_on_msgid(p_api_version_number,

211:
212:
213:
214: -- here's the delegated call to the old PL/SQL routine
215: iem_tagprocess_pub.gettagvalues_on_msgid(p_api_version_number,
216: p_init_msg_list,
217: p_commit,
218: p_message_id,
219: ddx_key_value,

Line 230: iem_tagprocess_pub_w.rosetta_table_copy_out_p2(ddx_key_value, p4_a0

226:
227:
228:
229:
230: iem_tagprocess_pub_w.rosetta_table_copy_out_p2(ddx_key_value, p4_a0
231: , p4_a1
232: , p4_a2
233: );
234:

Line 254: ddrosetta_retval := iem_tagprocess_pub.isvalidagent(p_agent_id,

250: -- copy data to the local IN or IN-OUT args, if any
251:
252:
253: -- here's the delegated call to the old PL/SQL routine
254: ddrosetta_retval := iem_tagprocess_pub.isvalidagent(p_agent_id,
255: p_email_acct_id);
256:
257: -- copy data back from the local variables to OUT or IN-OUT args, if any
258: if ddrosetta_retval is null

Line 267: end iem_tagprocess_pub_w;

263: end if;
264:
265: end;
266:
267: end iem_tagprocess_pub_w;