DBA Data[Home] [Help]

APPS.OKL_POPULATE_PRCENG_RST_PUB_W dependencies on OKL_POPULATE_PRCENG_RST_PUB

Line 1: package body okl_populate_prceng_rst_pub_w as

1: package body okl_populate_prceng_rst_pub_w as
2: /* $Header: OKLUPRSB.pls 120.1 2005/05/30 12:32:04 kthiruva 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 22: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 49: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p19;
49: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
50: , a1 out nocopy JTF_VARCHAR2_TABLE_200
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE

Line 93: procedure rosetta_table_copy_in_p21(t out nocopy okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 JTF_VARCHAR2_TABLE_100

89: end if;
90: end if;
91: end rosetta_table_copy_out_p19;
92:
93: procedure rosetta_table_copy_in_p21(t out nocopy okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
94: , a1 JTF_VARCHAR2_TABLE_300
95: , a2 JTF_VARCHAR2_TABLE_1000
96: ) as
97: ddindx binary_integer; indx binary_integer;

Line 116: procedure rosetta_table_copy_out_p21(t okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

112: end loop;
113: end if;
114: end if;
115: end rosetta_table_copy_in_p21;
116: procedure rosetta_table_copy_out_p21(t okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
117: , a1 out nocopy JTF_VARCHAR2_TABLE_300
118: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
119: ) as
120: ddindx binary_integer; indx binary_integer;

Line 161: ddp_strm_tbl okl_populate_prceng_rst_pub.strm_tbl_type;

157: , p_sir_id NUMBER
158: )
159:
160: as
161: ddp_strm_tbl okl_populate_prceng_rst_pub.strm_tbl_type;
162: ddindx binary_integer; indx binary_integer;
163: begin
164:
165: -- copy data to the local IN or IN-OUT args, if any

Line 168: okl_populate_prceng_rst_pub_w.rosetta_table_copy_in_p19(ddp_strm_tbl, p2_a0

164:
165: -- copy data to the local IN or IN-OUT args, if any
166:
167:
168: okl_populate_prceng_rst_pub_w.rosetta_table_copy_in_p19(ddp_strm_tbl, p2_a0
169: , p2_a1
170: , p2_a2
171: , p2_a3
172: , p2_a4

Line 177: okl_populate_prceng_rst_pub.populate_sif_ret_strms(x_return_status,

173: );
174:
175:
176: -- here's the delegated call to the old PL/SQL routine
177: okl_populate_prceng_rst_pub.populate_sif_ret_strms(x_return_status,
178: p_index_number,
179: ddp_strm_tbl,
180: p_sir_id);
181:

Line 200: ddp_strm_excp_tbl okl_populate_prceng_rst_pub.strm_excp_tbl_type;

196: , p_description VARCHAR2
197: )
198:
199: as
200: ddp_strm_excp_tbl okl_populate_prceng_rst_pub.strm_excp_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 208: okl_populate_prceng_rst_pub_w.rosetta_table_copy_in_p21(ddp_strm_excp_tbl, p3_a0

204: -- copy data to the local IN or IN-OUT args, if any
205:
206:
207:
208: okl_populate_prceng_rst_pub_w.rosetta_table_copy_in_p21(ddp_strm_excp_tbl, p3_a0
209: , p3_a1
210: , p3_a2
211: );
212:

Line 217: okl_populate_prceng_rst_pub.populate_sif_ret_errors(x_return_status,

213:
214:
215:
216: -- here's the delegated call to the old PL/SQL routine
217: okl_populate_prceng_rst_pub.populate_sif_ret_errors(x_return_status,
218: x_id,
219: p_sir_id,
220: ddp_strm_excp_tbl,
221: p_tag_attribute_name,

Line 234: end okl_populate_prceng_rst_pub_w;

230:
231:
232: end;
233:
234: end okl_populate_prceng_rst_pub_w;