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.QP_ARCHIVE_ENTITY_PVT dependencies on QP_ARCH_CRITERIA_HEADERS

Line 77: insert into QP_ARCH_CRITERIA_HEADERS

73: )
74: IS
75: BEGIN
76:
77: insert into QP_ARCH_CRITERIA_HEADERS
78: (REQUEST_ID,
79: REQUEST_NAME,
80: REQUEST_TYPE,
81: SOURCE_SYSTEM,

Line 2460: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES

2456:
2457: errbuf := '';
2458: retcode := 0;
2459:
2460: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
2461: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2462: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2463: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'S');
2464: ELSE

Line 2471: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES

2467:
2468: errbuf := 'Few lines matching the criteria were not Archived';
2469: retcode := 0;
2470:
2471: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
2472: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2473: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2474: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'S');
2475: END IF; --l_err_count

Line 2485: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES

2481:
2482: errbuf := 'No Data Found - 0 Records Archived';
2483: retcode := 1;
2484:
2485: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
2486: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2487: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2488: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'W');
2489: WHEN OTHERS THEN

Line 2495: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES

2491: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2492:
2493: retcode := 2;
2494:
2495: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
2496: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2497: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2498: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'F');
2499: END ARCHIVE_ENTITY;