DBA Data[Home] [Help]

APPS.JTF_MSITE_RESP_MGR_PVT dependencies on JTF_NUMBER_TABLE

Line 39: p_responsibility_ids IN JTF_NUMBER_TABLE,

35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_msite_id IN NUMBER,
39: p_responsibility_ids IN JTF_NUMBER_TABLE,
40: p_application_ids IN JTF_NUMBER_TABLE,
41: p_start_date_actives IN JTF_DATE_TABLE,
42: p_end_date_actives IN JTF_DATE_TABLE,
43: p_sort_orders IN JTF_NUMBER_TABLE,

Line 40: p_application_ids IN JTF_NUMBER_TABLE,

36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_msite_id IN NUMBER,
39: p_responsibility_ids IN JTF_NUMBER_TABLE,
40: p_application_ids IN JTF_NUMBER_TABLE,
41: p_start_date_actives IN JTF_DATE_TABLE,
42: p_end_date_actives IN JTF_DATE_TABLE,
43: p_sort_orders IN JTF_NUMBER_TABLE,
44: p_display_names IN JTF_VARCHAR2_TABLE_300,

Line 43: p_sort_orders IN JTF_NUMBER_TABLE,

39: p_responsibility_ids IN JTF_NUMBER_TABLE,
40: p_application_ids IN JTF_NUMBER_TABLE,
41: p_start_date_actives IN JTF_DATE_TABLE,
42: p_end_date_actives IN JTF_DATE_TABLE,
43: p_sort_orders IN JTF_NUMBER_TABLE,
44: p_display_names IN JTF_VARCHAR2_TABLE_300,
45: x_msite_resp_ids OUT JTF_NUMBER_TABLE,
46: x_duplicate_association_status OUT JTF_VARCHAR2_TABLE_100,
47: x_is_any_duplicate_status OUT VARCHAR2,

Line 45: x_msite_resp_ids OUT JTF_NUMBER_TABLE,

41: p_start_date_actives IN JTF_DATE_TABLE,
42: p_end_date_actives IN JTF_DATE_TABLE,
43: p_sort_orders IN JTF_NUMBER_TABLE,
44: p_display_names IN JTF_VARCHAR2_TABLE_300,
45: x_msite_resp_ids OUT JTF_NUMBER_TABLE,
46: x_duplicate_association_status OUT JTF_VARCHAR2_TABLE_100,
47: x_is_any_duplicate_status OUT VARCHAR2,
48: x_return_status OUT VARCHAR2,
49: x_msg_count OUT NUMBER,

Line 90: x_msite_resp_ids := JTF_NUMBER_TABLE();

86:
87: -- Check if the association already exists. Populate the
88: -- x_duplicate_association_status with the appropriate information
89: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();
90: x_msite_resp_ids := JTF_NUMBER_TABLE();
91: x_is_any_duplicate_status := FND_API.G_RET_STS_SUCCESS;
92:
93: FOR i IN 1..p_responsibility_ids.COUNT LOOP
94:

Line 202: p_msite_resp_ids IN JTF_NUMBER_TABLE,

198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_msite_resp_ids IN JTF_NUMBER_TABLE,
203: p_object_version_numbers IN JTF_NUMBER_TABLE,
204: p_start_date_actives IN JTF_DATE_TABLE,
205: p_end_date_actives IN JTF_DATE_TABLE,
206: p_sort_orders IN JTF_NUMBER_TABLE,

Line 203: p_object_version_numbers IN JTF_NUMBER_TABLE,

199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_msite_resp_ids IN JTF_NUMBER_TABLE,
203: p_object_version_numbers IN JTF_NUMBER_TABLE,
204: p_start_date_actives IN JTF_DATE_TABLE,
205: p_end_date_actives IN JTF_DATE_TABLE,
206: p_sort_orders IN JTF_NUMBER_TABLE,
207: p_display_names IN JTF_VARCHAR2_TABLE_300,

Line 206: p_sort_orders IN JTF_NUMBER_TABLE,

202: p_msite_resp_ids IN JTF_NUMBER_TABLE,
203: p_object_version_numbers IN JTF_NUMBER_TABLE,
204: p_start_date_actives IN JTF_DATE_TABLE,
205: p_end_date_actives IN JTF_DATE_TABLE,
206: p_sort_orders IN JTF_NUMBER_TABLE,
207: p_display_names IN JTF_VARCHAR2_TABLE_300,
208: p_delete_flags IN JTF_VARCHAR2_TABLE_100,
209: x_return_status OUT VARCHAR2,
210: x_msg_count OUT NUMBER,

Line 637: p_responsibility_ids IN JTF_NUMBER_TABLE,

633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: p_responsibility_ids IN JTF_NUMBER_TABLE,
638: p_application_ids IN JTF_NUMBER_TABLE,
639: x_responsibility_csr OUT RESPONSIBILITY_CSR,
640: x_return_status OUT VARCHAR2,
641: x_msg_count OUT NUMBER,

Line 638: p_application_ids IN JTF_NUMBER_TABLE,

634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: p_responsibility_ids IN JTF_NUMBER_TABLE,
638: p_application_ids IN JTF_NUMBER_TABLE,
639: x_responsibility_csr OUT RESPONSIBILITY_CSR,
640: x_return_status OUT VARCHAR2,
641: x_msg_count OUT NUMBER,
642: x_msg_data OUT VARCHAR2