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.GCS_RULES_PROCESSOR dependencies on GCS_ENTRY_HEADERS

Line 57: mainEntryId gcs_entry_headers.entry_id%TYPE := -1;

53: systemDate date;
54: userId number;
55: ruleIteration number := 1;
56:
57: mainEntryId gcs_entry_headers.entry_id%TYPE := -1;
58: statEntryId gcs_entry_headers.entry_id%TYPE := -1;
59:
60: -- Dynamic SQL storage
61: srcColumnList varchar2(2000);

Line 58: statEntryId gcs_entry_headers.entry_id%TYPE := -1;

54: userId number;
55: ruleIteration number := 1;
56:
57: mainEntryId gcs_entry_headers.entry_id%TYPE := -1;
58: statEntryId gcs_entry_headers.entry_id%TYPE := -1;
59:
60: -- Dynamic SQL storage
61: srcColumnList varchar2(2000);
62: tgtColumnList varchar2(2000);

Line 476: gcs_entry_headers_s.nextval,

472: -- get the multiple parents elimination entities
473: CURSOR c_elim_entities(l_end_date Date) IS
474: SELECT fea.dim_attribute_numeric_member elim_entity_id,
475: delta_owned,
476: gcs_entry_headers_s.nextval,
477: geca.currency_code,
478: nvl(precision, 2) precision
479: FROM gcs_cons_relationships gcr,
480: fem_entities_attr fea,

Line 503: gcs_entry_headers_s.nextval,

499: -- get the multiple parents consolidation entities
500: CURSOR c_cons_entities(l_end_date Date) IS
501: SELECT gcr.parent_entity_id,
502: delta_owned,
503: gcs_entry_headers_s.nextval,
504: geca.currency_code,
505: nvl(precision, 2) precision
506: FROM gcs_cons_relationships gcr,
507: gcs_entity_cons_attrs geca,

Line 522: gcs_entry_headers_s.nextval,

518: -- get the multiple parents child entities
519: CURSOR c_child_entities(l_end_date Date) IS
520: SELECT geh.entity_id,
521: delta_owned,
522: gcs_entry_headers_s.nextval,
523: geh.currency_code,
524: nvl(precision, 2) precision
525: FROM gcs_cons_relationships gcr,
526: gcs_entry_headers geh,

Line 526: gcs_entry_headers geh,

522: gcs_entry_headers_s.nextval,
523: geh.currency_code,
524: nvl(precision, 2) precision
525: FROM gcs_cons_relationships gcr,
526: gcs_entry_headers geh,
527: fnd_currencies fc
528: WHERE gcr.hierarchy_id = contextData.hierarchy
529: AND gcr.child_entity_id = contextData.childEntity
530: AND gcr.actual_ownership_flag = 'N'

Line 642: INSERT INTO gcs_entry_headers

638: END IF;
639:
640: IF (l_entities.COUNT <> 0) THEN
641: FORALL i IN l_entities.first .. l_entities.last
642: INSERT INTO gcs_entry_headers
643: (ENTRY_ID,
644: ENTRY_NAME,
645: HIERARCHY_ID,
646: DISABLED_FLAG,

Line 691: FROM gcs_entry_headers

687: LAST_UPDATE_LOGIN,
688: PERIOD_INIT_ENTRY_FLAG,
689: ruleId,
690: contextData.runName
691: FROM gcs_entry_headers
692: WHERE entry_id = p_entry_id;
693:
694: FORALL i IN l_entities.first .. l_entities.last
695: INSERT INTO gcs_entry_lines

Line 3747: Select gcs_entry_headers_s.nextval From dual;

3743:
3744: procedureName varchar(30);
3745:
3746: cursor getEntryId is
3747: Select gcs_entry_headers_s.nextval From dual;
3748: entryId gcs_entry_headers.entry_id%TYPE := -1;
3749:
3750: cursor getADEntryId is
3751: SELECT B.assoc_entry_id

Line 3748: entryId gcs_entry_headers.entry_id%TYPE := -1;

3744: procedureName varchar(30);
3745:
3746: cursor getEntryId is
3747: Select gcs_entry_headers_s.nextval From dual;
3748: entryId gcs_entry_headers.entry_id%TYPE := -1;
3749:
3750: cursor getADEntryId is
3751: SELECT B.assoc_entry_id
3752: FROM GCS_AD_TRANSACTIONS B

Line 3892: UPDATE GCS_ENTRY_HEADERS

3888:
3889: else
3890:
3891: --bug 4253081: update GCS_ENTRY_HEADER with RULE_ID
3892: UPDATE GCS_ENTRY_HEADERS
3893: SET RULE_ID = ruleId
3894: WHERE ENTRY_ID = entryId;
3895:
3896: logString(statementLogLevel,

Line 4005: entryId gcs_entry_headers.entry_id%TYPE := -1;

4001:
4002: procedureName varchar(30);
4003: l_suspense_exceeded_flag VARCHAR2(1);
4004:
4005: entryId gcs_entry_headers.entry_id%TYPE := -1;
4006:
4007: Cursor getConversionRate(amt number) Is
4008: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )
4009: (conversion_rate * amt)

Line 4505: FROM gcs_entry_headers

4501:
4502: -- bug fix 3920448
4503: SELECT SUSPENSE_EXCEEDED_FLAG
4504: INTO l_suspense_exceeded_flag
4505: FROM gcs_entry_headers
4506: WHERE entry_id = entryId;
4507:
4508: IF l_suspense_exceeded_flag = 'Y' THEN
4509: raise suspense_exceeded_warn;

Line 4533: Select gcs_entry_headers_s.nextval From dual;

4529:
4530: procedureName varchar(30);
4531:
4532: cursor getEntryId is
4533: Select gcs_entry_headers_s.nextval From dual;
4534: entryId gcs_entry_headers.entry_id%TYPE := -1;
4535:
4536: errbuf varchar2(100);
4537: retcode varchar2(100);

Line 4534: entryId gcs_entry_headers.entry_id%TYPE := -1;

4530: procedureName varchar(30);
4531:
4532: cursor getEntryId is
4533: Select gcs_entry_headers_s.nextval From dual;
4534: entryId gcs_entry_headers.entry_id%TYPE := -1;
4535:
4536: errbuf varchar2(100);
4537: retcode varchar2(100);
4538: procCode varchar2(50);

Line 4723: entryId gcs_entry_headers.entry_id%TYPE := -1;

4719:
4720: procedureName varchar(30);
4721: l_suspense_exceeded_flag VARCHAR2(1);
4722:
4723: entryId gcs_entry_headers.entry_id%TYPE := -1;
4724:
4725: Cursor getConversionRate(amt number) Is
4726: select --+ INDEX_DESC( r, GL_DAILY_RATES_U1 )
4727: (conversion_rate * amt)

Line 5020: FROM gcs_entry_headers

5016:
5017: -- bug fix 3920448
5018: SELECT SUSPENSE_EXCEEDED_FLAG
5019: INTO l_suspense_exceeded_flag
5020: FROM gcs_entry_headers
5021: WHERE entry_id = entryId;
5022:
5023: IF l_suspense_exceeded_flag = 'Y' THEN
5024: raise suspense_exceeded_warn;