PACKAGE: APPS.OZF_OFFR_PROD_DENORM_PVT_OA

Source

1 package ozf_offr_prod_denorm_pvt_oa as
2   /* $Header: ozfaodms.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);
4   procedure rosetta_table_copy_out_p0(t ozf_offr_elig_prod_denorm_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
5 
6   procedure rosetta_table_copy_in_p1(t out nocopy ozf_offr_elig_prod_denorm_pvt.char_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
7   procedure rosetta_table_copy_out_p1(t ozf_offr_elig_prod_denorm_pvt.char_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
8 
9   procedure find_party_elig(p_offers_tbl JTF_NUMBER_TABLE
10     , p_party_id  NUMBER
11     , p_cust_acct_id  NUMBER
12     , p_cust_site_id  NUMBER
13     , p_api_version  NUMBER
14     , p_init_msg_list  VARCHAR2
15     , p_commit  VARCHAR2
16     , x_return_status out nocopy  VARCHAR2
17     , x_msg_count out nocopy  NUMBER
18     , x_msg_data out nocopy  VARCHAR2
19     , x_offers_tbl out nocopy JTF_NUMBER_TABLE
20   );
21   procedure find_product_elig(p_products_tbl JTF_NUMBER_TABLE
22     , p_party_id  NUMBER
23     , p_cust_acct_id  NUMBER
24     , p_cust_site_id  NUMBER
25     , p_api_version  NUMBER
26     , p_init_msg_list  VARCHAR2
27     , p_commit  VARCHAR2
28     , x_return_status out nocopy  VARCHAR2
29     , x_msg_count out nocopy  NUMBER
30     , x_msg_data out nocopy  VARCHAR2
31     , x_offers_tbl out nocopy JTF_NUMBER_TABLE
32   );
33 end ozf_offr_prod_denorm_pvt_oa;