DBA Data[Home] [Help]

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on JTF_DATE_TABLE

Line 2171: p_start_date_actives IN JTF_DATE_TABLE,

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,
2175: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 2172: p_end_date_actives IN JTF_DATE_TABLE,

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,
2175: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
2176: x_duplicate_association_status OUT NOCOPY VARCHAR2,

Line 2392: p_start_date_actives IN JTF_DATE_TABLE,

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,
2396: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 2393: p_end_date_actives IN JTF_DATE_TABLE,

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,
2396: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
2397: x_duplicate_association_status OUT NOCOPY VARCHAR2,

Line 3835: p_start_date_actives IN JTF_DATE_TABLE,

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,
3839: x_return_status OUT NOCOPY VARCHAR2,

Line 3836: p_end_date_actives IN JTF_DATE_TABLE,

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,
3839: x_return_status OUT NOCOPY VARCHAR2,
3840: x_msg_count OUT NOCOPY NUMBER,

Line 4553: l_start_date_actives JTF_DATE_TABLE;

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;
4557: l_duplicate_association_status VARCHAR2(1);

Line 4554: l_end_date_actives JTF_DATE_TABLE;

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;
4557: l_duplicate_association_status VARCHAR2(1);
4558: --bug 3303424

Line 5255: l_start_date_actives := JTF_DATE_TABLE();

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();
5259:

Line 5256: l_end_date_actives := JTF_DATE_TABLE();

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();
5259:
5260: l_inventory_item_ids.EXTEND();

Line 6581: l_start_date_active_tbl JTF_DATE_TABLE;

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;
6585: l_counter NUMBER;

Line 6582: l_end_date_active_tbl JTF_DATE_TABLE;

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;
6585: l_counter NUMBER;
6586: l_section_item_id_tbl JTF_NUMBER_TABLE;

Line 6624: l_start_date_active_tbl:=JTF_DATE_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();
6628:

Line 6625: l_end_date_active_tbl:=JTF_DATE_TABLE();

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();
6628:
6629: l_inventory_item_id_tbl.extend();