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_DP_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES_GT

Line 99: INSERT INTO gcs_entry_lines_gt

95: WHEN NO_DATA_FOUND THEN
96: RAISE global_vs_id_error;
97: END;
98: g_insert_statement := '
99: INSERT INTO gcs_entry_lines_gt
100: (entry_id, cal_period_id,
101: ptd_debit_balance_e,
102: ptd_credit_balance_e,
103: ytd_debit_balance_e,

Line 727: INSERT INTO gcs_entry_lines_gt

723: IF (l_mapping_required = 'N') THEN
724: IF (p_balance_type_code = 'ADB' AND p_currency_type_code = 'ENTERED') THEN
725: FORALL counter IN l_periods_list.FIRST..l_periods_list.LAST
726:
727: INSERT INTO gcs_entry_lines_gt
728: (entry_id, cal_period_id,
729: ptd_debit_balance_e,
730: ptd_credit_balance_e,
731: ytd_debit_balance_e,

Line 763: INSERT INTO gcs_entry_lines_gt

759: AND fb.financial_elem_id = 140;
760: ELSIF (p_balance_type_code = 'ADB') THEN
761: FORALL counter IN l_periods_list.FIRST..l_periods_list.LAST
762:
763: INSERT INTO gcs_entry_lines_gt
764: (entry_id, cal_period_id,
765: ptd_debit_balance_e,
766: ptd_credit_balance_e,
767: ytd_debit_balance_e,

Line 801: INSERT INTO gcs_entry_lines_gt

797: --Bugfix 5232063: Do not assume Financial Element is populated
798: --Bugfix 5329620: Added l_curr_where_clause
799: FORALL counter IN l_periods_list.FIRST..l_periods_list.LAST
800:
801: INSERT INTO gcs_entry_lines_gt
802: (entry_id, cal_period_id,
803: ptd_debit_balance_e,
804: ptd_credit_balance_e,
805: ytd_debit_balance_e,

Line 838: INSERT INTO gcs_entry_lines_gt

834: --Bugfix 5232063: Do not assume Financial Element is populated
835: --Bugfix 5329620: Added l_curr_where_clause
836: FORALL counter IN l_periods_list.FIRST..l_periods_list.LAST
837:
838: INSERT INTO gcs_entry_lines_gt
839: (entry_id, cal_period_id,
840: ptd_debit_balance_e,
841: ptd_credit_balance_e,
842: ytd_debit_balance_e,

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

960: BEGIN
961: SELECT 'Y'
962: INTO l_has_row_flag
963: FROM DUAL
964: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines_gt WHERE entry_id = l_entry_id);
965:
966: gcs_entry_pkg.create_entry_header
967: (x_errbuf => errbuf,
968: x_retcode => retcode,

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

1005: BEGIN
1006: SELECT 'Y'
1007: INTO l_has_stat_row_flag
1008: FROM DUAL
1009: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines_gt WHERE entry_id = l_stat_entry_id);
1010:
1011: gcs_entry_pkg.create_entry_header
1012: (x_errbuf => errbuf,
1013: x_retcode => retcode,

Line 1084: FROM gcs_entry_lines_gt fb,

1080: FND_GLOBAL.USER_ID,
1081: SYSDATE,
1082: FND_GLOBAL.USER_ID,
1083: FND_GLOBAL.LOGIN_ID
1084: FROM gcs_entry_lines_gt fb,
1085: fem_ln_items_attr flia,
1086: fem_ext_acct_types_attr fea_attr
1087: WHERE fb.line_item_id = flia.line_item_id
1088: AND flia.attribute_id = l_line_item_type_attr

Line 1124: FROM gcs_entry_lines_gt fb,

1120: FND_GLOBAL.USER_ID,
1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.LOGIN_ID
1124: FROM gcs_entry_lines_gt fb,
1125: fem_ln_items_attr flia,
1126: fem_ext_acct_types_attr fea_attr
1127: WHERE fb.line_item_id = flia.line_item_id
1128: AND flia.attribute_id = l_line_item_type_attr