DBA Data[Home] [Help]

APPS.IBE_M_AUTOPLACEMENT_PVT dependencies on JTF_DATE_TABLE

Line 295: l_start_date_actives JTF_DATE_TABLE;

291: AND organization_id = c_organization_id;
292:
293: l_inventory_item_ids JTF_NUMBER_TABLE;
294: l_organization_ids JTF_NUMBER_TABLE;
295: l_start_date_actives JTF_DATE_TABLE;
296: l_end_date_actives JTF_DATE_TABLE;
297: l_sort_orders JTF_NUMBER_TABLE;
298: l_association_reason_codes JTF_VARCHAR2_TABLE_300;
299: x_section_item_ids JTF_NUMBER_TABLE;

Line 296: l_end_date_actives JTF_DATE_TABLE;

292:
293: l_inventory_item_ids JTF_NUMBER_TABLE;
294: l_organization_ids JTF_NUMBER_TABLE;
295: l_start_date_actives JTF_DATE_TABLE;
296: l_end_date_actives JTF_DATE_TABLE;
297: l_sort_orders JTF_NUMBER_TABLE;
298: l_association_reason_codes JTF_VARCHAR2_TABLE_300;
299: x_section_item_ids JTF_NUMBER_TABLE;
300: x_duplicate_association_status VARCHAR2(10);

Line 352: l_start_date_actives := JTF_DATE_TABLE();

348: printDebuglog('SQL='||l_sql);
349: -- Begin for calling associate item to section
350: l_inventory_item_ids := JTF_NUMBER_TABLE();
351: l_organization_ids := JTF_NUMBER_TABLE();
352: l_start_date_actives := JTF_DATE_TABLE();
353: l_end_date_actives := JTF_DATE_TABLE();
354: l_sort_orders := JTF_NUMBER_TABLE();
355: l_association_reason_codes := JTF_VARCHAR2_TABLE_300();
356: x_section_item_ids := JTF_NUMBER_TABLE();

Line 353: l_end_date_actives := JTF_DATE_TABLE();

349: -- Begin for calling associate item to section
350: l_inventory_item_ids := JTF_NUMBER_TABLE();
351: l_organization_ids := JTF_NUMBER_TABLE();
352: l_start_date_actives := JTF_DATE_TABLE();
353: l_end_date_actives := JTF_DATE_TABLE();
354: l_sort_orders := JTF_NUMBER_TABLE();
355: l_association_reason_codes := JTF_VARCHAR2_TABLE_300();
356: x_section_item_ids := JTF_NUMBER_TABLE();
357: l_inventory_item_ids.extend(1);