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
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: -------------------------------------------
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
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
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
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
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
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