eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on JTF_NUMBER_TABLE

Line 2169: p_inventory_item_ids IN JTF_NUMBER_TABLE,

2165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2168: p_section_id IN NUMBER,
2169: p_inventory_item_ids IN JTF_NUMBER_TABLE,
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,

Line 2170: p_organization_ids IN JTF_NUMBER_TABLE,

2166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2168: p_section_id IN NUMBER,
2169: p_inventory_item_ids IN JTF_NUMBER_TABLE,
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,

Line 2173: p_sort_orders IN JTF_NUMBER_TABLE,

2169: p_inventory_item_ids IN JTF_NUMBER_TABLE,
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,

Line 2175: x_section_item_ids OUT NOCOPY 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,
2179: x_msg_data OUT NOCOPY VARCHAR2

Line 2235: x_section_item_ids := JTF_NUMBER_TABLE();

2231: x_return_status := FND_API.G_RET_STS_SUCCESS;
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();

Line 2391: p_section_ids IN JTF_NUMBER_TABLE,

2387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2389: p_inventory_item_id IN NUMBER,
2390: p_organization_id IN NUMBER,
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,

Line 2394: p_sort_orders IN JTF_NUMBER_TABLE,

2390: p_organization_id IN NUMBER,
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,

Line 2396: x_section_item_ids OUT NOCOPY 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,
2400: x_msg_data OUT NOCOPY VARCHAR2

Line 2455: x_section_item_ids := JTF_NUMBER_TABLE();

2451: x_return_status := FND_API.G_RET_STS_SUCCESS;
2452: x_duplicate_association_status := FND_API.G_RET_STS_SUCCESS;
2453:
2454: -- todo optimize using FORALL and BIND COLLECT
2455: x_section_item_ids := JTF_NUMBER_TABLE();
2456: FOR i IN 1..p_section_ids.COUNT LOOP
2457:
2458: x_section_item_ids.EXTEND();
2459:

Line 2600: p_section_ids IN JTF_NUMBER_TABLE,

2596: p_api_version IN NUMBER,
2597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2600: p_section_ids IN JTF_NUMBER_TABLE,
2601: p_inventory_item_ids IN JTF_NUMBER_TABLE,
2602: p_organization_ids IN JTF_NUMBER_TABLE,
2603: x_return_status OUT NOCOPY VARCHAR2,
2604: x_msg_count OUT NOCOPY NUMBER,

Line 2601: p_inventory_item_ids IN JTF_NUMBER_TABLE,

2597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2600: p_section_ids IN JTF_NUMBER_TABLE,
2601: p_inventory_item_ids IN JTF_NUMBER_TABLE,
2602: p_organization_ids IN JTF_NUMBER_TABLE,
2603: x_return_status OUT NOCOPY VARCHAR2,
2604: x_msg_count OUT NOCOPY NUMBER,
2605: x_msg_data OUT NOCOPY VARCHAR2

Line 2602: p_organization_ids IN JTF_NUMBER_TABLE,

2598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2600: p_section_ids IN JTF_NUMBER_TABLE,
2601: p_inventory_item_ids IN JTF_NUMBER_TABLE,
2602: p_organization_ids IN JTF_NUMBER_TABLE,
2603: x_return_status OUT NOCOPY VARCHAR2,
2604: x_msg_count OUT NOCOPY NUMBER,
2605: x_msg_data OUT NOCOPY VARCHAR2
2606: )

Line 2729: p_section_item_ids IN JTF_NUMBER_TABLE,

2725: p_api_version IN NUMBER,
2726: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2727: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2729: p_section_item_ids IN JTF_NUMBER_TABLE,
2730: x_return_status OUT NOCOPY VARCHAR2,
2731: x_msg_count OUT NOCOPY NUMBER,
2732: x_msg_data OUT NOCOPY VARCHAR2
2733: )

Line 2858: p_mini_site_ids IN JTF_NUMBER_TABLE,

2854: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2855: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2857: p_section_id IN NUMBER,
2858: p_mini_site_ids IN JTF_NUMBER_TABLE,
2859: x_return_status OUT NOCOPY VARCHAR2,
2860: x_msg_count OUT NOCOPY NUMBER,
2861: x_msg_data OUT NOCOPY VARCHAR2
2862: )

Line 2877: l_parent_mini_site_ids JTF_NUMBER_TABLE;

2873: l_master_mini_site_id NUMBER;
2874: l_master_root_section_id NUMBER;
2875: l_mini_site_section_section_id NUMBER;
2876: l_mini_site_section_item_id NUMBER;
2877: l_parent_mini_site_ids JTF_NUMBER_TABLE;
2878: l_root_mini_site_ids JTF_NUMBER_TABLE;
2879: l_old_mini_site_ids JTF_NUMBER_TABLE;
2880:
2881: --

Line 2878: l_root_mini_site_ids JTF_NUMBER_TABLE;

2874: l_master_root_section_id NUMBER;
2875: l_mini_site_section_section_id NUMBER;
2876: l_mini_site_section_item_id NUMBER;
2877: l_parent_mini_site_ids JTF_NUMBER_TABLE;
2878: l_root_mini_site_ids JTF_NUMBER_TABLE;
2879: l_old_mini_site_ids JTF_NUMBER_TABLE;
2880:
2881: --
2882: -- Get the mini-sites to which the parent of l_c_child_section_id belongs to

Line 2879: l_old_mini_site_ids JTF_NUMBER_TABLE;

2875: l_mini_site_section_section_id NUMBER;
2876: l_mini_site_section_item_id NUMBER;
2877: l_parent_mini_site_ids JTF_NUMBER_TABLE;
2878: l_root_mini_site_ids JTF_NUMBER_TABLE;
2879: l_old_mini_site_ids JTF_NUMBER_TABLE;
2880:
2881: --
2882: -- Get the mini-sites to which the parent of l_c_child_section_id belongs to
2883: -- and which does not include master mini-site id

Line 3035: l_parent_mini_site_ids := JTF_NUMBER_TABLE();

3031: -- Get the list of mini-sites to which the parent section (of p_section_id)
3032: -- belongs to
3033: --
3034: l_counter := 1;
3035: l_parent_mini_site_ids := JTF_NUMBER_TABLE();
3036: FOR r1 IN c1(p_section_id, l_master_mini_site_id) LOOP
3037: l_parent_mini_site_ids.EXTEND();
3038: l_parent_mini_site_ids(l_counter) := r1.mini_site_id;
3039: l_counter := l_counter + 1;

Line 3048: l_root_mini_site_ids := JTF_NUMBER_TABLE();

3044: -- (p_section_id) is the root section. This will be used later in processing
3045: -- logic
3046: --
3047: l_counter := 1;
3048: l_root_mini_site_ids := JTF_NUMBER_TABLE();
3049: FOR r6 IN c6(p_section_id) LOOP
3050: l_root_mini_site_ids.EXTEND();
3051: l_root_mini_site_ids(l_counter) := r6.msite_id;
3052: l_counter := l_counter + 1;

Line 3102: l_old_mini_site_ids := JTF_NUMBER_TABLE();

3098: --
3099: -- Find the old mini-sites to which the p_section_id belongs
3100: --
3101: l_counter := 1;
3102: l_old_mini_site_ids := JTF_NUMBER_TABLE();
3103: FOR r2 IN c2(p_section_id, l_master_mini_site_id) LOOP
3104: l_old_mini_site_ids.EXTEND();
3105: l_old_mini_site_ids(l_counter) := r2.mini_site_id;
3106: l_counter := l_counter + 1;

Line 3653: p_mini_site_ids IN JTF_NUMBER_TABLE,

3649: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3651: p_inventory_item_id IN NUMBER,
3652: p_organization_id IN NUMBER,
3653: p_mini_site_ids IN JTF_NUMBER_TABLE,
3654: x_return_status OUT NOCOPY VARCHAR2,
3655: x_msg_count OUT NOCOPY NUMBER,
3656: x_msg_data OUT NOCOPY VARCHAR2
3657: )

Line 3672: l_parent_mini_site_ids JTF_NUMBER_TABLE;

3668: l_master_mini_site_id NUMBER;
3669: l_master_root_section_id NUMBER;
3670: l_mini_site_section_section_id NUMBER;
3671: l_mini_site_section_item_id NUMBER;
3672: l_parent_mini_site_ids JTF_NUMBER_TABLE;
3673: l_root_mini_site_ids JTF_NUMBER_TABLE;
3674: l_old_mini_site_ids JTF_NUMBER_TABLE;
3675:
3676: --

Line 3673: l_root_mini_site_ids JTF_NUMBER_TABLE;

3669: l_master_root_section_id NUMBER;
3670: l_mini_site_section_section_id NUMBER;
3671: l_mini_site_section_item_id NUMBER;
3672: l_parent_mini_site_ids JTF_NUMBER_TABLE;
3673: l_root_mini_site_ids JTF_NUMBER_TABLE;
3674: l_old_mini_site_ids JTF_NUMBER_TABLE;
3675:
3676: --
3677: -- Get the mini-sites to which the parent of (l_c_inventory_item_id,

Line 3674: l_old_mini_site_ids JTF_NUMBER_TABLE;

3670: l_mini_site_section_section_id NUMBER;
3671: l_mini_site_section_item_id NUMBER;
3672: l_parent_mini_site_ids JTF_NUMBER_TABLE;
3673: l_root_mini_site_ids JTF_NUMBER_TABLE;
3674: l_old_mini_site_ids JTF_NUMBER_TABLE;
3675:
3676: --
3677: -- Get the mini-sites to which the parent of (l_c_inventory_item_id,
3678: -- organization_id) belongs to and which does not include master mini-site id

Line 3833: p_msite_section_section_ids IN JTF_NUMBER_TABLE,

3829: p_api_version IN NUMBER,
3830: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3831: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3833: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
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,

Line 3834: p_object_version_numbers IN JTF_NUMBER_TABLE,

3830: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3831: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3833: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
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,

Line 3837: p_sort_orders IN JTF_NUMBER_TABLE,

3833: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
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

Line 4124: l_mini_site_ids JTF_NUMBER_TABLE;

4120: l_section_item_id NUMBER;
4121: l_tmp_id NUMBER;
4122: l_level_number NUMBER;
4123: l_counter NUMBER;
4124: l_mini_site_ids JTF_NUMBER_TABLE;
4125: l_section_type_code VARCHAR2(30);
4126: l_concat_ids VARCHAR2(2000);
4127:
4128:

Line 4378: l_mini_site_ids := JTF_NUMBER_TABLE();

4374:
4375: -- For each mini-site associated with parent of r33.child_section_id
4376: -- and with r33.child_section_id (thru ibe_msites_b)
4377: l_counter := 1;
4378: l_mini_site_ids := JTF_NUMBER_TABLE();
4379: FOR r4 IN c4(r33.child_section_id, l_master_mini_site_id) LOOP
4380: l_mini_site_ids.EXTEND();
4381: l_mini_site_ids(l_counter) := r4.mini_site_id;
4382: l_counter := l_counter + 1;

Line 4550: l_section_item_ids JTF_NUMBER_TABLE;

4546: l_section_id NUMBER;
4547: l_parent_section_id NUMBER;
4548: l_found BOOLEAN;
4549: l_section_map_list SECTION_MAP_LIST;
4550: l_section_item_ids JTF_NUMBER_TABLE;
4551: l_inventory_item_ids JTF_NUMBER_TABLE;
4552: l_organization_ids JTF_NUMBER_TABLE;
4553: l_start_date_actives JTF_DATE_TABLE;
4554: l_end_date_actives JTF_DATE_TABLE;

Line 4551: l_inventory_item_ids JTF_NUMBER_TABLE;

4547: l_parent_section_id NUMBER;
4548: l_found BOOLEAN;
4549: l_section_map_list SECTION_MAP_LIST;
4550: l_section_item_ids JTF_NUMBER_TABLE;
4551: l_inventory_item_ids JTF_NUMBER_TABLE;
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;

Line 4552: l_organization_ids JTF_NUMBER_TABLE;

4548: l_found BOOLEAN;
4549: l_section_map_list SECTION_MAP_LIST;
4550: l_section_item_ids JTF_NUMBER_TABLE;
4551: l_inventory_item_ids JTF_NUMBER_TABLE;
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;

Line 4555: l_sort_orders JTF_NUMBER_TABLE;

4551: l_inventory_item_ids JTF_NUMBER_TABLE;
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;

Line 5253: l_inventory_item_ids := JTF_NUMBER_TABLE();

5249: FND_MSG_PUB.Add;
5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: END IF;
5252:
5253: l_inventory_item_ids := JTF_NUMBER_TABLE();
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();

Line 5254: l_organization_ids := JTF_NUMBER_TABLE();

5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: END IF;
5252:
5253: l_inventory_item_ids := JTF_NUMBER_TABLE();
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();

Line 5257: l_sort_orders := JTF_NUMBER_TABLE();

5253: l_inventory_item_ids := JTF_NUMBER_TABLE();
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();

Line 5826: l_section_ids JTF_NUMBER_TABLE ;

5822: AND mini_site_id = c_master_mini_site_id;
5823:
5824: l_master_minisite_id NUMBER;
5825: l_root_section_id NUMBER;
5826: l_section_ids JTF_NUMBER_TABLE ;
5827: l_layout_comp_ids JTF_NUMBER_TABLE;
5828: BEGIN
5829: l_section_ids := JTF_NUMBER_TABLE();
5830: l_layout_comp_ids := JTF_NUMBER_TABLE();

Line 5827: l_layout_comp_ids JTF_NUMBER_TABLE;

5823:
5824: l_master_minisite_id NUMBER;
5825: l_root_section_id NUMBER;
5826: l_section_ids JTF_NUMBER_TABLE ;
5827: l_layout_comp_ids JTF_NUMBER_TABLE;
5828: BEGIN
5829: l_section_ids := JTF_NUMBER_TABLE();
5830: l_layout_comp_ids := JTF_NUMBER_TABLE();
5831: if p_enable_trace_flag = 'Y' then

Line 5829: l_section_ids := JTF_NUMBER_TABLE();

5825: l_root_section_id NUMBER;
5826: l_section_ids JTF_NUMBER_TABLE ;
5827: l_layout_comp_ids JTF_NUMBER_TABLE;
5828: BEGIN
5829: l_section_ids := JTF_NUMBER_TABLE();
5830: l_layout_comp_ids := JTF_NUMBER_TABLE();
5831: if p_enable_trace_flag = 'Y' then
5832: G_ENABLE_TRACE := 'Y';
5833: end if;

Line 5830: l_layout_comp_ids := JTF_NUMBER_TABLE();

5826: l_section_ids JTF_NUMBER_TABLE ;
5827: l_layout_comp_ids JTF_NUMBER_TABLE;
5828: BEGIN
5829: l_section_ids := JTF_NUMBER_TABLE();
5830: l_layout_comp_ids := JTF_NUMBER_TABLE();
5831: if p_enable_trace_flag = 'Y' then
5832: G_ENABLE_TRACE := 'Y';
5833: end if;
5834:

Line 5883: x_section_ids IN OUT NOCOPY JTF_NUMBER_TABLE,

5879: p_target_section_id IN NUMBER,
5880: x_return_status OUT NOCOPY VARCHAR2,
5881: x_msg_count OUT NOCOPY NUMBER,
5882: x_msg_data OUT NOCOPY VARCHAR2,
5883: x_section_ids IN OUT NOCOPY JTF_NUMBER_TABLE,
5884: x_layout_comp_ids IN OUT NOCOPY JTF_NUMBER_TABLE)
5885: IS
5886: l_api_name CONSTANT VARCHAR2(30) := 'cascade_layout_comp_mapping';
5887: l_api_version CONSTANT NUMBER := 1.0;

Line 5884: x_layout_comp_ids IN OUT NOCOPY JTF_NUMBER_TABLE)

5880: x_return_status OUT NOCOPY VARCHAR2,
5881: x_msg_count OUT NOCOPY NUMBER,
5882: x_msg_data OUT NOCOPY VARCHAR2,
5883: x_section_ids IN OUT NOCOPY JTF_NUMBER_TABLE,
5884: x_layout_comp_ids IN OUT NOCOPY JTF_NUMBER_TABLE)
5885: IS
5886: l_api_name CONSTANT VARCHAR2(30) := 'cascade_layout_comp_mapping';
5887: l_api_version CONSTANT NUMBER := 1.0;
5888: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 6073: p_layout_comp_id IN JTF_NUMBER_TABLE,

6069: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6070: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6071: p_section_id IN NUMBER,
6072: p_layout_id IN NUMBER,
6073: p_layout_comp_id IN JTF_NUMBER_TABLE,
6074: p_layout_temp_id IN JTF_NUMBER_TABLE,
6075: p_object_versions IN JTF_NUMBER_TABLE,
6076: p_actionflags IN JTF_VARCHAR2_TABLE_100,
6077: p_cascading_flag IN NUMBER := 0,

Line 6074: p_layout_temp_id IN JTF_NUMBER_TABLE,

6070: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6071: p_section_id IN NUMBER,
6072: p_layout_id IN NUMBER,
6073: p_layout_comp_id IN JTF_NUMBER_TABLE,
6074: p_layout_temp_id IN JTF_NUMBER_TABLE,
6075: p_object_versions IN JTF_NUMBER_TABLE,
6076: p_actionflags IN JTF_VARCHAR2_TABLE_100,
6077: p_cascading_flag IN NUMBER := 0,
6078: x_return_status OUT NOCOPY VARCHAR2,

Line 6075: p_object_versions IN JTF_NUMBER_TABLE,

6071: p_section_id IN NUMBER,
6072: p_layout_id IN NUMBER,
6073: p_layout_comp_id IN JTF_NUMBER_TABLE,
6074: p_layout_temp_id IN JTF_NUMBER_TABLE,
6075: p_object_versions IN JTF_NUMBER_TABLE,
6076: p_actionflags IN JTF_VARCHAR2_TABLE_100,
6077: p_cascading_flag IN NUMBER := 0,
6078: x_return_status OUT NOCOPY VARCHAR2,
6079: x_msg_count OUT NOCOPY NUMBER,

Line 6081: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,

6077: p_cascading_flag IN NUMBER := 0,
6078: x_return_status OUT NOCOPY VARCHAR2,
6079: x_msg_count OUT NOCOPY NUMBER,
6080: x_msg_data OUT NOCOPY VARCHAR2,
6081: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
6082: x_layout_comp_ids OUT NOCOPY JTF_NUMBER_TABLE)
6083: IS
6084: l_api_name CONSTANT VARCHAR2(30) := 'Update_Hierarchy_Layout_Map';
6085: l_api_version CONSTANT NUMBER := 1.0;

Line 6082: x_layout_comp_ids OUT NOCOPY JTF_NUMBER_TABLE)

6078: x_return_status OUT NOCOPY VARCHAR2,
6079: x_msg_count OUT NOCOPY NUMBER,
6080: x_msg_data OUT NOCOPY VARCHAR2,
6081: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
6082: x_layout_comp_ids OUT NOCOPY JTF_NUMBER_TABLE)
6083: IS
6084: l_api_name CONSTANT VARCHAR2(30) := 'Update_Hierarchy_Layout_Map';
6085: l_api_version CONSTANT NUMBER := 1.0;
6086: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 6169: x_section_ids := JTF_NUMBER_TABLE();

6165: IF (l_debug = 'Y') THEN
6166: IBE_UTIL.debug('new deliverable id:'||l_new_deliverable_id);
6167: IBE_UTIL.debug('new layout type:'||l_new_layout_type);
6168: END IF;
6169: x_section_ids := JTF_NUMBER_TABLE();
6170: x_layout_comp_ids := JTF_NUMBER_TABLE();
6171: -- dbms_output.put_line('layout type:'||l_new_layout_type);
6172: -- New layout is associated with section
6173: IF (l_new_layout_type = 'C') THEN

Line 6170: x_layout_comp_ids := JTF_NUMBER_TABLE();

6166: IBE_UTIL.debug('new deliverable id:'||l_new_deliverable_id);
6167: IBE_UTIL.debug('new layout type:'||l_new_layout_type);
6168: END IF;
6169: x_section_ids := JTF_NUMBER_TABLE();
6170: x_layout_comp_ids := JTF_NUMBER_TABLE();
6171: -- dbms_output.put_line('layout type:'||l_new_layout_type);
6172: -- New layout is associated with section
6173: IF (l_new_layout_type = 'C') THEN
6174: IF (l_debug = 'Y') THEN

Line 6177: -- x_section_ids := JTF_NUMBER_TABLE();

6173: IF (l_new_layout_type = 'C') THEN
6174: IF (l_debug = 'Y') THEN
6175: IBE_UTIL.debug('Updating section deliverable id');
6176: END IF;
6177: -- x_section_ids := JTF_NUMBER_TABLE();
6178: -- x_layout_comp_ids := JTF_NUMBER_TABLE();
6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');
6180: UPDATE ibe_dsp_sections_b
6181: SET deliverable_id = l_new_deliverable_id,

Line 6178: -- x_layout_comp_ids := JTF_NUMBER_TABLE();

6174: IF (l_debug = 'Y') THEN
6175: IBE_UTIL.debug('Updating section deliverable id');
6176: END IF;
6177: -- x_section_ids := JTF_NUMBER_TABLE();
6178: -- x_layout_comp_ids := JTF_NUMBER_TABLE();
6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');
6180: UPDATE ibe_dsp_sections_b
6181: SET deliverable_id = l_new_deliverable_id,
6182: last_update_date = SYSDATE,

Line 6578: l_section_id_tbl JTF_NUMBER_TABLE;

6574:
6575: l_api_name CONSTANT VARCHAR2(30) :=
6576: 'Associate_Items_To_Section';
6577: l_api_version CONSTANT NUMBER := 1.0;
6578: l_section_id_tbl JTF_NUMBER_TABLE;
6579: l_inventory_item_id_tbl JTF_NUMBER_TABLE;
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;

Line 6579: l_inventory_item_id_tbl JTF_NUMBER_TABLE;

6575: l_api_name CONSTANT VARCHAR2(30) :=
6576: 'Associate_Items_To_Section';
6577: l_api_version CONSTANT NUMBER := 1.0;
6578: l_section_id_tbl JTF_NUMBER_TABLE;
6579: l_inventory_item_id_tbl JTF_NUMBER_TABLE;
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;

Line 6580: l_organization_id_tbl JTF_NUMBER_TABLE;

6576: 'Associate_Items_To_Section';
6577: l_api_version CONSTANT NUMBER := 1.0;
6578: l_section_id_tbl JTF_NUMBER_TABLE;
6579: l_inventory_item_id_tbl JTF_NUMBER_TABLE;
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;

Line 6583: l_sort_order_tbl JTF_NUMBER_TABLE;

6579: l_inventory_item_id_tbl JTF_NUMBER_TABLE;
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);

Line 6586: l_section_item_id_tbl JTF_NUMBER_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);
6589: l_debug VARCHAR2(1);
6590: BEGIN

Line 6621: -- initialize the jtf number table variables

6617:
6618: -- call to IBE_DSP_HIERARCHY_SETUP_PVT.Associate_Items_To_Section API
6619: -- requires passing the parameters as JTF_xxxx_TABLE
6620:
6621: -- initialize the jtf number table variables
6622: l_inventory_item_id_tbl:=JTF_NUMBER_TABLE();
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();

Line 6622: l_inventory_item_id_tbl:=JTF_NUMBER_TABLE();

6618: -- call to IBE_DSP_HIERARCHY_SETUP_PVT.Associate_Items_To_Section API
6619: -- requires passing the parameters as JTF_xxxx_TABLE
6620:
6621: -- initialize the jtf number table variables
6622: l_inventory_item_id_tbl:=JTF_NUMBER_TABLE();
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();

Line 6623: l_organization_id_tbl:=JTF_NUMBER_TABLE();

6619: -- requires passing the parameters as JTF_xxxx_TABLE
6620:
6621: -- initialize the jtf number table variables
6622: l_inventory_item_id_tbl:=JTF_NUMBER_TABLE();
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();

Line 6626: l_sort_order_tbl:=JTF_NUMBER_TABLE();

6622: l_inventory_item_id_tbl:=JTF_NUMBER_TABLE();
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();

Line 6636: -- convert to JTF NUMBER TABLE

6632: l_end_date_active_tbl.extend();
6633: l_sort_order_tbl.extend();
6634: l_association_reason_code_tbl.extend();
6635:
6636: -- convert to JTF NUMBER TABLE
6637: l_counter:=1;
6638: FOR l_counter in 1..p_section_item_tbl.count LOOP
6639: l_inventory_item_id_tbl(1):=p_section_item_tbl(l_counter).inventory_item_id;
6640: l_organization_id_tbl(1):=p_section_item_tbl(l_counter).organization_id;