APPS.PV_OFFER_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE

1: package pv_offer_pub_w as
2: /* $Header: pvxwoffs.pls 120.1 2005/06/16 17:26 appldev $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package pv_offer_pub_w as
2: /* $Header: pvxwoffs.pls 120.1 2005/06/16 17:26 appldev $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package pv_offer_pub_w as
2: /* $Header: pvxwoffs.pls 120.1 2005/06/16 17:26 appldev $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE

Line 14: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a1 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 16: , a2 out nocopy JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_NUMBER_TABLE

Line 20: , a6 out nocopy JTF_NUMBER_TABLE

16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_NUMBER_TABLE
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );

Line 22: , a8 out nocopy JTF_NUMBER_TABLE

18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_NUMBER_TABLE
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE

Line 26: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE

22: , a8 out nocopy JTF_NUMBER_TABLE
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_VARCHAR2_TABLE_100
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_300
30: , a4 JTF_NUMBER_TABLE

Line 30: , a4 JTF_NUMBER_TABLE

26: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_VARCHAR2_TABLE_100
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_300
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 33: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

29: , a3 JTF_VARCHAR2_TABLE_300
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_100
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_300
37: , a4 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_NUMBER_TABLE

33: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_100
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_300
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: );
40:
41: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE

Line 41: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE

37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: );
40:
41: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
42: , a1 JTF_NUMBER_TABLE
43: , a2 JTF_NUMBER_TABLE
44: , a3 JTF_VARCHAR2_TABLE_100
45: );

Line 42: , a1 JTF_NUMBER_TABLE

38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: );
40:
41: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
42: , a1 JTF_NUMBER_TABLE
43: , a2 JTF_NUMBER_TABLE
44: , a3 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 43: , a2 JTF_NUMBER_TABLE

39: );
40:
41: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
42: , a1 JTF_NUMBER_TABLE
43: , a2 JTF_NUMBER_TABLE
44: , a3 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_NUMBER_TABLE

Line 46: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

42: , a1 JTF_NUMBER_TABLE
43: , a2 JTF_NUMBER_TABLE
44: , a3 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_NUMBER_TABLE
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: );

Line 47: , a1 out nocopy JTF_NUMBER_TABLE

43: , a2 JTF_NUMBER_TABLE
44: , a3 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_NUMBER_TABLE
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: );
51:

Line 48: , a2 out nocopy JTF_NUMBER_TABLE

44: , a3 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_NUMBER_TABLE
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: );
51:
52: procedure create_offer(p_init_msg_list VARCHAR2

Line 58: , p7_a0 JTF_NUMBER_TABLE

54: , p_commit VARCHAR2
55: , p_benefit_id NUMBER
56: , p_operation VARCHAR2
57: , p_offer_id NUMBER
58: , p7_a0 JTF_NUMBER_TABLE
59: , p7_a1 JTF_NUMBER_TABLE
60: , p7_a2 JTF_NUMBER_TABLE
61: , p7_a3 JTF_VARCHAR2_TABLE_100
62: , p8_a0 JTF_NUMBER_TABLE

Line 59: , p7_a1 JTF_NUMBER_TABLE

55: , p_benefit_id NUMBER
56: , p_operation VARCHAR2
57: , p_offer_id NUMBER
58: , p7_a0 JTF_NUMBER_TABLE
59: , p7_a1 JTF_NUMBER_TABLE
60: , p7_a2 JTF_NUMBER_TABLE
61: , p7_a3 JTF_VARCHAR2_TABLE_100
62: , p8_a0 JTF_NUMBER_TABLE
63: , p8_a1 JTF_NUMBER_TABLE

Line 60: , p7_a2 JTF_NUMBER_TABLE

56: , p_operation VARCHAR2
57: , p_offer_id NUMBER
58: , p7_a0 JTF_NUMBER_TABLE
59: , p7_a1 JTF_NUMBER_TABLE
60: , p7_a2 JTF_NUMBER_TABLE
61: , p7_a3 JTF_VARCHAR2_TABLE_100
62: , p8_a0 JTF_NUMBER_TABLE
63: , p8_a1 JTF_NUMBER_TABLE
64: , p8_a2 JTF_NUMBER_TABLE

Line 62: , p8_a0 JTF_NUMBER_TABLE

58: , p7_a0 JTF_NUMBER_TABLE
59: , p7_a1 JTF_NUMBER_TABLE
60: , p7_a2 JTF_NUMBER_TABLE
61: , p7_a3 JTF_VARCHAR2_TABLE_100
62: , p8_a0 JTF_NUMBER_TABLE
63: , p8_a1 JTF_NUMBER_TABLE
64: , p8_a2 JTF_NUMBER_TABLE
65: , p8_a3 JTF_VARCHAR2_TABLE_100
66: , p8_a4 JTF_VARCHAR2_TABLE_100

Line 63: , p8_a1 JTF_NUMBER_TABLE

59: , p7_a1 JTF_NUMBER_TABLE
60: , p7_a2 JTF_NUMBER_TABLE
61: , p7_a3 JTF_VARCHAR2_TABLE_100
62: , p8_a0 JTF_NUMBER_TABLE
63: , p8_a1 JTF_NUMBER_TABLE
64: , p8_a2 JTF_NUMBER_TABLE
65: , p8_a3 JTF_VARCHAR2_TABLE_100
66: , p8_a4 JTF_VARCHAR2_TABLE_100
67: , p8_a5 JTF_VARCHAR2_TABLE_100

Line 64: , p8_a2 JTF_NUMBER_TABLE

60: , p7_a2 JTF_NUMBER_TABLE
61: , p7_a3 JTF_VARCHAR2_TABLE_100
62: , p8_a0 JTF_NUMBER_TABLE
63: , p8_a1 JTF_NUMBER_TABLE
64: , p8_a2 JTF_NUMBER_TABLE
65: , p8_a3 JTF_VARCHAR2_TABLE_100
66: , p8_a4 JTF_VARCHAR2_TABLE_100
67: , p8_a5 JTF_VARCHAR2_TABLE_100
68: , p8_a6 JTF_NUMBER_TABLE

Line 68: , p8_a6 JTF_NUMBER_TABLE

64: , p8_a2 JTF_NUMBER_TABLE
65: , p8_a3 JTF_VARCHAR2_TABLE_100
66: , p8_a4 JTF_VARCHAR2_TABLE_100
67: , p8_a5 JTF_VARCHAR2_TABLE_100
68: , p8_a6 JTF_NUMBER_TABLE
69: , p8_a7 JTF_VARCHAR2_TABLE_100
70: , p8_a8 JTF_NUMBER_TABLE
71: , p8_a9 JTF_VARCHAR2_TABLE_100
72: , p9_a0 JTF_NUMBER_TABLE

Line 70: , p8_a8 JTF_NUMBER_TABLE

66: , p8_a4 JTF_VARCHAR2_TABLE_100
67: , p8_a5 JTF_VARCHAR2_TABLE_100
68: , p8_a6 JTF_NUMBER_TABLE
69: , p8_a7 JTF_VARCHAR2_TABLE_100
70: , p8_a8 JTF_NUMBER_TABLE
71: , p8_a9 JTF_VARCHAR2_TABLE_100
72: , p9_a0 JTF_NUMBER_TABLE
73: , p9_a1 JTF_VARCHAR2_TABLE_100
74: , p9_a2 JTF_VARCHAR2_TABLE_100

Line 72: , p9_a0 JTF_NUMBER_TABLE

68: , p8_a6 JTF_NUMBER_TABLE
69: , p8_a7 JTF_VARCHAR2_TABLE_100
70: , p8_a8 JTF_NUMBER_TABLE
71: , p8_a9 JTF_VARCHAR2_TABLE_100
72: , p9_a0 JTF_NUMBER_TABLE
73: , p9_a1 JTF_VARCHAR2_TABLE_100
74: , p9_a2 JTF_VARCHAR2_TABLE_100
75: , p9_a3 JTF_VARCHAR2_TABLE_300
76: , p9_a4 JTF_NUMBER_TABLE

Line 76: , p9_a4 JTF_NUMBER_TABLE

72: , p9_a0 JTF_NUMBER_TABLE
73: , p9_a1 JTF_VARCHAR2_TABLE_100
74: , p9_a2 JTF_VARCHAR2_TABLE_100
75: , p9_a3 JTF_VARCHAR2_TABLE_300
76: , p9_a4 JTF_NUMBER_TABLE
77: , p9_a5 JTF_VARCHAR2_TABLE_100
78: , x_offer_id out nocopy NUMBER
79: , x_qp_list_header_id out nocopy NUMBER
80: , x_error_location out nocopy NUMBER