DBA Data[Home] [Help]

APPS.IBE_MSITE_PRTY_ACCSS_MGR_PVT dependencies on JTF_NUMBER_TABLE

Line 39: p_party_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_party_ids IN JTF_NUMBER_TABLE,
40: p_start_date_actives IN JTF_DATE_TABLE,
41: p_end_date_actives IN JTF_DATE_TABLE,
42: x_msite_prty_accss_ids OUT NOCOPY JTF_NUMBER_TABLE,
43: x_duplicate_association_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 42: x_msite_prty_accss_ids OUT NOCOPY JTF_NUMBER_TABLE,

38: p_msite_id IN NUMBER,
39: p_party_ids IN JTF_NUMBER_TABLE,
40: p_start_date_actives IN JTF_DATE_TABLE,
41: p_end_date_actives IN JTF_DATE_TABLE,
42: x_msite_prty_accss_ids OUT NOCOPY JTF_NUMBER_TABLE,
43: x_duplicate_association_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
44: x_is_any_duplicate_status OUT NOCOPY VARCHAR2,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,

Line 85: x_msite_prty_accss_ids := JTF_NUMBER_TABLE();

81:
82: -- Check if the association already exists. Populate the
83: -- x_duplicate_association_status with the appropriate information
84: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();
85: x_msite_prty_accss_ids := JTF_NUMBER_TABLE();
86: x_is_any_duplicate_status := FND_API.G_RET_STS_SUCCESS;
87:
88: FOR i IN 1..p_party_ids.COUNT LOOP
89:

Line 194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,

190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
195: p_object_version_numbers IN JTF_NUMBER_TABLE,
196: p_msite_ids IN JTF_NUMBER_TABLE,
197: p_party_ids IN JTF_NUMBER_TABLE,
198: p_start_date_actives IN JTF_DATE_TABLE,

Line 195: p_object_version_numbers IN JTF_NUMBER_TABLE,

191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
195: p_object_version_numbers IN JTF_NUMBER_TABLE,
196: p_msite_ids IN JTF_NUMBER_TABLE,
197: p_party_ids IN JTF_NUMBER_TABLE,
198: p_start_date_actives IN JTF_DATE_TABLE,
199: p_end_date_actives IN JTF_DATE_TABLE,

Line 196: p_msite_ids IN JTF_NUMBER_TABLE,

192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
195: p_object_version_numbers IN JTF_NUMBER_TABLE,
196: p_msite_ids IN JTF_NUMBER_TABLE,
197: p_party_ids IN JTF_NUMBER_TABLE,
198: p_start_date_actives IN JTF_DATE_TABLE,
199: p_end_date_actives IN JTF_DATE_TABLE,
200: p_delete_flags IN JTF_VARCHAR2_TABLE_100,

Line 197: p_party_ids IN JTF_NUMBER_TABLE,

193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
195: p_object_version_numbers IN JTF_NUMBER_TABLE,
196: p_msite_ids IN JTF_NUMBER_TABLE,
197: p_party_ids IN JTF_NUMBER_TABLE,
198: p_start_date_actives IN JTF_DATE_TABLE,
199: p_end_date_actives IN JTF_DATE_TABLE,
200: p_delete_flags IN JTF_VARCHAR2_TABLE_100,
201: p_msite_id IN NUMBER,