APPS.CN_CALC_FORMULAS_PVT dependencies on DUAL

Line 99: -- 'INDIVIDUAL' amd cumulative_flag = 'N' and itd_flag = 'N'

95: RAISE fnd_api.g_exc_error;
96: END IF;
97:
98: -- 5. make sure BONUS type formulas always have trx_group_code =
99: -- 'INDIVIDUAL' amd cumulative_flag = 'N' and itd_flag = 'N'
100: IF (p_formula_type = 'B' AND (p_trx_group_code = 'GROUP' OR
101: p_itd_flag = 'Y' OR p_cumulative_flag = 'Y')) THEN
102: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
103: fnd_message.set_name('CN', 'CN_BONUS_CONSTRAINT');

Line 110: -- trx_group_code = 'INDIVIDUAL' and cumulative_flag = 'Y',

106: RAISE fnd_api.g_exc_error;
107: END IF;
108:
109: -- 6. make sure THRESHOLD formulas have the following flag setting:
110: -- trx_group_code = 'INDIVIDUAL' and cumulative_flag = 'Y',
111: -- itd_flag = 'N' and split_flag = 'N'
112: IF (p_threshold_all_tier_flag = 'Y' AND
113: (p_trx_group_code = 'GROUP' or p_cumulative_flag = 'N' or
114: p_split_flag = 'Y' OR p_formula_type = 'B')) THEN

Line 654: FROM dual;

650: /* End - R12 Notes History */
651:
652: CURSOR c_next_srp_qut_id IS
653: SELECT cn_srp_period_quotas_ext_s.NEXTVAL
654: FROM dual;
655:
656: CURSOR c_srp_quota_detail IS
657: select spq.srp_period_quota_id
658: from cn_quotas_v qut, cn_srp_period_quotas spq

Line 1467: FROM dual

1463: /* End - R12 Notes History */
1464:
1465: CURSOR parent_exist IS
1466: SELECT 1
1467: FROM dual
1468: WHERE exists (SELECT 1 FROM cn_calc_edges
1469: WHERE child_id = p_calc_formula_id
1470: AND edge_type = 'FE');
1471: BEGIN

Line 1817: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'Y') THEN

1813: fnd_msg_pub.ADD;
1814: END IF;
1815: RAISE fnd_api.g_exc_error;
1816: ELSE
1817: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'Y') THEN
1818: IF (l_exp_type_code NOT IN ('IO', 'IIIO', 'IOGOBOFO', 'IIIOIPGP', 'IOGOBO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1819: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1820: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');
1821: fnd_msg_pub.ADD;

Line 1825: ELSIF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'N') THEN

1821: fnd_msg_pub.ADD;
1822: END IF;
1823: RAISE fnd_api.g_exc_error;
1824: END IF;
1825: ELSIF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'N') THEN
1826: IF (l_exp_type_code NOT IN ('IO', 'IO_ITDN', 'IIIO', 'IIIOIPGP', 'IOGOBOFO', 'IOGOBO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1827: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1828: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');
1829: fnd_msg_pub.ADD;

Line 1861: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL') THEN

1857: fnd_msg_pub.ADD;
1858: END IF;
1859: RAISE fnd_api.g_exc_error;
1860: ELSE
1861: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL') THEN
1862: IF (input.exp_type_code NOT IN ('IIIOIPGP', 'IIIO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1863: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1864: fnd_message.set_name('CN', 'CN_UNMATCHED_INPUT');
1865: fnd_msg_pub.ADD;

Line 1897: -- Commission type formulas with trx_group_code = 'INDIVIDUAL' must have at

1893:
1894: l_input_count := l_input_count + 1;
1895: END LOOP;
1896:
1897: -- Commission type formulas with trx_group_code = 'INDIVIDUAL' must have at
1898: -- least one column from cn_commission_lines/headers
1899: -- in one of its input definition
1900: IF (l_ii_flag <> 'Y') THEN
1901: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN