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 6574: l_price_element_type_id PO_COST_MST.price_element_type_id%TYPE;

6570: l_taxauth_code TX_TAXA_MST.taxauth_code%TYPE;
6571: l_Charge_code OP_CHRG_MST.Charge_code%TYPE;
6572: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
6573: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
6574: l_price_element_type_id PO_COST_MST.price_element_type_id%TYPE;
6575: l_cost_cmpntcls_code CM_CMPT_MST.cost_cmpntcls_code%TYPE;
6576: l_Order_type_code OP_ORDR_TYP.Order_type_code%TYPE;
6577: l_Line_type_code GEM_LOOKUPS.meaning%TYPE;
6578: l_ar_trx_type_code RA_CUST_TRX_TYPES_ALL.name%TYPE;

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

8676: * PL/SQL Table Definition *
8677: **************************/
8678:
8679: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8680: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8681: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8682: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8683: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8684: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;

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

8677: **************************/
8678:
8679: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8680: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8681: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8682: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8683: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8684: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8685: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;

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

8678:
8679: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8680: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8681: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8682: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8683: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8684: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8685: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8686:

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

8679: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
8680: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8681: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8682: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8683: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8684: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8685: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8686:
8687: /******************

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

8680: TYPE t_price_element_type_id IS TABLE OF PO_COST_MST.PRICE_ELEMENT_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8681: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8682: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8683: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8684: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8685: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8686:
8687: /******************
8688: * Local Variables *

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

8681: TYPE t_aqui_cost_code IS TABLE OF PO_COST_MST.AQUI_COST_CODE%TYPE INDEX BY BINARY_INTEGER;
8682: TYPE t_aqui_cost_desc IS TABLE OF PO_COST_MST.AQUI_COST_DESC%TYPE INDEX BY BINARY_INTEGER;
8683: TYPE t_cmpntcls_id IS TABLE OF PO_COST_MST.CMPNTCLS_ID%TYPE INDEX BY BINARY_INTEGER;
8684: TYPE t_analysis_code IS TABLE OF PO_COST_MST.ANALYSIS_CODE%TYPE INDEX BY BINARY_INTEGER;
8685: TYPE t_incl_ind IS TABLE OF PO_COST_MST.INCL_IND%TYPE INDEX BY BINARY_INTEGER;
8686:
8687: /******************
8688: * Local Variables *
8689: ******************/

Line 8710: G_Table_name := 'PO_COST_MST';

8706:
8707: BEGIN
8708:
8709: G_Migration_run_id := P_migration_run_id;
8710: G_Table_name := 'PO_COST_MST';
8711: G_Context := 'Acquisiton Codes Migration';
8712: X_failure_count := 0;
8713:
8714: /********************************

Line 8741: FROM po_cost_mst

8737: l_aqui_cost_desc,
8738: l_cmpntcls_id,
8739: l_analysis_code,
8740: l_incl_ind
8741: FROM po_cost_mst
8742: WHERE price_element_type_id IS NULL;
8743:
8744: l_pricing_basis := 'PER_UNIT';
8745:

Line 8780: UPDATE po_cost_mst

8776:
8777: END LOOP;
8778:
8779: FORALL j IN indices OF l_rowid SAVE EXCEPTIONS
8780: UPDATE po_cost_mst
8781: SET migrated_ind = 1,
8782: price_element_type_id = l_price_element_type_id(j)
8783: WHERE ROWID = l_rowid(j)
8784: AND price_element_type_id IS NULL;

Line 8833: FROM po_cost_mst

8829: **********************************************/
8830:
8831: SELECT count(*)
8832: INTO x_failure_count
8833: FROM po_cost_mst
8834: WHERE price_element_type_id IS NULL;
8835:
8836: IF nvl(x_failure_count,0) > 0 THEN
8837: