36:
37: PROCEDURE Get_New_Id(next_val IN OUT NOCOPY NUMBER) IS
38:
39: BEGIN
40: select GL_CONSOLIDATION_HISTORY_S.NEXTVAL
41: into next_val
42: from dual;
43:
44: END Get_New_Id;
100: AvgAmountType VARCHAR2,
101: FromDateEntered DATE
102: ) IS
103: BEGIN
104: INSERT INTO GL_CONSOLIDATION_HISTORY(
105: consolidation_run_id,
106: consolidation_id,
107: last_update_date,
108: last_updated_by,
150: FromDateEntered,
151: target_resp_name,
152: target_user_name,
153: target_database_name
154: FROM gl_consolidation_history
155: WHERE NOT EXISTS (SELECT 1
156: FROM gl_consolidation_history
157: WHERE consolidation_run_id = TargetRunId)
158: AND consolidation_run_id = SourceRunId;
152: target_user_name,
153: target_database_name
154: FROM gl_consolidation_history
155: WHERE NOT EXISTS (SELECT 1
156: FROM gl_consolidation_history
157: WHERE consolidation_run_id = TargetRunId)
158: AND consolidation_run_id = SourceRunId;
159: END insert_average_record;
160:
193: X_Target_Resp_Name VARCHAR2,
194: X_Target_User_Name VARCHAR2,
195: X_Target_DB_Name VARCHAR2
196: ) IS
197: CURSOR C(Run_Id NUMBER) IS SELECT rowid FROM GL_CONSOLIDATION_HISTORY
198: WHERE consolidation_run_id = Run_Id;
199: CURSOR C2 IS SELECT gl_consolidation_history_s.nextval FROM sys.dual;
200: TempRowid VARCHAR2(60);
201: TempRunId NUMBER;
195: X_Target_DB_Name VARCHAR2
196: ) IS
197: CURSOR C(Run_Id NUMBER) IS SELECT rowid FROM GL_CONSOLIDATION_HISTORY
198: WHERE consolidation_run_id = Run_Id;
199: CURSOR C2 IS SELECT gl_consolidation_history_s.nextval FROM sys.dual;
200: TempRowid VARCHAR2(60);
201: TempRunId NUMBER;
202: BEGIN
203: X_To_Period_Name := X_Standard_To_Period_Name;
207: X_From_Date := NULL;
208: END IF;
209:
210: IF (X_Usage_Code IN ('S', 'B')) THEN
211: INSERT INTO GL_CONSOLIDATION_HISTORY(
212: consolidation_run_id,
213: consolidation_id,
214: last_update_date,
215: last_updated_by,
283: X_AvgRunId := TempRunId;
284: END IF;
285:
286: IF (X_Usage_Code = 'A') THEN
287: INSERT INTO GL_CONSOLIDATION_HISTORY(
288: consolidation_run_id,
289: consolidation_id,
290: last_update_date,
291: last_updated_by,
385: X_access_set_id NUMBER
386: ) IS
387: CURSOR Select_Rowid(Runid NUMBER) IS
388: SELECT rowid
389: FROM GL_CONSOLIDATION_HISTORY
390: WHERE consolidation_run_id = Runid;
391: temp_rowid ROWID;
392: std_runid NUMBER;
393: avg_runid NUMBER;
488: X_last_request_Id := Std_Request_Id;
489: END IF;
490: END IF;
491:
492: --+ insert into gl_consolidation_history
493: INSERT INTO GL_CONSOLIDATION_HISTORY(
494: consolidation_run_id,
495: consolidation_id,
496: consolidation_set_id,
489: END IF;
490: END IF;
491:
492: --+ insert into gl_consolidation_history
493: INSERT INTO GL_CONSOLIDATION_HISTORY(
494: consolidation_run_id,
495: consolidation_id,
496: consolidation_set_id,
497: last_update_date,
621: IF X_last_request_Id < avg_Request_Id THEN
622: X_last_request_Id := avg_Request_Id;
623: END IF;
624: END IF;
625: --+ insert into gl_consolidation_history
626:
627: INSERT INTO GL_CONSOLIDATION_HISTORY(
628: consolidation_run_id,
629: consolidation_id,
623: END IF;
624: END IF;
625: --+ insert into gl_consolidation_history
626:
627: INSERT INTO GL_CONSOLIDATION_HISTORY(
628: consolidation_run_id,
629: consolidation_id,
630: consolidation_set_id,
631: last_update_date,
831: X_Target_Resp_Name VARCHAR2,
832: X_Target_User_Name VARCHAR2,
833: X_Target_DB_Name VARCHAR2) IS
834: BEGIN
835: INSERT INTO GL_CONSOLIDATION_HISTORY(
836: consolidation_run_id,
837: consolidation_id,
838: last_update_date,
839: last_updated_by,
908: X_StdReqId NUMBER,
909: X_AvgReqId NUMBER) IS
910: BEGIN
911: IF (X_StdRunId IS NOT NULL) THEN
912: UPDATE GL_CONSOLIDATION_HISTORY
913: SET status = 'TS',
914: request_id = X_StdReqId
915: WHERE consolidation_run_id = X_StdRunId;
916: END IF;
915: WHERE consolidation_run_id = X_StdRunId;
916: END IF;
917:
918: IF (X_AvgRunId IS NOT NULL) THEN
919: UPDATE GL_CONSOLIDATION_HISTORY
920: SET status = 'TS',
921: request_id = X_AvgReqId
922: WHERE consolidation_run_id = X_AvgRunId;
923: END IF;