APPS.GCS_RULES_PROCESSOR dependencies on GCS_ENTRY_LINES

Line 210: --cursor to look exactly like the gcs_entry_lines table,

206:
207: --Get an aggregated representation of the entry
208: --NOTE that because PL/SQL cannot support using field refs
209: --in a bulk insert, and since we cannot define the getLines
210: --cursor to look exactly like the gcs_entry_lines table,
211: --it becomes necessary to use a record of tables that looks
212: --like the getLines cursor below (see writeEntry()).
213: Type numTab Is Table Of number Index By binary_integer;
214: Type varTab Is Table Of varchar2(50) Index By binary_integer;

Line 695: INSERT INTO gcs_entry_lines

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
696: (ENTRY_ID,
697: LINE_TYPE_CODE,
698: DESCRIPTION,
699: COMPANY_COST_CENTER_ORG_ID,

Line 767: FROM gcs_entry_lines

763: CREATED_BY,
764: LAST_UPDATE_DATE,
765: LAST_UPDATED_BY,
766: LAST_UPDATE_LOGIN
767: FROM gcs_entry_lines
768: WHERE entry_id = p_entry_id;
769:
770: --Get the template record together
771: templateRecord.FINANCIAL_ELEM_ID := suspenseData.financial_elem_id;

Line 3901: DELETE FROM GCS_ENTRY_LINES WHERE ENTRY_ID = entryId;

3897: procedureName,
3898: 'stmt',
3899: to_char(SQL%ROWCOUNT) || ' row(s) updated');
3900:
3901: DELETE FROM GCS_ENTRY_LINES WHERE ENTRY_ID = entryId;
3902:
3903: logString(statementLogLevel,
3904: procedureName,
3905: 'stmt',

Line 3918: Insert Into gcs_entry_lines

3914: -- Insert the records
3915:
3916: ForAll x In linesData.line_item_id.FIRST .. linesData.line_item_id.LAST
3917:
3918: Insert Into gcs_entry_lines
3919: (entry_id,
3920: company_cost_center_org_id,
3921: financial_elem_id,
3922: product_id,

Line 4149: -- insert that writes entry lines to GCS_ENTRY_LINES.

4145: -- To know what multiplier to use we have to get an attribute
4146: -- of an attribute of the line_item_id for every distinct lii
4147: -- in the GCS_ENTRIES_GT table. Then we can store the value
4148: -- onto the linsData.balance_factor record for use in the bulk
4149: -- insert that writes entry lines to GCS_ENTRY_LINES.
4150:
4151: --Get the attribute_id and version_id for the EXTENDED_ACCOUNT_TYPE
4152: declare
4153: liaKey varchar2(100) := 'LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE';

Line 4474: UPDATE gcs_entry_lines gel

4470: -- Bugfix 6242317: Update the account type code
4471: if contextData.eventType = 'A' then
4472:
4473: --Bugfix 6242317: Update Line Type Code
4474: UPDATE gcs_entry_lines gel
4475: SET line_type_code = (SELECT DECODE(gel.description,
4476: 'RE_LINE',
4477: 'CALCULATED',
4478: DECODE(feata.dim_attribute_varchar_member,

Line 4575: 'inserting into gcs_entry_lines');

4571: --create the entry lines
4572: logString(eventLogLevel,
4573: procedureName,
4574: 'section',
4575: 'inserting into gcs_entry_lines');
4576: --=======================================================
4577:
4578: logString(statementLogLevel,
4579: procedureName,

Line 4581: 'Inserting into gcs_entry_lines');

4577:
4578: logString(statementLogLevel,
4579: procedureName,
4580: 'event',
4581: 'Inserting into gcs_entry_lines');
4582:
4583: select decode(count(1), 0, 'N', 'Y')
4584: into offsetFlag
4585: from gcs_rule_scope_dims grsd, gcs_elim_rule_steps_b grsb

Line 4603: 'Completed insert into gcs_entry_lines ' || l_row_count);

4599:
4600: logString(statementLogLevel,
4601: procedureName,
4602: 'event',
4603: 'Completed insert into gcs_entry_lines ' || l_row_count);
4604:
4605: --check if any lines where created
4606: if (l_row_count = 0) then
4607: DELETE gcs_cons_eng_run_dtls