APPS.GCS_DATA_PREP_PKG dependencies on GCS_ENTRY_HEADERS_S

Line 690: SELECT gcs_entry_headers_s.nextval INTO l_entry_id FROM dual;

686: AND gcer.balance_type_code = p_balance_type_code
687: AND gcer.most_recent_flag = 'Y');
688:
689: IF (l_prior_entry_id IS NOT NULL) THEN
690: SELECT gcs_entry_headers_s.nextval INTO l_entry_id FROM dual;
691:
692: gcs_entry_pkg.create_entry_header(x_errbuf => l_errbuf,
693: x_retcode => l_retcode,
694: p_entry_id => l_entry_id,

Line 707: SELECT gcs_entry_headers_s.nextval INTO l_stat_entry_id FROM dual;

703: p_category_code => 'DATAPREPARATION');
704: END IF;
705:
706: IF (l_prior_stat_entry_id IS NOT NULL) THEN
707: SELECT gcs_entry_headers_s.nextval INTO l_stat_entry_id FROM dual;
708:
709: gcs_entry_pkg.create_entry_header(x_errbuf => l_errbuf,
710: x_retcode => l_retcode,
711: p_entry_id => l_stat_entry_id,

Line 2097: SELECT gcs_entry_headers_s.NEXTVAL

2093: IF l_periods_list.FIRST IS NULL THEN
2094: RAISE no_data_error;
2095: END IF;
2096:
2097: SELECT gcs_entry_headers_s.NEXTVAL
2098: INTO l_entry_id
2099: FROM DUAL;
2100: SELECT gcs_entry_headers_s.NEXTVAL
2101: INTO l_stat_entry_id

Line 2100: SELECT gcs_entry_headers_s.NEXTVAL

2096:
2097: SELECT gcs_entry_headers_s.NEXTVAL
2098: INTO l_entry_id
2099: FROM DUAL;
2100: SELECT gcs_entry_headers_s.NEXTVAL
2101: INTO l_stat_entry_id
2102: FROM DUAL;
2103:
2104: -------------------------------------------

Line 2252: SELECT gcs_entry_headers_s.NEXTVAL

2248: p_process_code => ''SINGLE_RUN_FOR_PERIOD'',
2249: p_category_code => ''DATAPREPARATION''
2250: );
2251: IF p_owner_percentage IS NOT NULL AND p_owner_percentage <> 1 THEN
2252: SELECT gcs_entry_headers_s.NEXTVAL
2253: INTO l_proportional_entry_id
2254: FROM DUAL;
2255:
2256: gcs_entry_pkg.create_entry_header

Line 2298: SELECT gcs_entry_headers_s.NEXTVAL

2294: p_category_code => ''DATAPREPARATION''
2295: );
2296:
2297: IF p_owner_percentage IS NOT NULL AND p_owner_percentage <> 1 THEN
2298: SELECT gcs_entry_headers_s.NEXTVAL
2299: INTO l_stat_proportional_entry_id
2300: FROM DUAL;
2301:
2302: gcs_entry_pkg.create_entry_header

Line 2829: SELECT gcs_entry_headers_s.NEXTVAL

2825: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)
2826: THEN
2827: RAISE init_mapping_error;
2828: END IF;
2829: SELECT gcs_entry_headers_s.NEXTVAL
2830: INTO x_entry_id
2831: FROM DUAL;
2832: SELECT gcs_entry_headers_s.NEXTVAL
2833: INTO x_stat_entry_id

Line 2832: SELECT gcs_entry_headers_s.NEXTVAL

2828: END IF;
2829: SELECT gcs_entry_headers_s.NEXTVAL
2830: INTO x_entry_id
2831: FROM DUAL;
2832: SELECT gcs_entry_headers_s.NEXTVAL
2833: INTO x_stat_entry_id
2834: FROM DUAL;
2835: IF (l_mapping_required = ''N'') THEN
2836: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 2952: SELECT gcs_entry_headers_s.NEXTVAL

2948: null;
2949: END;
2950: IF l_has_stat_row_flag = ''Y'' THEN
2951: if p_owner_percentage <> 1 THEN
2952: SELECT gcs_entry_headers_s.NEXTVAL
2953: INTO x_stat_prop_entry_id
2954: FROM DUAL;
2955: END IF;
2956: ELSE

Line 2961: SELECT gcs_entry_headers_s.NEXTVAL

2957: x_stat_entry_id := NULL;
2958: END IF;
2959: IF l_has_row_flag = ''Y'' THEN
2960: if p_owner_percentage <> 1 THEN
2961: SELECT gcs_entry_headers_s.NEXTVAL
2962: INTO x_prop_entry_id
2963: FROM DUAL;
2964: END IF;
2965: ELSE