DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB_W dependencies on PV_TERR_ASSIGN_PUB

Line 1: package pv_terr_assign_pub_w AUTHID CURRENT_USER as

1: package pv_terr_assign_pub_w AUTHID CURRENT_USER as
2: /* $Header: pvxwptas.pls 120.1 2005/08/10 01:45 appldev ship $ */
3: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400

1: package pv_terr_assign_pub_w AUTHID CURRENT_USER as
2: /* $Header: pvxwptas.pls 120.1 2005/08/10 01:45 appldev ship $ */
3: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 19: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_100
18: );
19: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

32: , a13 out nocopy JTF_VARCHAR2_TABLE_500
33: , a14 out nocopy JTF_VARCHAR2_TABLE_100
34: );
35:
36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100

Line 51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);

63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);

Line 68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);

64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:

Line 70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);

66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);

Line 71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);

67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:

Line 73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);

69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);

Line 74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);

70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:

Line 76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);

72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );

Line 77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);

73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE

75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: );
83:

Line 81: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: );
83:
84: procedure get_res_from_team_group(p_resource_id NUMBER
85: , p_resource_type VARCHAR2

Line 231: end pv_terr_assign_pub_w;

227: , x_msg_count out nocopy NUMBER
228: , x_msg_data out nocopy VARCHAR2
229: , p12_a0 out nocopy JTF_NUMBER_TABLE
230: );
231: end pv_terr_assign_pub_w;