DBA Data[Home] [Help]

APPS.JTF_MSITE_PRTY_ACCSS_MGR_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 40: x_duplicate_association_status OUT JTF_VARCHAR2_TABLE_100,

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,
44: x_msg_data OUT VARCHAR2

Line 81: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();

77: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 197: p_delete_flags IN JTF_VARCHAR2_TABLE_100,

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,
199: p_party_access_code IN VARCHAR2,
200: x_return_status OUT VARCHAR2,
201: x_msg_count OUT NUMBER,