APPS.GCS_DP_DYNAMIC_PKG dependencies on DUAL

Line 715: FROM DUAL;

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
718: FROM DUAL;
719:

Line 718: FROM DUAL;

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: -------------------------------------------
721: -- this is the mapping not required case --
722: -------------------------------------------

Line 963: FROM DUAL

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

Line 983: FROM DUAL;

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
986: (x_errbuf => errbuf,
987: x_retcode => retcode,

Line 1008: FROM DUAL

1004: END;
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,

Line 1029: FROM DUAL;

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
1032: (x_errbuf => errbuf,
1033: x_retcode => retcode,

Line 1588: FROM DUAL;

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
1591: FROM DUAL;
1592: IF (l_mapping_required = 'N') THEN

Line 1591: FROM DUAL;

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
1594: THEN
1595: fnd_log.STRING (fnd_log.level_statement,

Line 1733: FROM DUAL

1729:
1730: BEGIN
1731: SELECT 'Y'
1732: INTO l_has_row_flag
1733: FROM DUAL
1734: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines WHERE entry_id = x_entry_id);
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN
1737: l_has_row_flag := 'N';

Line 1742: FROM DUAL

1738: END;
1739: BEGIN
1740: SELECT 'Y'
1741: INTO l_has_stat_row_flag
1742: FROM DUAL
1743: WHERE EXISTS (SELECT 1 FROM gcs_entry_lines WHERE entry_id = x_stat_entry_id);
1744: EXCEPTION
1745: WHEN NO_DATA_FOUND THEN
1746: l_has_stat_row_flag := 'N';

Line 1798: FROM DUAL;

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;

Line 1807: FROM DUAL;

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
1810: x_entry_id := NULL;
1811: END IF;