DBA Data[Home] [Help]

APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on CN_MULTI_RATE_SCHEDULES_CUHK

Line 235: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_SCHEDULE_PRE

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,
238: p_dims_tbl => p_dims_tbl,
239: x_return_status => x_return_status,

Line 293: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_SCHEDULE_POST

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,
296: p_dims_tbl => p_dims_tbl,
297: x_return_status => x_return_status,

Line 443: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_SCHEDULE_PRE

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,
446: p_commission_unit_code => p_commission_unit_code,
447: p_object_version_number => p_object_version_number,

Line 505: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_SCHEDULE_POST

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,
508: p_commission_unit_code => p_commission_unit_code,
509: p_object_version_number => p_object_version_number,

Line 602: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_SCHEDULE_PRE

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,
605: x_msg_count => x_msg_count,
606: x_msg_data => x_msg_data);

Line 650: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_SCHEDULE_POST

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,
653: x_msg_count => x_msg_count,
654: x_msg_data => x_msg_data);

Line 764: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_ASSIGN_PRE

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,
767: p_rate_dim_sequence => p_rate_dim_sequence,
768: x_return_status => x_return_status,

Line 821: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_ASSIGN_POST

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,
824: p_rate_dim_sequence => p_rate_dim_sequence,
825: x_return_status => x_return_status,

Line 967: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_ASSIGN_PRE

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,
970: p_new_rate_dim_name => p_new_rate_dim_name,
971: p_rate_dim_sequence => p_rate_dim_sequence,

Line 1031: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_ASSIGN_POST

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,
1034: p_new_rate_dim_name => p_new_rate_dim_name,
1035: p_rate_dim_sequence => p_rate_dim_sequence,

Line 1132: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_ASSIGN_PRE

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,
1135: x_return_status => x_return_status,
1136: x_msg_count => x_msg_count,

Line 1184: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_ASSIGN_POST

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,
1187: x_return_status => x_return_status,
1188: x_msg_count => x_msg_count,

Line 1326: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_RATE_PRE

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,
1329: p_commission_amount => p_commission_amount,
1330: p_object_version_number => p_object_version_number,

Line 1378: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_RATE_POST

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,
1381: p_commission_amount => p_commission_amount,
1382: p_object_version_number => p_object_version_number,

Line 1503: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_PRE

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,
1506: p_dim_unit_code => p_dim_unit_code,
1507: p_tiers_tbl => p_tiers_tbl,

Line 1565: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_DIMENSION_POST

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,
1568: p_dim_unit_code => p_dim_unit_code,
1569: p_tiers_tbl => p_tiers_tbl,

Line 1729: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_PRE

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,
1732: p_description => p_description,
1733: p_dim_unit_code => p_dim_unit_code,

Line 1798: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_POST

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,
1801: p_description => p_description,
1802: p_dim_unit_code => p_dim_unit_code,

Line 1896: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_PRE

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,
1899: x_msg_count => x_msg_count,
1900: x_msg_data => x_msg_data);

Line 1944: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_POST

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,
1947: x_msg_count => x_msg_count,
1948: x_msg_data => x_msg_data);

Line 2069: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_TIER_PRE

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,
2072: p_value2 => p_value2,
2073: p_tier_sequence => p_tier_sequence,

Line 2134: CN_MULTI_RATE_SCHEDULES_CUHK.CREATE_TIER_POST

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,
2137: p_value2 => p_value2,
2138: p_tier_sequence => p_tier_sequence,

Line 2275: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_TIER_PRE

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,
2278: p_value1 => p_value1,
2279: p_value2 => p_value2,

Line 2341: CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_TIER_POST

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,
2344: p_value1 => p_value1,
2345: p_value2 => p_value2,

Line 2440: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_TIER_PRE

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,
2443: x_return_status => x_return_status,
2444: x_msg_count => x_msg_count,

Line 2488: CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_TIER_POST

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,
2491: x_return_status => x_return_status,
2492: x_msg_count => x_msg_count,