DBA Data[Home] [Help]

APPS.OZF_OFFR_PROD_DENORM_PVT_OA dependencies on JTF_NUMBER_TABLE

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

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);

Line 4: procedure rosetta_table_copy_out_p0(t ozf_offr_elig_prod_denorm_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

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:

Line 9: procedure find_party_elig(p_offers_tbl 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

Line 19: , x_offers_tbl out nocopy JTF_NUMBER_TABLE

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

Line 21: procedure find_product_elig(p_products_tbl JTF_NUMBER_TABLE

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

Line 31: , x_offers_tbl out nocopy JTF_NUMBER_TABLE

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;