1: package body ozf_offr_prod_denorm_pvt_oa as
2: /* $Header: ozfaodmb.pls 120.0 2005/08/31 09:43 gramanat noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy ozf_offr_elig_prod_denorm_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin
101: ddindx binary_integer; indx binary_integer;
102: begin
103:
104: -- copy data to the local IN or IN-OUT args, if any
105: ozf_offr_prod_denorm_pvt_oa.rosetta_table_copy_in_p0(ddp_offers_tbl, p_offers_tbl);
106:
107:
108:
109:
137:
138:
139:
140:
141: ozf_offr_prod_denorm_pvt_oa.rosetta_table_copy_out_p0(ddx_offers_tbl, x_offers_tbl);
142: end;
143:
144: procedure find_product_elig(p_products_tbl JTF_NUMBER_TABLE
145: , p_party_id NUMBER
160: ddindx binary_integer; indx binary_integer;
161: begin
162:
163: -- copy data to the local IN or IN-OUT args, if any
164: ozf_offr_prod_denorm_pvt_oa.rosetta_table_copy_in_p0(ddp_products_tbl, p_products_tbl);
165:
166:
167:
168:
196:
197:
198:
199:
200: ozf_offr_prod_denorm_pvt_oa.rosetta_table_copy_out_p0(ddx_offers_tbl, x_offers_tbl);
201: end;
202:
203: end ozf_offr_prod_denorm_pvt_oa;
199:
200: ozf_offr_prod_denorm_pvt_oa.rosetta_table_copy_out_p0(ddx_offers_tbl, x_offers_tbl);
201: end;
202:
203: end ozf_offr_prod_denorm_pvt_oa;