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_DATA_PREP_PKG dependencies on GCS_ENTRY_LINES

Line 723: INSERT INTO gcs_entry_lines

719: p_process_code => 'SINGLE_RUN_FOR_PERIOD',
720: p_category_code => 'DATAPREPARATION');
721: END IF;
722:
723: INSERT INTO gcs_entry_lines
724: (entry_line_number,
725: product_id,
726: natural_account_id,
727: channel_id,

Line 802: FROM gcs_entry_lines gel,

798: gel.line_type_code,
799: gel.description,
800: gel.company_cost_center_org_id,
801: gel.financial_elem_id
802: FROM gcs_entry_lines gel,
803: fem_ln_items_attr flia,
804: fem_ext_acct_types_attr fea_attr
805: WHERE gel.entry_id IN (l_prior_entry_id, l_prior_stat_entry_id)
806: AND gel.line_item_id = flia.line_item_id

Line 1259: INSERT /+ APPEND / INTO gcs_entry_lines

1255: AND fb.currency_code = :p_source_currency_code';
1256: END IF;
1257:
1258: l_insert_clause := '
1259: INSERT /*+ APPEND */ INTO gcs_entry_lines
1260: (entry_id,' || l_dims || '
1261: ptd_debit_balance_e,
1262: ptd_credit_balance_e,
1263: ytd_debit_balance_e,

Line 1271: INSERT INTO gcs_entry_lines_gt

1267: creation_date, created_by, last_update_date,
1268: last_updated_by, last_update_login
1269: )' || g_nl;
1270: l_insert_gt_clause := '
1271: INSERT INTO gcs_entry_lines_gt
1272: (entry_id, cal_period_id, ' ||
1273: l_dims || '
1274: ptd_debit_balance_e,
1275: ptd_credit_balance_e,

Line 1922: FROM gcs_entry_lines_gt fb,

1918: FND_GLOBAL.USER_ID,
1919: SYSDATE,
1920: FND_GLOBAL.USER_ID,
1921: FND_GLOBAL.LOGIN_ID
1922: FROM gcs_entry_lines_gt fb,
1923: fem_ln_items_attr flia,
1924: fem_ext_acct_types_attr fea_attr
1925: WHERE fb.line_item_id = flia.line_item_id
1926: AND flia.attribute_id = l_line_item_type_attr

Line 2235: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines_gt WHERE entry_id = l_entry_id);

2231: BEGIN
2232: SELECT ''Y''
2233: INTO l_has_row_flag
2234: FROM DUAL
2235: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines_gt WHERE entry_id = l_entry_id);
2236:
2237: gcs_entry_pkg.create_entry_header
2238: (x_errbuf => errbuf,
2239: x_retcode => retcode,

Line 2280: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines_gt WHERE entry_id = l_stat_entry_id);

2276: BEGIN
2277: SELECT ''Y''
2278: INTO l_has_stat_row_flag
2279: FROM DUAL
2280: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines_gt WHERE entry_id = l_stat_entry_id);
2281:
2282: gcs_entry_pkg.create_entry_header
2283: (x_errbuf => errbuf,
2284: x_retcode => retcode,

Line 2323: -- insert data into gcs_entry_lines table

2319: l_has_stat_row_flag := ''N'';
2320: l_stat_entry_id := NULL;
2321: END;
2322:
2323: -- insert data into gcs_entry_lines table
2324: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2325: THEN
2326: fnd_log.STRING (fnd_log.level_statement,
2327: g_pkg_name || ''.'' || l_api_name,

Line 2379: '' UPDATE gcs_entry_lines gel

2375: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2376: THEN
2377: fnd_log.STRING (fnd_log.level_statement,
2378: g_pkg_name || ''.'' || l_api_name,
2379: '' UPDATE gcs_entry_lines gel
2380: SET gel.ytd_balance_e = gel.xtd_balance_e,
2381: gel.ytd_debit_balance_e = gel.ptd_debit_balance_e,
2382: gel.ytd_credit_balance_e = gel.ptd_credit_balance_e
2383: WHERE gel.entry_id = ''||l_entry_id ||''

Line 2396: UPDATE gcs_entry_lines gel

2392: AND feata.version_id = '' || g_eatc_batc_ver_id || ''
2393: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
2394: AND gel.line_item_id = flia.line_item_id)'');
2395: END IF;
2396: UPDATE gcs_entry_lines gel
2397: SET gel.ytd_balance_e = gel.xtd_balance_e,
2398: gel.ytd_debit_balance_e = gel.ptd_debit_balance_e,
2399: gel.ytd_credit_balance_e = gel.ptd_credit_balance_e
2400: WHERE gel.entry_id = l_entry_id

Line 2417: '' UPDATE gcs_entry_lines gel

2413: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2414: THEN
2415: fnd_log.STRING (fnd_log.level_statement,
2416: g_pkg_name || ''.'' || l_api_name,
2417: '' UPDATE gcs_entry_lines gel
2418: SET (gel.ytd_balance_e, gel.ytd_credit_balance_e,gel.ytd_debit_balance_e) =
2419: (SELECT NVL (fb.ytd_balance_e, 0)
2420: + NVL (gel.xtd_balance_e, 0),
2421: NVL (fb.ytd_credit_balance_e, 0)

Line 2442: UPDATE gcs_entry_lines gel

2438: AND fb.source_system_code = '' || l_source_system_code||''' || g_nl ||
2439: get_dimension_text('AND fb.', '= gel.', 'Y') || ')
2440: WHERE gel.entry_id = ''||l_entry_id);
2441: END IF;
2442: UPDATE gcs_entry_lines gel
2443: SET (gel.ytd_balance_e, gel.ytd_credit_balance_e,gel.ytd_debit_balance_e) =
2444: (SELECT NVL (fb.ytd_balance_e, 0)
2445: + NVL (gel.xtd_balance_e, 0),
2446: NVL (fb.ytd_credit_balance_e, 0)

Line 2554: INSERT INTO gcs_entry_lines

2550: INTO l_precision, l_stat_precision
2551: FROM fnd_currencies fc_1, fnd_currencies fc_stat
2552: WHERE fc_1.currency_code = p_source_currency_code
2553: AND fc_stat.currency_code = ''STAT'';
2554: INSERT INTO gcs_entry_lines
2555: (entry_id,' || l_dims || '
2556: ptd_debit_balance_e,
2557: ptd_credit_balance_e,
2558: ytd_debit_balance_e,

Line 2577: FROM gcs_entry_lines

2573: ROUND(ytd_debit_balance_e * p_owner_percentage/decode(entry_id, l_entry_id, l_precision, l_stat_precision))*decode(entry_id, l_entry_id, l_precision, l_stat_precision)
2574: - ROUND(ytd_credit_balance_e * p_owner_percentage/decode(entry_id, l_entry_id, l_precision, l_stat_precision))*decode(entry_id, l_entry_id, l_precision, l_stat_precision),
2575: creation_date, created_by, last_update_date,
2576: last_updated_by, last_update_login
2577: FROM gcs_entry_lines
2578: WHERE entry_id in ( l_entry_id, l_stat_entry_id);
2579: -- end of bug fix 3800183
2580: --bug fix 3797312
2581: IF l_proportional_entry_id IS NOT NULL THEN

Line 2633: '' UPDATE gcs_entry_lines gel

2629: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2630: THEN
2631: fnd_log.STRING (fnd_log.level_statement,
2632: g_pkg_name || ''.'' || l_api_name,
2633: '' UPDATE gcs_entry_lines gel
2634: SET gel.intercompany_id = ( SELECT intercompany_id
2635: FROM gcs_interco_map_dtls gimd
2636: WHERE gimd.line_item_id = gel.line_item_id
2637: )

Line 2644: UPDATE gcs_entry_lines gel

2640: FROM gcs_interco_map_dtls gimd
2641: WHERE gimd.line_item_id = gel.line_item_id
2642: );'');
2643: END IF;
2644: UPDATE gcs_entry_lines gel
2645: SET gel.intercompany_id = ( SELECT intercompany_id
2646: FROM gcs_interco_map_dtls gimd
2647: WHERE gimd.line_item_id = gel.line_item_id
2648: )

Line 2679: DELETE FROM gcs_entry_lines

2675:
2676: DELETE FROM gcs_entry_headers
2677: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2678: l_proportional_entry_id, l_stat_proportional_entry_id);
2679: DELETE FROM gcs_entry_lines
2680: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2681: l_proportional_entry_id, l_stat_proportional_entry_id);
2682:
2683: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

Line 2702: DELETE FROM gcs_entry_lines

2698:
2699: DELETE FROM gcs_entry_headers
2700: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2701: l_proportional_entry_id, l_stat_proportional_entry_id);
2702: DELETE FROM gcs_entry_lines
2703: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2704: l_proportional_entry_id, l_stat_proportional_entry_id);
2705:
2706: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

Line 2749: DELETE FROM gcs_entry_lines

2745:
2746: DELETE FROM gcs_entry_headers
2747: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2748: l_proportional_entry_id, l_stat_proportional_entry_id);
2749: DELETE FROM gcs_entry_lines
2750: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2751: l_proportional_entry_id, l_stat_proportional_entry_id);
2752:
2753: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

Line 2888: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines WHERE entry_id = x_entry_id);

2884: BEGIN
2885: SELECT ''Y''
2886: INTO l_has_row_flag
2887: FROM DUAL
2888: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines WHERE entry_id = x_entry_id);
2889: EXCEPTION
2890: WHEN NO_DATA_FOUND THEN
2891: l_has_row_flag := ''N'';
2892: END;

Line 2897: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines WHERE entry_id = x_stat_entry_id);

2893: BEGIN
2894: SELECT ''Y''
2895: INTO l_has_stat_row_flag
2896: FROM DUAL
2897: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines WHERE entry_id = x_stat_entry_id);
2898: EXCEPTION
2899: WHEN NO_DATA_FOUND THEN
2900: l_has_stat_row_flag := ''N'';
2901: END;

Line 2921: UPDATE gcs_entry_lines gel

2917: AND cal_period_id = p_target_cal_period_id
2918: AND balance_type_code = p_balance_type_code
2919: AND most_recent_flag = ''Y''
2920: );
2921: UPDATE gcs_entry_lines gel
2922: SET (ptd_debit_balance_e, ptd_credit_balance_e, xtd_balance_e,
2923: ytd_debit_balance_e, ytd_credit_balance_e, ytd_balance_e) =
2924: (SELECT gel.ptd_debit_balance_e - gel_pre.ptd_debit_balance_e,
2925: gel.ptd_credit_balance_e - gel_pre.ptd_credit_balance_e,

Line 2930: FROM gcs_entry_lines gel_pre

2926: gel.xtd_balance_e - gel_pre.xtd_balance_e,
2927: gel.ytd_debit_balance_e - gel_pre.ytd_debit_balance_e,
2928: gel.ytd_credit_balance_e - gel_pre.ytd_credit_balance_e,
2929: gel.ytd_balance_e - gel_pre.ytd_balance_e
2930: FROM gcs_entry_lines gel_pre
2931: WHERE gel_pre.entry_id = decode(gel.entry_id,
2932: x_entry_id,
2933: l_pre_entry_id,
2934: l_pre_stat_entry_id) ' ||

Line 2939: FROM gcs_entry_lines gel_pre

2935: get_dimension_text('AND gel.', '= gel_pre.', 'Y') || '
2936: )
2937: WHERE gel.entry_id in (x_entry_id, x_stat_entry_id)
2938: AND EXISTS (SELECT 1
2939: FROM gcs_entry_lines gel_pre
2940: WHERE gel_pre.entry_id = decode(gel.entry_id,
2941: x_entry_id,
2942: l_pre_entry_id,
2943: l_pre_stat_entry_id) ' ||

Line 3103: INSERT INTO gcs_entry_lines

3099: INTO l_precision, l_stat_precision
3100: FROM fnd_currencies fc_1, fnd_currencies fc_stat
3101: WHERE fc_1.currency_code = p_source_currency_code
3102: AND fc_stat.currency_code = ''STAT'';
3103: INSERT INTO gcs_entry_lines
3104: (entry_id,' || l_dims || '
3105: ptd_debit_balance_e,
3106: ptd_credit_balance_e,
3107: ytd_debit_balance_e,

Line 3126: FROM gcs_entry_lines

3122: ROUND(ytd_debit_balance_e * p_owner_percentage/decode(entry_id, x_entry_id, l_precision, l_stat_precision))*decode(entry_id, x_entry_id, l_precision, l_stat_precision)
3123: - ROUND(ytd_credit_balance_e * p_owner_percentage/decode(entry_id, x_entry_id, l_precision, l_stat_precision))*decode(entry_id, x_entry_id, l_precision, l_stat_precision),
3124: creation_date, created_by, last_update_date,
3125: last_updated_by, last_update_login
3126: FROM gcs_entry_lines
3127: WHERE entry_id in ( x_entry_id, x_stat_entry_id);
3128: IF x_prop_entry_id IS NOT NULL THEN
3129: gcs_templates_dynamic_pkg.balance (p_entry_id => x_prop_entry_id,
3130: p_template => l_temp_record,

Line 3172: '' UPDATE gcs_entry_lines gel

3168: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
3169: THEN
3170: fnd_log.STRING (fnd_log.level_statement,
3171: g_pkg_name || ''.'' || l_api_name,
3172: '' UPDATE gcs_entry_lines gel
3173: SET gel.intercompany_id = ( SELECT intercompany_id
3174: FROM gcs_interco_map_dtls gimd
3175: WHERE gimd.line_item_id = gel.line_item_id
3176: )

Line 3183: UPDATE gcs_entry_lines gel

3179: FROM gcs_interco_map_dtls gimd
3180: WHERE gimd.line_item_id = gel.line_item_id
3181: );'');
3182: END IF;
3183: UPDATE gcs_entry_lines gel
3184: SET gel.intercompany_id = ( SELECT intercompany_id
3185: FROM gcs_interco_map_dtls gimd
3186: WHERE gimd.line_item_id = gel.line_item_id
3187: )