APPS.OZF_OFFR_PROD_DENORM_PVT_OA dependencies on OZF_OFFR_ELIG_PROD_DENORM_PVT

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy ozf_offr_elig_prod_denorm_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as

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
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p0(t ozf_offr_elig_prod_denorm_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p0;
21: procedure rosetta_table_copy_out_p0(t ozf_offr_elig_prod_denorm_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();

Line 44: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offr_elig_prod_denorm_pvt.char_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

40: end if;
41: end if;
42: end rosetta_table_copy_out_p0;
43:
44: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offr_elig_prod_denorm_pvt.char_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then
48: if a0.count > 0 then

Line 62: procedure rosetta_table_copy_out_p1(t ozf_offr_elig_prod_denorm_pvt.char_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

58: end loop;
59: end if;
60: end if;
61: end rosetta_table_copy_in_p1;
62: procedure rosetta_table_copy_out_p1(t ozf_offr_elig_prod_denorm_pvt.char_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_VARCHAR2_TABLE_100();

Line 99: ddp_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;

95: , x_offers_tbl out nocopy JTF_NUMBER_TABLE
96: )
97:
98: as
99: ddp_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
100: ddx_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
101: ddindx binary_integer; indx binary_integer;
102: begin
103:

Line 100: ddx_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;

96: )
97:
98: as
99: ddp_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
100: ddx_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
101: ddindx binary_integer; indx binary_integer;
102: begin
103:
104: -- copy data to the local IN or IN-OUT args, if any

Line 118: ozf_offr_elig_prod_denorm_pvt.find_party_elig(ddp_offers_tbl,

114:
115:
116:
117: -- here's the delegated call to the old PL/SQL routine
118: ozf_offr_elig_prod_denorm_pvt.find_party_elig(ddp_offers_tbl,
119: p_party_id,
120: p_cust_acct_id,
121: p_cust_site_id,
122: p_api_version,

Line 158: ddp_products_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;

154: , x_offers_tbl out nocopy JTF_NUMBER_TABLE
155: )
156:
157: as
158: ddp_products_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
159: ddx_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
160: ddindx binary_integer; indx binary_integer;
161: begin
162:

Line 159: ddx_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;

155: )
156:
157: as
158: ddp_products_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
159: ddx_offers_tbl ozf_offr_elig_prod_denorm_pvt.num_tbl_type;
160: ddindx binary_integer; indx binary_integer;
161: begin
162:
163: -- copy data to the local IN or IN-OUT args, if any

Line 177: ozf_offr_elig_prod_denorm_pvt.find_product_elig(ddp_products_tbl,

173:
174:
175:
176: -- here's the delegated call to the old PL/SQL routine
177: ozf_offr_elig_prod_denorm_pvt.find_product_elig(ddp_products_tbl,
178: p_party_id,
179: p_cust_acct_id,
180: p_cust_site_id,
181: p_api_version,