eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on JTF_USR_HKS

Line 233: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

229: l_dims_tbl(i).rate_dim_sequence := p_dims_tbl(i).rate_dim_sequence;
230: end loop;
231: end if;
232:
233: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
234: 'CREATE_SCHEDULE', 'B', 'C') then
235: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_SCHEDULE_PRE
236: (p_name => p_name,
237: p_commission_unit_code => p_commission_unit_code,

Line 246: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

242:
243: check_ret_sts(x_return_status);
244: end if;
245:
246: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
247: 'CREATE_SCHEDULE', 'B', 'V') then
248: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_SCHEDULE_PRE
249: (p_name => p_name,
250: p_commission_unit_code => p_commission_unit_code,

Line 278: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

274: x_msg_data => x_msg_data);
275:
276: check_ret_sts(x_return_status);
277:
278: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
279: 'CREATE_SCHEDULE', 'A', 'V') then
280: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_SCHEDULE_POST
281: (p_name => p_name,
282: p_commission_unit_code => p_commission_unit_code,

Line 291: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

287:
288: check_ret_sts(x_return_status);
289: end if;
290:
291: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
292: 'CREATE_SCHEDULE', 'A', 'C') then
293: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_SCHEDULE_POST
294: (p_name => p_name,
295: p_commission_unit_code => p_commission_unit_code,

Line 441: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

437: l_dims_tbl(i).rate_dim_sequence := p_dims_tbl(i).rate_dim_sequence;
438: end loop;
439: end if;
440:
441: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
442: 'UPDATE_SCHEDULE', 'B', 'C') then
443: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_SCHEDULE_PRE
444: (p_original_name => p_original_name,
445: p_new_name => p_new_name,

Line 455: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

451:
452: check_ret_sts(x_return_status);
453: end if;
454:
455: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
456: 'UPDATE_SCHEDULE', 'B', 'V') then
457: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_SCHEDULE_PRE
458: (p_original_name => p_original_name,
459: p_new_name => p_new_name,

Line 489: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

485: x_msg_data => x_msg_data);
486:
487: check_ret_sts(x_return_status);
488:
489: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
490: 'UPDATE_SCHEDULE', 'A', 'V') then
491: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_SCHEDULE_POST
492: (p_original_name => p_original_name,
493: p_new_name => p_new_name,

Line 503: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

499:
500: check_ret_sts(x_return_status);
501: end if;
502:
503: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
504: 'UPDATE_SCHEDULE', 'A', 'C') then
505: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_SCHEDULE_POST
506: (p_original_name => p_original_name,
507: p_new_name => p_new_name,

Line 600: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

596:
597: -- validate ID
598: l_rate_schedule_id := get_rate_schedule_id(p_name);
599:
600: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
601: 'DELETE_SCHEDULE', 'B', 'C') then
602: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_SCHEDULE_PRE
603: (p_name => p_name,
604: x_return_status => x_return_status,

Line 611: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

607:
608: check_ret_sts(x_return_status);
609: end if;
610:
611: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
612: 'DELETE_SCHEDULE', 'B', 'V') then
613: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_SCHEDULE_PRE
614: (p_name => p_name,
615: x_return_status => x_return_status,

Line 637: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

633: x_msg_data => x_msg_data);
634:
635: check_ret_sts(x_return_status);
636:
637: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
638: 'DELETE_SCHEDULE', 'A', 'V') then
639: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_SCHEDULE_POST
640: (p_name => p_name,
641: x_return_status => x_return_status,

Line 648: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

644:
645: check_ret_sts(x_return_status);
646: end if;
647:
648: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
649: 'DELETE_SCHEDULE', 'A', 'C') then
650: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_SCHEDULE_POST
651: (p_name => p_name,
652: x_return_status => x_return_status,

Line 762: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

758: -- look up ID's
759: l_rate_schedule_id := get_rate_schedule_id (p_rate_schedule_name);
760: l_rate_dimension_id := get_rate_dimension_id(p_rate_dimension_name);
761:
762: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
763: 'CREATE_DIMENSION_ASSIGN', 'B', 'C') then
764: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_ASSIGN_PRE
765: (p_rate_schedule_name => p_rate_schedule_name,
766: p_rate_dimension_name => p_rate_dimension_name,

Line 775: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

771:
772: check_ret_sts(x_return_status);
773: end if;
774:
775: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
776: 'CREATE_DIMENSION_ASSIGN', 'B', 'V') then
777: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_DIMENSION_ASSIGN_PRE
778: (p_rate_schedule_name => p_rate_schedule_name,
779: p_rate_dimension_name => p_rate_dimension_name,

Line 806: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

802: x_msg_data => x_msg_data);
803:
804: check_ret_sts(x_return_status);
805:
806: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
807: 'CREATE_DIMENSION_ASSIGN', 'A', 'V') then
808: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_DIMENSION_ASSIGN_POST
809: (p_rate_schedule_name => p_rate_schedule_name,
810: p_rate_dimension_name => p_rate_dimension_name,

Line 819: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

815:
816: check_ret_sts(x_return_status);
817: end if;
818:
819: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
820: 'CREATE_DIMENSION_ASSIGN', 'A', 'C') then
821: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_ASSIGN_POST
822: (p_rate_schedule_name => p_rate_schedule_name,
823: p_rate_dimension_name => p_rate_dimension_name,

Line 965: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

961: if p_rate_dim_sequence <> cn_api.g_miss_num then
962: l_rate_dim_sequence := p_rate_dim_sequence;
963: end if;
964:
965: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
966: 'UPDATE_DIMENSION_ASSIGN', 'B', 'C') then
967: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_ASSIGN_PRE
968: (p_rate_schedule_name => p_rate_schedule_name,
969: p_orig_rate_dim_name => p_orig_rate_dim_name,

Line 980: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

976:
977: check_ret_sts(x_return_status);
978: end if;
979:
980: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
981: 'UPDATE_DIMENSION_ASSIGN', 'B', 'V') then
982: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_ASSIGN_PRE
983: (p_rate_schedule_name => p_rate_schedule_name,
984: p_orig_rate_dim_name => p_orig_rate_dim_name,

Line 1014: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1010: x_msg_data => x_msg_data);
1011:
1012: check_ret_sts(x_return_status);
1013:
1014: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1015: 'UPDATE_DIMENSION_ASSIGN', 'A', 'V') then
1016: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_ASSIGN_POST
1017: (p_rate_schedule_name => p_rate_schedule_name,
1018: p_orig_rate_dim_name => p_orig_rate_dim_name,

Line 1029: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1025:
1026: check_ret_sts(x_return_status);
1027: end if;
1028:
1029: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1030: 'UPDATE_DIMENSION_ASSIGN', 'A', 'C') then
1031: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_ASSIGN_POST
1032: (p_rate_schedule_name => p_rate_schedule_name,
1033: p_orig_rate_dim_name => p_orig_rate_dim_name,

Line 1130: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1126: l_rate_schedule_id := get_rate_schedule_id (p_rate_schedule_name);
1127: l_rate_dimension_id := get_rate_dimension_id(p_rate_dimension_name);
1128: l_rate_sch_dim_id := get_rate_sch_dim_id (l_rate_schedule_id, l_rate_dimension_id);
1129:
1130: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1131: 'DELETE_DIMENSION_ASSIGN', 'B', 'C') then
1132: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_ASSIGN_PRE
1133: (p_rate_schedule_name => p_rate_schedule_name,
1134: p_rate_dimension_name => p_rate_dimension_name,

Line 1142: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1138:
1139: check_ret_sts(x_return_status);
1140: end if;
1141:
1142: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1143: 'DELETE_DIMENSION_ASSIGN', 'B', 'V') then
1144: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_ASSIGN_PRE
1145: (p_rate_schedule_name => p_rate_schedule_name,
1146: p_rate_dimension_name => p_rate_dimension_name,

Line 1170: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1166: x_msg_data => x_msg_data);
1167:
1168: check_ret_sts(x_return_status);
1169:
1170: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1171: 'DELETE_DIMENSION_ASSIGN', 'A', 'V') then
1172: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_ASSIGN_POST
1173: (p_rate_schedule_name => p_rate_schedule_name,
1174: p_rate_dimension_name => p_rate_dimension_name,

Line 1182: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1178:
1179: check_ret_sts(x_return_status);
1180: end if;
1181:
1182: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1183: 'DELETE_DIMENSION_ASSIGN', 'A', 'C') then
1184: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_ASSIGN_POST
1185: (p_rate_schedule_name => p_rate_schedule_name,
1186: p_rate_dimension_name => p_rate_dimension_name,

Line 1324: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1320: x_rate_sequence => l_rate_sequence,
1321: x_commission_amount => l_commission_amount, -- not used
1322: x_object_version_number => l_object_version_number); -- not used
1323:
1324: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1325: 'UPDATE_RATE', 'B', 'C') then
1326: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_RATE_PRE
1327: (p_rate_schedule_name => p_rate_schedule_name,
1328: p_tier_coordinates_tbl => p_tier_coordinates_tbl,

Line 1338: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1334:
1335: check_ret_sts(x_return_status);
1336: end if;
1337:
1338: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1339: 'UPDATE_RATE', 'B', 'V') then
1340: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_RATE_PRE
1341: (p_rate_schedule_name => p_rate_schedule_name,
1342: p_tier_coordinates_tbl => p_tier_coordinates_tbl,

Line 1362: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1358: p_org_id => p_org_id);
1359: -- End - MOAC Change
1360:
1361:
1362: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1363: 'UPDATE_RATE', 'A', 'V') then
1364: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_RATE_POST
1365: (p_rate_schedule_name => p_rate_schedule_name,
1366: p_tier_coordinates_tbl => p_tier_coordinates_tbl,

Line 1376: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1372:
1373: check_ret_sts(x_return_status);
1374: end if;
1375:
1376: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1377: 'UPDATE_RATE', 'A', 'C') then
1378: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_RATE_POST
1379: (p_rate_schedule_name => p_rate_schedule_name,
1380: p_tier_coordinates_tbl => p_tier_coordinates_tbl,

Line 1501: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1497: l_tiers_tbl(i).string_value);
1498: end loop;
1499: end if;
1500:
1501: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1502: 'CREATE_DIMENSION', 'B', 'C') then
1503: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_PRE
1504: (p_name => p_name,
1505: p_description => p_description,

Line 1515: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1511:
1512: check_ret_sts(x_return_status);
1513: end if;
1514:
1515: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1516: 'CREATE_DIMENSION', 'B', 'V') then
1517: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_DIMENSION_PRE
1518: (p_name => p_name,
1519: p_description => p_description,

Line 1549: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1545: x_msg_data => x_msg_data);
1546:
1547: check_ret_sts(x_return_status);
1548:
1549: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1550: 'CREATE_DIMENSION', 'A', 'V') then
1551: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_DIMENSION_POST
1552: (p_name => p_name,
1553: p_description => p_description,

Line 1563: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1559:
1560: check_ret_sts(x_return_status);
1561: end if;
1562:
1563: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1564: 'CREATE_DIMENSION', 'A', 'C') then
1565: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_POST
1566: (p_name => p_name,
1567: p_description => p_description,

Line 1727: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1723: l_tiers_tbl(i).object_version_number := p_tiers_tbl(i).object_version_number;
1724: end loop;
1725: end if;
1726:
1727: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1728: 'UPDATE_DIMENSION', 'B', 'C') then
1729: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_PRE
1730: (p_original_name => p_original_name,
1731: p_new_name => p_new_name,

Line 1743: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1739:
1740: check_ret_sts(x_return_status);
1741: end if;
1742:
1743: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1744: 'UPDATE_DIMENSION', 'B', 'V') then
1745: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_PRE
1746: (p_original_name => p_original_name,
1747: p_new_name => p_new_name,

Line 1780: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1776: x_msg_data => x_msg_data);
1777:
1778: check_ret_sts(x_return_status);
1779:
1780: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1781: 'UPDATE_DIMENSION', 'A', 'V') then
1782: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_POST
1783: (p_original_name => p_original_name,
1784: p_new_name => p_new_name,

Line 1796: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1792:
1793: check_ret_sts(x_return_status);
1794: end if;
1795:
1796: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1797: 'UPDATE_DIMENSION', 'A', 'C') then
1798: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_POST
1799: (p_original_name => p_original_name,
1800: p_new_name => p_new_name,

Line 1894: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1890: -- API body
1891:
1892: l_rate_dimension_id := get_rate_dimension_id(p_name);
1893:
1894: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1895: 'DELETE_DIMENSION', 'B', 'C') then
1896: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_PRE
1897: (p_name => p_name,
1898: x_return_status => x_return_status,

Line 1905: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1901:
1902: check_ret_sts(x_return_status);
1903: end if;
1904:
1905: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1906: 'DELETE_DIMENSION', 'B', 'V') then
1907: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_PRE
1908: (p_name => p_name,
1909: x_return_status => x_return_status,

Line 1931: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1927: x_msg_data => x_msg_data);
1928:
1929: check_ret_sts(x_return_status);
1930:
1931: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1932: 'DELETE_DIMENSION', 'A', 'V') then
1933: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_POST
1934: (p_name => p_name,
1935: x_return_status => x_return_status,

Line 1942: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

1938:
1939: check_ret_sts(x_return_status);
1940: end if;
1941:
1942: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
1943: 'DELETE_DIMENSION', 'A', 'C') then
1944: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_POST
1945: (p_name => p_name,
1946: x_return_status => x_return_status,

Line 2067: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2063:
2064: translate_values(l_dim_unit_code, p_value1, p_value2, l_minimum_amount, l_maximum_amount,
2065: l_min_exp_id, l_max_exp_id, l_string_value);
2066:
2067: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2068: 'CREATE_TIER', 'B', 'C') then
2069: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_TIER_PRE
2070: (p_dimension_name => p_dimension_name,
2071: p_value1 => p_value1,

Line 2081: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2077:
2078: check_ret_sts(x_return_status);
2079: end if;
2080:
2081: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2082: 'CREATE_TIER', 'B', 'V') then
2083: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_TIER_PRE
2084: (p_dimension_name => p_dimension_name,
2085: p_value1 => p_value1,

Line 2118: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2114: x_msg_data => x_msg_data);
2115:
2116: check_ret_sts(x_return_status);
2117:
2118: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2119: 'CREATE_TIER', 'A', 'V') then
2120: CN_MULTI_RATE_SCHEDULES_VUHK.CREATE_TIER_POST
2121: (p_dimension_name => p_dimension_name,
2122: p_value1 => p_value1,

Line 2132: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2128:
2129: check_ret_sts(x_return_status);
2130: end if;
2131:
2132: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2133: 'CREATE_TIER', 'A', 'C') then
2134: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_TIER_POST
2135: (p_dimension_name => p_dimension_name,
2136: p_value1 => p_value1,

Line 2273: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2269:
2270: translate_values(l_dim_unit_code, p_value1, p_value2, l_minimum_amount, l_maximum_amount,
2271: l_min_exp_id, l_max_exp_id, l_string_value);
2272:
2273: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2274: 'UPDATE_TIER', 'B', 'C') then
2275: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_TIER_PRE
2276: (p_dimension_name => p_dimension_name,
2277: p_tier_sequence => p_tier_sequence,

Line 2288: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2284:
2285: check_ret_sts(x_return_status);
2286: end if;
2287:
2288: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2289: 'UPDATE_TIER', 'B', 'V') then
2290: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_TIER_PRE
2291: (p_dimension_name => p_dimension_name,
2292: p_tier_sequence => p_tier_sequence,

Line 2324: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2320: x_msg_data => x_msg_data);
2321:
2322: check_ret_sts(x_return_status);
2323:
2324: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2325: 'UPDATE_TIER', 'A', 'V') then
2326: CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_TIER_POST
2327: (p_dimension_name => p_dimension_name,
2328: p_tier_sequence => p_tier_sequence,

Line 2339: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2335:
2336: check_ret_sts(x_return_status);
2337: end if;
2338:
2339: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2340: 'UPDATE_TIER', 'A', 'C') then
2341: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_TIER_POST
2342: (p_dimension_name => p_dimension_name,
2343: p_tier_sequence => p_tier_sequence,

Line 2438: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2434:
2435: l_rate_dimension_id := get_rate_dimension_id(p_dimension_name);
2436: l_rate_dim_tier_id := get_rate_dim_tier_id(l_rate_dimension_id, p_tier_sequence);
2437:
2438: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2439: 'DELETE_TIER', 'B', 'C') then
2440: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_TIER_PRE
2441: (p_dimension_name => p_dimension_name,
2442: p_tier_sequence => p_tier_sequence,

Line 2450: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2446:
2447: check_ret_sts(x_return_status);
2448: end if;
2449:
2450: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2451: 'DELETE_TIER', 'B', 'V') then
2452: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_TIER_PRE
2453: (p_dimension_name => p_dimension_name,
2454: p_tier_sequence => p_tier_sequence,

Line 2474: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2470: x_msg_data => x_msg_data);
2471:
2472: check_ret_sts(x_return_status);
2473:
2474: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2475: 'DELETE_TIER', 'A', 'V') then
2476: CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_TIER_POST
2477: (p_dimension_name => p_dimension_name,
2478: p_tier_sequence => p_tier_sequence,

Line 2486: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',

2482:
2483: check_ret_sts(x_return_status);
2484: end if;
2485:
2486: if JTF_USR_HKS.Ok_to_Execute('CN_MULTI_RATE_SCHEDULES_PUB',
2487: 'DELETE_TIER', 'A', 'C') then
2488: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_TIER_POST
2489: (p_dimension_name => p_dimension_name,
2490: p_tier_sequence => p_tier_sequence,