DBA Data[Home] [Help]

APPS.PV_LOCATOR dependencies on JTF_NUMBER_TABLE

Line 88: ,p_partner_tbl IN JTF_NUMBER_TABLE

84: ,p_commit IN VARCHAR2 := FND_API.g_false
85: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
86:
87: ,p_customer_address IN party_address_rec_type
88: ,p_partner_tbl IN JTF_NUMBER_TABLE
89: ,p_max_no_partners IN NUMBER
90: ,p_distance IN NUMBER
91: ,p_distance_unit IN VARCHAR2
92: ,p_sort_by_distance IN VARCHAR2 := 'T'

Line 93: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE

89: ,p_max_no_partners IN NUMBER
90: ,p_distance IN NUMBER
91: ,p_distance_unit IN VARCHAR2
92: ,p_sort_by_distance IN VARCHAR2 := 'T'
93: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
94: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
95: ,x_distance_unit OUT NOCOPY VARCHAR2
96: ,x_return_status OUT NOCOPY VARCHAR2
97: ,x_msg_count OUT NOCOPY NUMBER

Line 94: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE

90: ,p_distance IN NUMBER
91: ,p_distance_unit IN VARCHAR2
92: ,p_sort_by_distance IN VARCHAR2 := 'T'
93: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
94: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
95: ,x_distance_unit OUT NOCOPY VARCHAR2
96: ,x_return_status OUT NOCOPY VARCHAR2
97: ,x_msg_count OUT NOCOPY NUMBER
98: ,x_msg_data OUT NOCOPY VARCHAR2

Line 135: ,p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE

131: ,p_max_no_partners IN NUMBER
132: ,p_distance IN NUMBER
133: ,p_distance_unit IN VARCHAR2
134: ,p_sql_query IN VARCHAR2
135: ,p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE
136: ,p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000
137: ,p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
138: ,p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
139: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 139: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE

135: ,p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE
136: ,p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000
137: ,p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
138: ,p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
139: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
140: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
141: ,x_return_status OUT NOCOPY VARCHAR2
142: ,x_msg_count OUT NOCOPY NUMBER
143: ,x_msg_data OUT NOCOPY VARCHAR2

Line 140: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE

136: ,p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000
137: ,p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
138: ,p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
139: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
140: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
141: ,x_return_status OUT NOCOPY VARCHAR2
142: ,x_msg_count OUT NOCOPY NUMBER
143: ,x_msg_data OUT NOCOPY VARCHAR2
144: