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.IBE_MSITE_RESP_MGR_PVT dependencies on JTF_NUMBER_TABLE

Line 51: p_responsibility_ids IN JTF_NUMBER_TABLE,

47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_msite_id IN NUMBER,
51: p_responsibility_ids IN JTF_NUMBER_TABLE,
52: p_application_ids IN JTF_NUMBER_TABLE,
53: p_start_date_actives IN JTF_DATE_TABLE,
54: p_end_date_actives IN JTF_DATE_TABLE,
55: p_sort_orders IN JTF_NUMBER_TABLE,

Line 52: p_application_ids IN JTF_NUMBER_TABLE,

48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_msite_id IN NUMBER,
51: p_responsibility_ids IN JTF_NUMBER_TABLE,
52: p_application_ids IN JTF_NUMBER_TABLE,
53: p_start_date_actives IN JTF_DATE_TABLE,
54: p_end_date_actives IN JTF_DATE_TABLE,
55: p_sort_orders IN JTF_NUMBER_TABLE,
56: p_display_names IN JTF_VARCHAR2_TABLE_300,

Line 55: p_sort_orders IN JTF_NUMBER_TABLE,

51: p_responsibility_ids IN JTF_NUMBER_TABLE,
52: p_application_ids IN JTF_NUMBER_TABLE,
53: p_start_date_actives IN JTF_DATE_TABLE,
54: p_end_date_actives IN JTF_DATE_TABLE,
55: p_sort_orders IN JTF_NUMBER_TABLE,
56: p_display_names IN JTF_VARCHAR2_TABLE_300,
57: x_msite_resp_ids OUT NOCOPY JTF_NUMBER_TABLE,
58: x_duplicate_association_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
59: x_is_any_duplicate_status OUT NOCOPY VARCHAR2,

Line 57: x_msite_resp_ids OUT NOCOPY JTF_NUMBER_TABLE,

53: p_start_date_actives IN JTF_DATE_TABLE,
54: p_end_date_actives IN JTF_DATE_TABLE,
55: p_sort_orders IN JTF_NUMBER_TABLE,
56: p_display_names IN JTF_VARCHAR2_TABLE_300,
57: x_msite_resp_ids OUT NOCOPY JTF_NUMBER_TABLE,
58: x_duplicate_association_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
59: x_is_any_duplicate_status OUT NOCOPY VARCHAR2,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,

Line 102: x_msite_resp_ids := JTF_NUMBER_TABLE();

98:
99: -- Check if the association already exists. Populate the
100: -- x_duplicate_association_status with the appropriate information
101: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();
102: x_msite_resp_ids := JTF_NUMBER_TABLE();
103: x_is_any_duplicate_status := FND_API.G_RET_STS_SUCCESS;
104:
105: FOR i IN 1..p_responsibility_ids.COUNT LOOP
106:

Line 215: p_msite_resp_ids IN JTF_NUMBER_TABLE,

211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_msite_resp_ids IN JTF_NUMBER_TABLE,
216: p_object_version_numbers IN JTF_NUMBER_TABLE,
217: p_start_date_actives IN JTF_DATE_TABLE,
218: p_end_date_actives IN JTF_DATE_TABLE,
219: p_sort_orders IN JTF_NUMBER_TABLE,

Line 216: p_object_version_numbers IN JTF_NUMBER_TABLE,

212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_msite_resp_ids IN JTF_NUMBER_TABLE,
216: p_object_version_numbers IN JTF_NUMBER_TABLE,
217: p_start_date_actives IN JTF_DATE_TABLE,
218: p_end_date_actives IN JTF_DATE_TABLE,
219: p_sort_orders IN JTF_NUMBER_TABLE,
220: p_display_names IN JTF_VARCHAR2_TABLE_300,

Line 219: p_sort_orders IN JTF_NUMBER_TABLE,

215: p_msite_resp_ids IN JTF_NUMBER_TABLE,
216: p_object_version_numbers IN JTF_NUMBER_TABLE,
217: p_start_date_actives IN JTF_DATE_TABLE,
218: p_end_date_actives IN JTF_DATE_TABLE,
219: p_sort_orders IN JTF_NUMBER_TABLE,
220: p_display_names IN JTF_VARCHAR2_TABLE_300,
221: p_delete_flags IN JTF_VARCHAR2_TABLE_100,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,

Line 375: p_msite_resp_ids IN JTF_NUMBER_TABLE,

371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,
377: p_responsibility_ids IN JTF_NUMBER_TABLE,
378: p_application_ids IN JTF_NUMBER_TABLE,
379: p_object_version_numbers IN JTF_NUMBER_TABLE,

Line 376: p_msite_ids IN JTF_NUMBER_TABLE,

372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,
377: p_responsibility_ids IN JTF_NUMBER_TABLE,
378: p_application_ids IN JTF_NUMBER_TABLE,
379: p_object_version_numbers IN JTF_NUMBER_TABLE,
380: p_start_date_actives IN JTF_DATE_TABLE,

Line 377: p_responsibility_ids IN JTF_NUMBER_TABLE,

373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,
377: p_responsibility_ids IN JTF_NUMBER_TABLE,
378: p_application_ids IN JTF_NUMBER_TABLE,
379: p_object_version_numbers IN JTF_NUMBER_TABLE,
380: p_start_date_actives IN JTF_DATE_TABLE,
381: p_end_date_actives IN JTF_DATE_TABLE,

Line 378: p_application_ids IN JTF_NUMBER_TABLE,

374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,
377: p_responsibility_ids IN JTF_NUMBER_TABLE,
378: p_application_ids IN JTF_NUMBER_TABLE,
379: p_object_version_numbers IN JTF_NUMBER_TABLE,
380: p_start_date_actives IN JTF_DATE_TABLE,
381: p_end_date_actives IN JTF_DATE_TABLE,
382: p_sort_orders IN JTF_NUMBER_TABLE,

Line 379: p_object_version_numbers IN JTF_NUMBER_TABLE,

375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,
377: p_responsibility_ids IN JTF_NUMBER_TABLE,
378: p_application_ids IN JTF_NUMBER_TABLE,
379: p_object_version_numbers IN JTF_NUMBER_TABLE,
380: p_start_date_actives IN JTF_DATE_TABLE,
381: p_end_date_actives IN JTF_DATE_TABLE,
382: p_sort_orders IN JTF_NUMBER_TABLE,
383: p_display_names IN JTF_VARCHAR2_TABLE_300,

Line 382: p_sort_orders IN JTF_NUMBER_TABLE,

378: p_application_ids IN JTF_NUMBER_TABLE,
379: p_object_version_numbers IN JTF_NUMBER_TABLE,
380: p_start_date_actives IN JTF_DATE_TABLE,
381: p_end_date_actives IN JTF_DATE_TABLE,
382: p_sort_orders IN JTF_NUMBER_TABLE,
383: p_display_names IN JTF_VARCHAR2_TABLE_300,
384: p_group_codes IN JTF_VARCHAR2_TABLE_300,
385: p_delete_flags IN JTF_VARCHAR2_TABLE_100,
386: x_return_status OUT NOCOPY VARCHAR2,

Line 395: l_msite_resp_ids JTF_NUMBER_TABLE;

391: l_api_name CONSTANT VARCHAR2(30) := 'Update_Delete_Msite_Resps';
392: l_api_version CONSTANT NUMBER := 1.0;
393: l_msite_resp_id NUMBER;
394: l_group_code VARCHAR2(80);
395: l_msite_resp_ids JTF_NUMBER_TABLE;
396:
397: Cursor c_msite_resp_group (l_msite_resp_id Number)
398: Is Select group_code
399: From ibe_msite_resps_b

Line 404: l_msite_resp_ids := JTF_NUMBER_TABLE();

400: where msite_resp_id = l_msite_resp_id;
401:
402: BEGIN
403:
404: l_msite_resp_ids := JTF_NUMBER_TABLE();
405:
406: -- Standard Start of API savepoint
407: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
408:

Line 721: p_msite_resp_ids IN JTF_NUMBER_TABLE,

717: p_api_version IN NUMBER,
718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: p_msite_resp_ids IN JTF_NUMBER_TABLE,
722: p_object_version_numbers IN JTF_NUMBER_TABLE,
723: p_sort_orders IN JTF_NUMBER_TABLE,
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_msg_count OUT NOCOPY NUMBER,

Line 722: p_object_version_numbers IN JTF_NUMBER_TABLE,

718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: p_msite_resp_ids IN JTF_NUMBER_TABLE,
722: p_object_version_numbers IN JTF_NUMBER_TABLE,
723: p_sort_orders IN JTF_NUMBER_TABLE,
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_msg_count OUT NOCOPY NUMBER,
726: x_msg_data OUT NOCOPY VARCHAR2

Line 723: p_sort_orders IN JTF_NUMBER_TABLE,

719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: p_msite_resp_ids IN JTF_NUMBER_TABLE,
722: p_object_version_numbers IN JTF_NUMBER_TABLE,
723: p_sort_orders IN JTF_NUMBER_TABLE,
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_msg_count OUT NOCOPY NUMBER,
726: x_msg_data OUT NOCOPY VARCHAR2
727: )