APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 2174: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,

2170: p_organization_ids IN JTF_NUMBER_TABLE,
2171: p_start_date_actives IN JTF_DATE_TABLE,
2172: p_end_date_actives IN JTF_DATE_TABLE,
2173: p_sort_orders IN JTF_NUMBER_TABLE,
2174: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
2175: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
2176: x_duplicate_association_status OUT NOCOPY VARCHAR2,
2177: x_return_status OUT NOCOPY VARCHAR2,
2178: x_msg_count OUT NOCOPY NUMBER,

Line 2192: l_duplicate_flags JTF_VARCHAR2_TABLE_300;

2188: l_section_id NUMBER;
2189: l_mini_site_id NUMBER;
2190: l_mini_site_section_item_id NUMBER;
2191: l_tmp_section_item_id NUMBER;
2192: l_duplicate_flags JTF_VARCHAR2_TABLE_300;
2193:
2194: -- get all the mini-sites to which the section belongs to except the
2195: -- master mini-site(s)
2196: CURSOR c1(l_c_section_id IN NUMBER)

Line 2236: l_duplicate_flags := JTF_VARCHAR2_TABLE_300();

2232: x_duplicate_association_status := FND_API.G_RET_STS_SUCCESS;
2233:
2234: -- todo optimize using FORALL and BIND COLLECT
2235: x_section_item_ids := JTF_NUMBER_TABLE();
2236: l_duplicate_flags := JTF_VARCHAR2_TABLE_300();
2237: FOR i IN 1..p_inventory_item_ids.COUNT LOOP
2238:
2239: x_section_item_ids.EXTEND();
2240: l_duplicate_flags.EXTEND();

Line 2395: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,

2391: p_section_ids IN JTF_NUMBER_TABLE,
2392: p_start_date_actives IN JTF_DATE_TABLE,
2393: p_end_date_actives IN JTF_DATE_TABLE,
2394: p_sort_orders IN JTF_NUMBER_TABLE,
2395: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
2396: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
2397: x_duplicate_association_status OUT NOCOPY VARCHAR2,
2398: x_return_status OUT NOCOPY VARCHAR2,
2399: x_msg_count OUT NOCOPY NUMBER,

Line 3838: p_delete_flags IN JTF_VARCHAR2_TABLE_300,

3834: p_object_version_numbers IN JTF_NUMBER_TABLE,
3835: p_start_date_actives IN JTF_DATE_TABLE,
3836: p_end_date_actives IN JTF_DATE_TABLE,
3837: p_sort_orders IN JTF_NUMBER_TABLE,
3838: p_delete_flags IN JTF_VARCHAR2_TABLE_300,
3839: x_return_status OUT NOCOPY VARCHAR2,
3840: x_msg_count OUT NOCOPY NUMBER,
3841: x_msg_data OUT NOCOPY VARCHAR2
3842: )

Line 4556: l_association_reason_codes JTF_VARCHAR2_TABLE_300;

4552: l_organization_ids JTF_NUMBER_TABLE;
4553: l_start_date_actives JTF_DATE_TABLE;
4554: l_end_date_actives JTF_DATE_TABLE;
4555: l_sort_orders JTF_NUMBER_TABLE;
4556: l_association_reason_codes JTF_VARCHAR2_TABLE_300;
4557: l_duplicate_association_status VARCHAR2(1);
4558: --bug 3303424
4559: l_count_langs NUMBER;
4560: l_debug VARCHAR2(1);

Line 5258: l_association_reason_codes := JTF_VARCHAR2_TABLE_300();

5254: l_organization_ids := JTF_NUMBER_TABLE();
5255: l_start_date_actives := JTF_DATE_TABLE();
5256: l_end_date_actives := JTF_DATE_TABLE();
5257: l_sort_orders := JTF_NUMBER_TABLE();
5258: l_association_reason_codes := JTF_VARCHAR2_TABLE_300();
5259:
5260: l_inventory_item_ids.EXTEND();
5261: l_organization_ids.EXTEND();
5262: l_start_date_actives.EXTEND();

Line 6584: l_association_reason_code_tbl JTF_VARCHAR2_TABLE_300;

6580: l_organization_id_tbl JTF_NUMBER_TABLE;
6581: l_start_date_active_tbl JTF_DATE_TABLE;
6582: l_end_date_active_tbl JTF_DATE_TABLE;
6583: l_sort_order_tbl JTF_NUMBER_TABLE;
6584: l_association_reason_code_tbl JTF_VARCHAR2_TABLE_300;
6585: l_counter NUMBER;
6586: l_section_item_id_tbl JTF_NUMBER_TABLE;
6587: l_overall_return_status VARCHAR2(1);
6588: l_duplicate_association_status VARCHAR2(1);

Line 6627: l_association_reason_code_tbl:=JTF_VARCHAR2_TABLE_300();

6623: l_organization_id_tbl:=JTF_NUMBER_TABLE();
6624: l_start_date_active_tbl:=JTF_DATE_TABLE();
6625: l_end_date_active_tbl:=JTF_DATE_TABLE();
6626: l_sort_order_tbl:=JTF_NUMBER_TABLE();
6627: l_association_reason_code_tbl:=JTF_VARCHAR2_TABLE_300();
6628:
6629: l_inventory_item_id_tbl.extend();
6630: l_organization_id_tbl.extend();
6631: l_start_date_active_tbl.extend();