DBA Data[Home] [Help]

APPS.GCS_DP_DYNAMIC_PKG dependencies on GCS_ENTRY_HEADERS_S

Line 713: SELECT gcs_entry_headers_s.NEXTVAL

709: IF l_periods_list.FIRST IS NULL THEN
710: RAISE no_data_error;
711: END IF;
712:
713: SELECT gcs_entry_headers_s.NEXTVAL
714: INTO l_entry_id
715: FROM DUAL;
716: SELECT gcs_entry_headers_s.NEXTVAL
717: INTO l_stat_entry_id

Line 716: SELECT gcs_entry_headers_s.NEXTVAL

712:
713: SELECT gcs_entry_headers_s.NEXTVAL
714: INTO l_entry_id
715: FROM DUAL;
716: SELECT gcs_entry_headers_s.NEXTVAL
717: INTO l_stat_entry_id
718: FROM DUAL;
719:
720: -------------------------------------------

Line 981: SELECT gcs_entry_headers_s.NEXTVAL

977: p_process_code => 'SINGLE_RUN_FOR_PERIOD',
978: p_category_code => 'DATAPREPARATION'
979: );
980: IF p_owner_percentage IS NOT NULL AND p_owner_percentage <> 1 THEN
981: SELECT gcs_entry_headers_s.NEXTVAL
982: INTO l_proportional_entry_id
983: FROM DUAL;
984:
985: gcs_entry_pkg.create_entry_header

Line 1027: SELECT gcs_entry_headers_s.NEXTVAL

1023: p_category_code => 'DATAPREPARATION'
1024: );
1025:
1026: IF p_owner_percentage IS NOT NULL AND p_owner_percentage <> 1 THEN
1027: SELECT gcs_entry_headers_s.NEXTVAL
1028: INTO l_stat_proportional_entry_id
1029: FROM DUAL;
1030:
1031: gcs_entry_pkg.create_entry_header

Line 1586: SELECT gcs_entry_headers_s.NEXTVAL

1582: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)
1583: THEN
1584: RAISE init_mapping_error;
1585: END IF;
1586: SELECT gcs_entry_headers_s.NEXTVAL
1587: INTO x_entry_id
1588: FROM DUAL;
1589: SELECT gcs_entry_headers_s.NEXTVAL
1590: INTO x_stat_entry_id

Line 1589: SELECT gcs_entry_headers_s.NEXTVAL

1585: END IF;
1586: SELECT gcs_entry_headers_s.NEXTVAL
1587: INTO x_entry_id
1588: FROM DUAL;
1589: SELECT gcs_entry_headers_s.NEXTVAL
1590: INTO x_stat_entry_id
1591: FROM DUAL;
1592: IF (l_mapping_required = 'N') THEN
1593: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 1796: SELECT gcs_entry_headers_s.NEXTVAL

1792: null;
1793: END;
1794: IF l_has_stat_row_flag = 'Y' THEN
1795: if p_owner_percentage <> 1 THEN
1796: SELECT gcs_entry_headers_s.NEXTVAL
1797: INTO x_stat_prop_entry_id
1798: FROM DUAL;
1799: END IF;
1800: ELSE

Line 1805: SELECT gcs_entry_headers_s.NEXTVAL

1801: x_stat_entry_id := NULL;
1802: END IF;
1803: IF l_has_row_flag = 'Y' THEN
1804: if p_owner_percentage <> 1 THEN
1805: SELECT gcs_entry_headers_s.NEXTVAL
1806: INTO x_prop_entry_id
1807: FROM DUAL;
1808: END IF;
1809: ELSE