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 CN_API

Line 353: cn_api.g_miss_char,

349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
352: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
353: cn_api.g_miss_char,
354: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
355: cn_api.g_miss_char,
356: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
357: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,

Line 355: cn_api.g_miss_char,

351: p_original_name IN CN_RATE_SCHEDULES.NAME%TYPE,
352: p_new_name IN CN_RATE_SCHEDULES.NAME%TYPE :=
353: cn_api.g_miss_char,
354: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
355: cn_api.g_miss_char,
356: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
357: p_dims_tbl IN dim_assign_tbl_type := g_miss_dim_assign_tbl,
358: -- Start - MOAC Change
359: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE,

Line 427: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),

423: select commission_unit_code into l_original_comm_unit_code
424: from cn_rate_schedules
425: where rate_schedule_id = l_rate_schedule_id;
426:
427: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
428: decode(p_commission_unit_code, cn_api.g_miss_char,
429: l_original_comm_unit_code, p_commission_unit_code)
430: into l_name, l_comm_unit_code from dual;
431:

Line 428: decode(p_commission_unit_code, cn_api.g_miss_char,

424: from cn_rate_schedules
425: where rate_schedule_id = l_rate_schedule_id;
426:
427: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
428: decode(p_commission_unit_code, cn_api.g_miss_char,
429: l_original_comm_unit_code, p_commission_unit_code)
430: into l_name, l_comm_unit_code from dual;
431:
432: -- get ID's in the dims_tbl to pass on to private API

Line 882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,

878: p_commit IN VARCHAR2 := FND_API.G_FALSE,
879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,
885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
886: -- Start - MOAC Change

Line 884: cn_api.g_miss_num,

880: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,
885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
886: -- Start - MOAC Change
887: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
888: -- End - MOAC Change

Line 957: if p_new_rate_dim_name <> cn_api.g_miss_char then

953: from cn_rate_sch_dims
954: where rate_sch_dim_id = l_rate_sch_dim_id;
955:
956: -- get new rate dim name if necessary
957: if p_new_rate_dim_name <> cn_api.g_miss_char then
958: l_rate_dimension_id := get_rate_dimension_id(p_new_rate_dim_name);
959: end if;
960:
961: if p_rate_dim_sequence <> cn_api.g_miss_num then

Line 961: if p_rate_dim_sequence <> cn_api.g_miss_num then

957: if p_new_rate_dim_name <> cn_api.g_miss_char then
958: l_rate_dimension_id := get_rate_dimension_id(p_new_rate_dim_name);
959: end if;
960:
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',

Line 1626: cn_api.g_miss_char,

1622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1623: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1624: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1625: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
1626: cn_api.g_miss_char,
1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
1628: cn_api.g_miss_char,
1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
1630: cn_api.g_miss_char,

Line 1628: cn_api.g_miss_char,

1624: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1625: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
1626: cn_api.g_miss_char,
1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
1628: cn_api.g_miss_char,
1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
1630: cn_api.g_miss_char,
1631: p_tiers_tbl IN rate_tier_tbl_type :=
1632: g_miss_rate_tier_tbl,

Line 1630: cn_api.g_miss_char,

1626: cn_api.g_miss_char,
1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
1628: cn_api.g_miss_char,
1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
1630: cn_api.g_miss_char,
1631: p_tiers_tbl IN rate_tier_tbl_type :=
1632: g_miss_rate_tier_tbl,
1633: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
1634: -- Start - MOAC Change

Line 1707: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),

1703:
1704: select description into l_description from cn_rate_dimensions
1705: where rate_dimension_id = l_rate_dimension_id;
1706:
1707: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
1708: decode(p_description, cn_api.g_miss_char, l_description, p_description)
1709: into l_name, l_description from dual;
1710:
1711: -- build l_tiers_tbl from the p_tiers_tbl

Line 1708: decode(p_description, cn_api.g_miss_char, l_description, p_description)

1704: select description into l_description from cn_rate_dimensions
1705: where rate_dimension_id = l_rate_dimension_id;
1706:
1707: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
1708: decode(p_description, cn_api.g_miss_char, l_description, p_description)
1709: into l_name, l_description from dual;
1710:
1711: -- build l_tiers_tbl from the p_tiers_tbl
1712: if p_tiers_tbl.count > 0 then