DBA Data[Home] [Help]

APPS.GL_CONS_HISTORY_PKG dependencies on STANDARD

Line 94: * Desc: Copy the standard consolidation record for average consolidation.

90: END first_period_of_year;
91:
92:
93: /* Name: insert_average_record
94: * Desc: Copy the standard consolidation record for average consolidation.
95: */
96: PROCEDURE insert_average_record(
97: SourceRunId NUMBER,
98: TargetRunId NUMBER,

Line 175: X_Standard_To_Period_Name VARCHAR2,

171: X_Consolidation_Id NUMBER,
172: X_Last_Update_Date DATE,
173: X_Last_Updated_By NUMBER,
174: X_From_Period_Name VARCHAR2,
175: X_Standard_To_Period_Name VARCHAR2,
176: X_To_Period_Name IN OUT NOCOPY VARCHAR2,
177: X_To_Currency_Code VARCHAR2,
178: X_Method_Flag VARCHAR2,
179: X_Run_Easylink_Flag VARCHAR2,

Line 203: X_To_Period_Name := X_Standard_To_Period_Name;

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;
204: IF (X_StdAmountType = 'EOD') THEN
205: X_From_Date := X_From_Date_Entered;
206: ELSE
207: X_From_Date := NULL;

Line 245: X_Standard_To_Period_Name,

241: X_Last_Updated_By,
242: X_Last_Update_Date,
243: X_Last_Updated_By,
244: X_From_Period_Name,
245: X_Standard_To_Period_Name,
246: X_To_Currency_Code,
247: X_Method_Flag,
248: X_Run_Easylink_Flag,
249: X_Run_Posting_Flag,

Line 364: X_Standard_To_Period_Name VARCHAR2,

360: X_Consolidation_Id NUMBER,
361: X_Consolidation_Set_Id NUMBER,
362: X_Last_Updated_By NUMBER,
363: X_From_Period_Name VARCHAR2,
364: X_Standard_To_Period_Name VARCHAR2,
365: X_Average_To_Period_Name VARCHAR2,
366: X_Average_To_Start_Date DATE,
367: X_To_Currency_Code VARCHAR2,
368: X_Method_Flag VARCHAR2,

Line 403: --+ Get the consolidation run id for standard usage

399: source_group_id NUMBER;
400: CIRequestId NUMBER;
401: msgbuf VARCHAR2(200) := '';
402: BEGIN
403: --+ Get the consolidation run id for standard usage
404: GL_CONS_HISTORY_PKG.Get_New_Id(std_runid);
405:
406: --+ The remote flag should be Y if it is a cross-instance consolidation,
407: --+ that is, when the target dabase is not null.

Line 439: --+ submit a standard request.

435: END IF;
436:
437: END IF;
438:
439: --+ submit a standard request.
440: std_request_id := FND_REQUEST.SUBMIT_REQUEST(
441: 'SQLGL',
442: 'GLCCON',
443: '',

Line 450: X_Standard_To_Period_Name,

446: To_Char(X_consolidation_id),
447: 'S',
448: X_From_Period_Name,
449: To_Char(X_From_Date_Entered, 'YYYY/MM/DD'),
450: X_Standard_To_Period_Name,
451: NULL,
452: NULL,
453: X_Std_Amounttype,
454: X_Run_Journal_Import_Flag,

Line 527: X_Standard_To_Period_Name,

523: X_Last_Updated_By,
524: sysdate,
525: X_Last_Updated_By,
526: X_From_Period_Name,
527: X_Standard_To_Period_Name,
528: X_To_Currency_Code,
529: X_Method_Flag,
530: X_Run_Journal_Import_Flag,
531: X_Run_Posting_Flag,

Line 560: --+ corresponds to a standard ledger, so don't

556: IF (X_Usage_Code IN ('A', 'B')) THEN
557: IF (X_Usage_Code = 'B') THEN
558:
559: --+ If the AvgAmounttype IS NULL then the consolidation
560: --+ corresponds to a standard ledger, so don't
561: --+ submit an average consolidation.
562: IF (X_Avg_Amounttype IS NULL) THEN
563: RETURN;
564: ELSE

Line 706: X_Standard_To_Period_Name,

702: X_Target_Resp_Name,
703: Std_Request_Id,
704: X_consolidation_id,
705: Std_RunId,
706: X_Standard_To_Period_Name,
707: X_To_Ledger_Id,
708: X_Target_User_Name,
709: X_Target_DB_Name,
710: source_group_id,

Line 712: X_Standard_To_Period_Name,

708: X_Target_User_Name,
709: X_Target_DB_Name,
710: source_group_id,
711: X_From_Ledger_Id,
712: X_Standard_To_Period_Name,
713: NULL,
714: X_Run_Journal_Import_Flag,
715: X_Run_Posting_Flag,
716: X_Actual_Flag,