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_RP_UTILITY_PKG

Line 2227: selColumnList := gcs_rp_utility_pkg.g_rp_selColumnList;

2223: j := 0;
2224: offsetFlag := 'N';
2225:
2226: --Assign column lists based off the active dimensions using the dynamic utility package
2227: selColumnList := gcs_rp_utility_pkg.g_rp_selColumnList;
2228: srcColumnList := gcs_rp_utility_pkg.g_rp_srcColumnList;
2229: tgtColumnList := gcs_rp_utility_pkg.g_rp_tgtColumnList;
2230: offColumnList := gcs_rp_utility_pkg.g_rp_offColumnList;
2231:

Line 2228: srcColumnList := gcs_rp_utility_pkg.g_rp_srcColumnList;

2224: offsetFlag := 'N';
2225:
2226: --Assign column lists based off the active dimensions using the dynamic utility package
2227: selColumnList := gcs_rp_utility_pkg.g_rp_selColumnList;
2228: srcColumnList := gcs_rp_utility_pkg.g_rp_srcColumnList;
2229: tgtColumnList := gcs_rp_utility_pkg.g_rp_tgtColumnList;
2230: offColumnList := gcs_rp_utility_pkg.g_rp_offColumnList;
2231:
2232: --Log Strings for tracking purposes

Line 2229: tgtColumnList := gcs_rp_utility_pkg.g_rp_tgtColumnList;

2225:
2226: --Assign column lists based off the active dimensions using the dynamic utility package
2227: selColumnList := gcs_rp_utility_pkg.g_rp_selColumnList;
2228: srcColumnList := gcs_rp_utility_pkg.g_rp_srcColumnList;
2229: tgtColumnList := gcs_rp_utility_pkg.g_rp_tgtColumnList;
2230: offColumnList := gcs_rp_utility_pkg.g_rp_offColumnList;
2231:
2232: --Log Strings for tracking purposes
2233: logString(statementLogLevel,

Line 2230: offColumnList := gcs_rp_utility_pkg.g_rp_offColumnList;

2226: --Assign column lists based off the active dimensions using the dynamic utility package
2227: selColumnList := gcs_rp_utility_pkg.g_rp_selColumnList;
2228: srcColumnList := gcs_rp_utility_pkg.g_rp_srcColumnList;
2229: tgtColumnList := gcs_rp_utility_pkg.g_rp_tgtColumnList;
2230: offColumnList := gcs_rp_utility_pkg.g_rp_offColumnList;
2231:
2232: --Log Strings for tracking purposes
2233: logString(statementLogLevel,
2234: procedureName,

Line 2272: entriesStmt := gcs_rp_utility_pkg.g_core_insert_stmt || srcColumnList ||

2268: logString(eventLogLevel, procedureName, 'section', '2');
2269: --=======================================================
2270:
2271: --Start the Statement
2272: entriesStmt := gcs_rp_utility_pkg.g_core_insert_stmt || srcColumnList ||
2273: tgtColumnList || offColumnList ||
2274: gcs_rp_utility_pkg.g_core_sel_stmt || selColumnList;
2275:
2276: whereClause := gcs_rp_utility_pkg.g_core_whr_stmt;

Line 2274: gcs_rp_utility_pkg.g_core_sel_stmt || selColumnList;

2270:
2271: --Start the Statement
2272: entriesStmt := gcs_rp_utility_pkg.g_core_insert_stmt || srcColumnList ||
2273: tgtColumnList || offColumnList ||
2274: gcs_rp_utility_pkg.g_core_sel_stmt || selColumnList;
2275:
2276: whereClause := gcs_rp_utility_pkg.g_core_whr_stmt;
2277: fromList := gcs_rp_utility_pkg.g_core_frm_stmt;
2278: groupClause := gcs_rp_utility_pkg.g_core_grp_stmt;

Line 2276: whereClause := gcs_rp_utility_pkg.g_core_whr_stmt;

2272: entriesStmt := gcs_rp_utility_pkg.g_core_insert_stmt || srcColumnList ||
2273: tgtColumnList || offColumnList ||
2274: gcs_rp_utility_pkg.g_core_sel_stmt || selColumnList;
2275:
2276: whereClause := gcs_rp_utility_pkg.g_core_whr_stmt;
2277: fromList := gcs_rp_utility_pkg.g_core_frm_stmt;
2278: groupClause := gcs_rp_utility_pkg.g_core_grp_stmt;
2279:
2280: --Check for token usages

Line 2277: fromList := gcs_rp_utility_pkg.g_core_frm_stmt;

2273: tgtColumnList || offColumnList ||
2274: gcs_rp_utility_pkg.g_core_sel_stmt || selColumnList;
2275:
2276: whereClause := gcs_rp_utility_pkg.g_core_whr_stmt;
2277: fromList := gcs_rp_utility_pkg.g_core_frm_stmt;
2278: groupClause := gcs_rp_utility_pkg.g_core_grp_stmt;
2279:
2280: --Check for token usages
2281: if (INSTR(stepData(stepSeq).formula_text, 'CHILDTB') <> 0) then

Line 2278: groupClause := gcs_rp_utility_pkg.g_core_grp_stmt;

2274: gcs_rp_utility_pkg.g_core_sel_stmt || selColumnList;
2275:
2276: whereClause := gcs_rp_utility_pkg.g_core_whr_stmt;
2277: fromList := gcs_rp_utility_pkg.g_core_frm_stmt;
2278: groupClause := gcs_rp_utility_pkg.g_core_grp_stmt;
2279:
2280: --Check for token usages
2281: if (INSTR(stepData(stepSeq).formula_text, 'CHILDTB') <> 0) then
2282: childEntityToken := true;

Line 4596: gcs_rp_utility_pkg.create_entry_lines(p_entry_id => entryId,

4592: procedureName,
4593: 'event',
4594: 'Value of offset flag is: ' || offsetFlag);
4595:
4596: gcs_rp_utility_pkg.create_entry_lines(p_entry_id => entryId,
4597: p_offset_flag => offsetFlag,
4598: p_row_count => l_row_count);
4599:
4600: logString(statementLogLevel,