APPS.MTH_UDA_PKG dependencies on STANDARD

Line 76: PROCEDURE NTB_UPLOAD_STANDARD_WHO(P_EXT_TBL_NAME IN VARCHAR2, P_EXTENSION_ID IN NUMBER, P_IF_ROW_EXISTS IN NUMBER) IS

72:
73: END;
74: -- End of UPDATE_TO_PRIMARY_KEY;
75:
76: PROCEDURE NTB_UPLOAD_STANDARD_WHO(P_EXT_TBL_NAME IN VARCHAR2, P_EXTENSION_ID IN NUMBER, P_IF_ROW_EXISTS IN NUMBER) IS
77: --initialize variables here
78: l_updated_by NUMBER := 15;
79: l_last_update_login NUMBER := 15;
80: v_stmt VARCHAR2(20000);

Line 113: -- End of NTB_UPLOAD_STANDARD_WHO;

109: WHEN OTHERS THEN
110: RAISE_APPLICATION_ERROR(-20001,' in the procedure to update who columns');
111:
112: END;
113: -- End of NTB_UPLOAD_STANDARD_WHO;
114:
115: PROCEDURE NTB_UPLOADTL(P_ENTITY IN VARCHAR2, P_EXTID IN NUMBER, P_IF_ROW_EXISTS IN NUMBER) IS
116: --initialize variables here
117: v_pk_column VARCHAR2(30);

Line 164: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname_tl,p_extId,p_if_row_exists);

160:
161: ELSE
162: -- CALL to who upload column
163: --DBMS_OUTPUT.PUT_LINE('UPDating the who columns');
164: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname_tl,p_extId,p_if_row_exists);
165: END IF;
166:
167:
168:

Line 448: call procedure to update standard who columns

444: COMMIT;
445:
446: END LOOP; -- Completing insertion or updating a single row
447: /*
448: call procedure to update standard who columns
449: */
450: --DBMS_OUTPUT.PUT_LINE('calling who procedure');
451: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname,v_extId, v_if_row_exists);
452:

Line 451: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname,v_extId, v_if_row_exists);

447: /*
448: call procedure to update standard who columns
449: */
450: --DBMS_OUTPUT.PUT_LINE('calling who procedure');
451: MTH_UDA_PKG.NTB_Upload_Standard_Who(v_tname,v_extId, v_if_row_exists);
452:
453: /*
454: Call the procedure to update TL Table
455: */

Line 616: v_last_update_date DATE; -- Standard WHO column

612: v_l_stmt NUMBER; -- To track the line where the error has occcured
613: v_count NUMBER;
614: v_to_date DATE;
615: v_fact_table VARCHAR2(50) := UPPER(p_target); -- FACT Table Name
616: v_last_update_date DATE; -- Standard WHO column
617: v_last_update_system_id NUMBER; -- Standard WHO column
618: v_stmt VARCHAR2(500);
619:
620:

Line 617: v_last_update_system_id NUMBER; -- Standard WHO column

613: v_count NUMBER;
614: v_to_date DATE;
615: v_fact_table VARCHAR2(50) := UPPER(p_target); -- FACT Table Name
616: v_last_update_date DATE; -- Standard WHO column
617: v_last_update_system_id NUMBER; -- Standard WHO column
618: v_stmt VARCHAR2(500);
619:
620:
621: -- main body

Line 710: v_last_update_date DATE; -- Standard WHO column

706: CREATION_DATE will be same as v_last_update_date if the load is run for the first time,
707: else if the load is being run again, CREATION_DATE would already be populated, so there is no
708: need for this variable
709: */
710: v_last_update_date DATE; -- Standard WHO column
711: /*
712: CREATION_SYSTEM_ID will be same as LAST_UPDATE_SYSTEM_ID if the load is run for the first time,
713: else if the load is being run again, CREATION_SYSTEM_ID would already be populated, so there is no
714: need for this variable

Line 716: v_last_update_system_id NUMBER; -- Standard WHO column

712: CREATION_SYSTEM_ID will be same as LAST_UPDATE_SYSTEM_ID if the load is run for the first time,
713: else if the load is being run again, CREATION_SYSTEM_ID would already be populated, so there is no
714: need for this variable
715: */
716: v_last_update_system_id NUMBER; -- Standard WHO column
717: v_stmt VARCHAR2(500);
718: e_not_allowed EXCEPTION;
719:
720: