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.GMF_MIGRATION dependencies on PO_COST_MST

Line 818: l_price_element_type_id po_cost_mst.price_element_type_id%TYPE;

814: IS
815: /************************
816: * Local Variables *
817: ************************/
818: l_price_element_type_id po_cost_mst.price_element_type_id%TYPE;
819: /****************
820: * Cursors *
821: ****************/
822: CURSOR cur_price_element_type_id

Line 828: FROM po_cost_mst

824: p_aqui_cost_id IN NUMBER
825: )
826: IS
827: SELECT price_element_type_id
828: FROM po_cost_mst
829: WHERE aqui_cost_id = p_aqui_cost_id
830: AND nvl(migrated_ind, 0) = 1;
831:
832: BEGIN

Line 6494: l_price_element_type_id PO_COST_MST.price_element_type_id%TYPE;

6490: l_taxauth_code TX_TAXA_MST.taxauth_code%TYPE;
6491: l_Charge_code OP_CHRG_MST.Charge_code%TYPE;
6492: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
6493: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
6494: l_price_element_type_id PO_COST_MST.price_element_type_id%TYPE;
6495: l_cost_cmpntcls_code CM_CMPT_MST.cost_cmpntcls_code%TYPE;
6496: l_Order_type_code OP_ORDR_TYP.Order_type_code%TYPE;
6497: l_Line_type_code GEM_LOOKUPS.meaning%TYPE;
6498: l_ar_trx_type_code RA_CUST_TRX_TYPES_ALL.name%TYPE;

Line 8592: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

8588: * PL/SQL Table Definition *
8589: **************************/
8590:
8591: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8592: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8593: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8594: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8595: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8596: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 8593: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;

8589: **************************/
8590:
8591: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8592: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8593: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8594: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8595: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8596: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8597: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;

Line 8594: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;

8590:
8591: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8592: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8593: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8594: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8595: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8596: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8597: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8598:

Line 8595: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;

8591: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8592: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8593: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8594: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8595: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8596: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8597: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8598:
8599: /******************

Line 8596: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;

8592: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8593: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8594: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8595: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8596: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8597: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8598:
8599: /******************
8600: * Local Variables *

Line 8597: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;

8593: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8594: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8595: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8596: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8597: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8598:
8599: /******************
8600: * Local Variables *
8601: ******************/

Line 8622: G_Table_name := 'PO_COST_MST';

8618:
8619: BEGIN
8620:
8621: G_Migration_run_id := P_migration_run_id;
8622: G_Table_name := 'PO_COST_MST';
8623: G_Context := 'Acquisiton Codes Migration';
8624: X_failure_count := 0;
8625:
8626: /********************************

Line 8653: FROM po_cost_mst

8649: l_aqui_cost_desc,
8650: l_cmpntcls_id,
8651: l_analysis_code,
8652: l_incl_ind
8653: FROM po_cost_mst
8654: WHERE price_element_type_id IS NULL;
8655:
8656: l_pricing_basis := 'PER_UNIT';
8657:

Line 8692: UPDATE po_cost_mst

8688:
8689: END LOOP;
8690:
8691: FORALL j IN indices OF l_rowid SAVE EXCEPTIONS
8692: UPDATE po_cost_mst
8693: SET migrated_ind = 1,
8694: price_element_type_id = l_price_element_type_id(j)
8695: WHERE ROWID = l_rowid(j)
8696: AND price_element_type_id IS NULL;

Line 8745: FROM po_cost_mst

8741: **********************************************/
8742:
8743: SELECT count(*)
8744: INTO x_failure_count
8745: FROM po_cost_mst
8746: WHERE price_element_type_id IS NULL;
8747:
8748: IF nvl(x_failure_count,0) > 0 THEN
8749: