DBA Data[Home] [Help]

APPS.JTF_MSITE_PRTY_ACCSS_MGR_PVT dependencies on JTF_NUMBER_TABLE

Line 36: p_party_ids IN JTF_NUMBER_TABLE,

32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: p_msite_id IN NUMBER,
36: p_party_ids IN JTF_NUMBER_TABLE,
37: p_start_date_actives IN JTF_DATE_TABLE,
38: p_end_date_actives IN JTF_DATE_TABLE,
39: x_msite_prty_accss_ids OUT JTF_NUMBER_TABLE,
40: x_duplicate_association_status OUT JTF_VARCHAR2_TABLE_100,

Line 39: x_msite_prty_accss_ids OUT JTF_NUMBER_TABLE,

35: p_msite_id IN NUMBER,
36: p_party_ids IN JTF_NUMBER_TABLE,
37: p_start_date_actives IN JTF_DATE_TABLE,
38: p_end_date_actives IN JTF_DATE_TABLE,
39: x_msite_prty_accss_ids OUT JTF_NUMBER_TABLE,
40: x_duplicate_association_status OUT JTF_VARCHAR2_TABLE_100,
41: x_is_any_duplicate_status OUT VARCHAR2,
42: x_return_status OUT VARCHAR2,
43: x_msg_count OUT NUMBER,

Line 82: x_msite_prty_accss_ids := JTF_NUMBER_TABLE();

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

Line 191: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,

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

Line 192: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

Line 193: p_msite_ids IN JTF_NUMBER_TABLE,

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

Line 194: p_party_ids IN JTF_NUMBER_TABLE,

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

Line 623: p_party_ids IN JTF_NUMBER_TABLE,

619: p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
621: p_commit IN VARCHAR2 := FND_API.G_FALSE,
622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
623: p_party_ids IN JTF_NUMBER_TABLE,
624: x_party_csr OUT PARTY_CSR,
625: x_cust_account_csr OUT CUST_ACCOUNT_CSR,
626: x_return_status OUT VARCHAR2,
627: x_msg_count OUT NUMBER,