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_M_AUTOPLACEMENT_PVT dependencies on JTF_NUMBER_TABLE

Line 293: l_inventory_item_ids JTF_NUMBER_TABLE;

289: WHERE section_id = c_section_id
290: AND inventory_item_id = c_item_id
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;

Line 294: l_organization_ids JTF_NUMBER_TABLE;

290: AND inventory_item_id = c_item_id
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;

Line 297: l_sort_orders JTF_NUMBER_TABLE;

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);
301:

Line 299: x_section_item_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);
301:
302: l_master_mini_site_id NUMBER;
303: l_master_root_section_id NUMBER;

Line 350: l_inventory_item_ids := JTF_NUMBER_TABLE();

346: ''''||'PUBLISHED'||''''||','||''''||'UNPUBLISHED'||''''||')';
347: END IF;
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();

Line 351: l_organization_ids := JTF_NUMBER_TABLE();

347: END IF;
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();

Line 354: l_sort_orders := JTF_NUMBER_TABLE();

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);
358: l_organization_ids.extend(1);

Line 356: x_section_item_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);
358: l_organization_ids.extend(1);
359: l_start_date_actives.extend(1);
360: l_end_date_actives.extend(1);