eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_RUNTIME_PROD_PVT dependencies on JTF_NUMBER_TABLE

Line 13: p_prod_lst IN JTF_NUMBER_TABLE ,

9: PROCEDURE getRelatedItems(
10: p_api_version_number IN NUMBER ,
11: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
12: p_application_id IN NUMBER ,
13: p_prod_lst IN JTF_NUMBER_TABLE ,
14: p_rel_type_code IN VARCHAR2 ,
15: p_org_id IN NUMBER ,
16: p_max_ret_num IN NUMBER := NULL ,
17: p_order_by_clause IN VARCHAR2 := NULL ,

Line 18: x_items_tbl OUT NOCOPY JTF_Number_Table ,

14: p_rel_type_code IN VARCHAR2 ,
15: p_org_id IN NUMBER ,
16: p_max_ret_num IN NUMBER := NULL ,
17: p_order_by_clause IN VARCHAR2 := NULL ,
18: x_items_tbl OUT NOCOPY JTF_Number_Table ,
19: x_return_status OUT NOCOPY VARCHAR2 ,
20: x_msg_count OUT NOCOPY NUMBER ,
21: x_msg_data OUT NOCOPY VARCHAR2
22: );

Line 32: p_prod_lst IN JTF_NUMBER_TABLE ,

28: p_application_id IN NUMBER ,
29: p_msite_id IN NUMBER ,
30: p_top_section_id IN NUMBER ,
31: p_incl_section IN VARCHAR2 := NULL ,
32: p_prod_lst IN JTF_NUMBER_TABLE ,
33: p_rel_type_code IN VARCHAR2 ,
34: p_org_id IN NUMBER ,
35: p_max_ret_num IN NUMBER := NULL ,
36: p_order_by_clause IN VARCHAR2 := NULL ,

Line 37: x_items_tbl OUT NOCOPY JTF_Number_Table ,

33: p_rel_type_code IN VARCHAR2 ,
34: p_org_id IN NUMBER ,
35: p_max_ret_num IN NUMBER := NULL ,
36: p_order_by_clause IN VARCHAR2 := NULL ,
37: x_items_tbl OUT NOCOPY JTF_Number_Table ,
38: x_return_status OUT NOCOPY VARCHAR2 ,
39: x_msg_count OUT NOCOPY NUMBER ,
40: x_msg_data OUT NOCOPY VARCHAR2
41: );

Line 51: p_prod_lst IN JTF_NUMBER_TABLE,

47: p_application_id IN NUMBER,
48: p_party_id IN NUMBER,
49: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
50: p_currency_code IN VARCHAR2 := NULL,
51: p_prod_lst IN JTF_NUMBER_TABLE,
52: p_msite_id IN NUMBER := NULL,
53: p_top_section_id IN NUMBER := NULL,
54: p_org_id IN NUMBER,
55: p_bus_prior IN VARCHAR2 := NULL,

Line 60: x_prod_lst OUT NOCOPY JTF_Number_Table,

56: p_bus_prior_order IN VARCHAR2 := NULL,
57: p_filter_ref_code IN VARCHAR2 := NULL,
58: p_price_list_id IN NUMBER := NULL,
59: p_max_ret_num IN NUMBER := NULL,
60: x_prod_lst OUT NOCOPY JTF_Number_Table,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2
64: );

Line 83: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

79: p_bus_prior_order IN VARCHAR2,
80: p_filter_ref_code IN VARCHAR2,
81: p_price_list_id IN NUMBER := NULL,
82: p_max_ret_num IN NUMBER := NULL,
83: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2
87: );

Line 96: p_prod_lst IN JTF_NUMBER_TABLE,

92: p_application_id IN NUMBER,
93: p_party_id IN NUMBER,
94: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_currency_code IN VARCHAR2 := NULL,
96: p_prod_lst IN JTF_NUMBER_TABLE,
97: p_msite_id IN NUMBER,
98: p_top_section_id IN NUMBER,
99: p_org_id IN NUMBER,
100: p_rel_type_code IN VARCHAR2,

Line 106: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

102: p_bus_prior_order IN VARCHAR2,
103: p_filter_ref_code IN VARCHAR2,
104: p_price_list_id IN NUMBER := NULL,
105: p_max_ret_num IN NUMBER := NULL,
106: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2
110: );

Line 120: p_prod_lst IN JTF_NUMBER_TABLE,

116: p_application_id IN NUMBER,
117: p_party_id IN NUMBER,
118: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_currency_code IN VARCHAR2 := NULL,
120: p_prod_lst IN JTF_NUMBER_TABLE,
121: p_org_id IN NUMBER,
122: p_bus_prior IN VARCHAR2,
123: p_bus_prior_order IN VARCHAR2,
124: p_price_list_id IN NUMBER := NULL,

Line 126: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

122: p_bus_prior IN VARCHAR2,
123: p_bus_prior_order IN VARCHAR2,
124: p_price_list_id IN NUMBER := NULL,
125: p_max_ret_num IN NUMBER := NULL,
126: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2
130: );

Line 139: p_itmid_tbl IN JTF_NUMBER_TABLE,

135: p_application_id IN NUMBER,
136: p_party_id IN NUMBER,
137: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
138: p_currency_code IN VARCHAR2 := NULL,
139: p_itmid_tbl IN JTF_NUMBER_TABLE,
140: p_organization_id IN NUMBER,
141: p_category_set_id IN NUMBER,
142: p_retrieve_price IN VARCHAR2 := FND_API.G_FALSE,
143: p_price_list_id IN NUMBER := NULL,

Line 148: x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,

144: p_price_request_type IN VARCHAR2 := NULL,
145: p_price_event IN VARCHAR2 := NULL,
146: x_item_csr OUT NOCOPY prod_cursor,
147: x_category_id_csr OUT NOCOPY prod_cursor,
148: x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,
149: x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,
150: x_price_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100,
151: x_price_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300,
152: x_price_return_status OUT NOCOPY VARCHAR2,

Line 149: x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,

145: p_price_event IN VARCHAR2 := NULL,
146: x_item_csr OUT NOCOPY prod_cursor,
147: x_category_id_csr OUT NOCOPY prod_cursor,
148: x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,
149: x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,
150: x_price_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100,
151: x_price_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300,
152: x_price_return_status OUT NOCOPY VARCHAR2,
153: x_price_return_status_text OUT NOCOPY VARCHAR2,

Line 167: p_prod_lst IN JTF_NUMBER_TABLE,

163: p_application_id IN NUMBER,
164: p_party_id IN NUMBER,
165: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_currency_code IN VARCHAR2 := NULL,
167: p_prod_lst IN JTF_NUMBER_TABLE,
168: p_msite_id IN NUMBER,
169: p_top_section_id IN NUMBER,
170: p_org_id IN NUMBER,
171: p_rel_type_code IN VARCHAR2,

Line 173: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

169: p_top_section_id IN NUMBER,
170: p_org_id IN NUMBER,
171: p_rel_type_code IN VARCHAR2,
172: p_max_ret_num IN NUMBER := NULL,
173: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2
177: );

Line 193: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

189: p_top_section_id IN NUMBER,
190: p_org_id IN NUMBER,
191: p_rel_type_code IN VARCHAR2,
192: p_max_ret_num IN NUMBER := NULL,
193: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2
197: );