DBA Data[Home] [Help]

APPS.GCS_DYN_FEM_POSTING_PKG dependencies on GCS_FEM_POSTING_GT

Line 63: INTO GCS_FEM_POSTING_GT(

59: END IF;
60:
61: FORALL i IN l_entry_id_list.FIRST..l_entry_id_list.LAST
62: INSERT
63: INTO GCS_FEM_POSTING_GT(
64: ENTRY_ID,
65: SEQUENCE_NUM,
66: CURRENCY_CODE,
67: COMPANY_COST_CENTER_ORG_ID,

Line 115: INTO GCS_FEM_POSTING_GT(

111: AND (GHD.end_cal_period_id IS NULL OR ghd.start_cal_period_id <> ghd.end_cal_period_id));
112:
113: -- bug fix 5080422: swap position of line_item_id and intercompany_id
114: INSERT
115: INTO GCS_FEM_POSTING_GT(
116: ENTRY_ID,
117: SEQUENCE_NUM,
118: CURRENCY_CODE,
119: COMPANY_COST_CENTER_ORG_ID,

Line 179: INTO GCS_FEM_POSTING_GT(

175: WHEN NO_DATA_FOUND THEN
176:
177: -- bug fix 5080422: swap position of line_item_id and intercompany_id
178: INSERT
179: INTO GCS_FEM_POSTING_GT(
180: ENTRY_ID,
181: SEQUENCE_NUM,
182: CURRENCY_CODE,
183: COMPANY_COST_CENTER_ORG_ID,

Line 254: INTO GCS_FEM_POSTING_GT(

250: AND (GHD.end_cal_period_id IS NULL OR ghd.start_cal_period_id <> ghd.end_cal_period_id));
251:
252: -- bug fix 5080422: swap position of line_item_id and intercompany_id
253: INSERT
254: INTO GCS_FEM_POSTING_GT(
255: ENTRY_ID,
256: SEQUENCE_NUM,
257: CURRENCY_CODE,
258: COMPANY_COST_CENTER_ORG_ID,

Line 317: INTO GCS_FEM_POSTING_GT(

313: WHEN NO_DATA_FOUND THEN
314:
315: -- bug fix 5080422: swap position of line_item_id and intercompany_id
316: INSERT
317: INTO GCS_FEM_POSTING_GT(
318: ENTRY_ID,
319: SEQUENCE_NUM,
320: CURRENCY_CODE,
321: COMPANY_COST_CENTER_ORG_ID,

Line 474: FROM GCS_FEM_POSTING_GT;

470: YTD_CREDIT_BALANCE_E,
471: --Bugfix 5646770: Added _F Columns for topmost entity
472: DECODE(p_topmost_entity_flag, 'Y', XTD_BALANCE_E, NULL) XTD_BALANCE_F,
473: DECODE(p_topmost_entity_flag, 'Y', YTD_BALANCE_E, NULL) YTD_BALANCE_F
474: FROM GCS_FEM_POSTING_GT;
475:
476: IF (procedureloglevel >= runtimeloglevel ) THEN
477: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
478: END IF;

Line 559: FROM GCS_FEM_POSTING_GT GLE) GFB

555: GLE.PTD_DEBIT_BALANCE_E,
556: GLE.PTD_CREDIT_BALANCE_E,
557: GLE.YTD_DEBIT_BALANCE_E YTD_DEBIT_BALANCE_E,
558: GLE.YTD_CREDIT_BALANCE_E YTD_CREDIT_BALANCE_E
559: FROM GCS_FEM_POSTING_GT GLE) GFB
560: ON (
561: FB.CREATED_BY_OBJECT_ID = GFB.CREATED_BY_OBJECT_ID
562: AND FB.CREATED_BY_REQUEST_ID = GFB.CREATED_BY_REQUEST_ID
563: AND FB.CREATION_ROW_SEQUENCE = GFB.CREATION_ROW_SEQUENCE)

Line 643: FROM GCS_FEM_POSTING_GT GLE) GFB

639: GLE.PTD_DEBIT_BALANCE_E,
640: GLE.PTD_CREDIT_BALANCE_E,
641: GLE.YTD_DEBIT_BALANCE_E YTD_DEBIT_BALANCE_E,
642: GLE.YTD_CREDIT_BALANCE_E YTD_CREDIT_BALANCE_E
643: FROM GCS_FEM_POSTING_GT GLE) GFB
644: ON (
645: FB.CREATED_BY_OBJECT_ID = GFB.CREATED_BY_OBJECT_ID
646: AND FB.CREATED_BY_REQUEST_ID = GFB.CREATED_BY_REQUEST_ID
647: AND FB.CREATION_ROW_SEQUENCE = GFB.CREATION_ROW_SEQUENCE)

Line 729: FROM GCS_FEM_POSTING_GT GFPG;

725: l_user_id,
726: sysdate,
727: l_user_id,
728: l_login_id
729: FROM GCS_FEM_POSTING_GT GFPG;
730:
731: IF (statementloglevel >= runtimeloglevel ) THEN
732: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.PROCESS_MERGE.rowcount ', to_char(SQL%ROWCOUNT));
733: END IF;