DBA Data[Home] [Help]

APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_CHK_PLAN_ELEMENT_PKG

Line 1: PACKAGE BODY CN_CHK_PLAN_ELEMENT_PKG AS

1: PACKAGE BODY CN_CHK_PLAN_ELEMENT_PKG AS
2: /* $Header: cnchkpeb.pls 120.5 2005/10/17 05:30:54 chanthon ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_CHK_PLAN_ELEMENT_PKG';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnchkpeb.pls';
5:

Line 3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_CHK_PLAN_ELEMENT_PKG';

1: PACKAGE BODY CN_CHK_PLAN_ELEMENT_PKG AS
2: /* $Header: cnchkpeb.pls 120.5 2005/10/17 05:30:54 chanthon ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_CHK_PLAN_ELEMENT_PKG';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnchkpeb.pls';
5:
6: -- ----------------------------------------------------------------------------+
7: -- Procedure: valid_rate_table

Line 2857: p_plan_element IN cn_chk_plan_element_pkg.pe_rec_type --cn_plan_element_pvt.plan_element_rec_type

2853: END IF;
2854: END check_create_pe_self_ref;
2855:
2856: PROCEDURE validate_formula (
2857: p_plan_element IN cn_chk_plan_element_pkg.pe_rec_type --cn_plan_element_pvt.plan_element_rec_type
2858: )
2859: IS
2860: l_loading_status VARCHAR2 (100);
2861: x_return_status VARCHAR2 (100);

Line 2895: cn_chk_plan_element_pkg.chk_formula_quota_pe (x_return_status => x_return_status,

2891: END;
2892:
2893: -- if Quota type is Formula, then Formula is Mandatory and
2894: -- Package name must be null
2895: cn_chk_plan_element_pkg.chk_formula_quota_pe (x_return_status => x_return_status,
2896: p_pe_rec => p_plan_element,
2897: p_loading_status => x_loading_status,
2898: x_loading_status => l_loading_status
2899: );

Line 2910: cn_chk_plan_element_pkg.chk_external_quota_pe (x_return_status => x_return_status,

2906: ELSIF (p_plan_element.quota_type_code = 'EXTERNAL')
2907: THEN
2908: -- if Quota type is External Package name is Mandatory and
2909: -- formula must be null
2910: cn_chk_plan_element_pkg.chk_external_quota_pe (x_return_status => x_return_status,
2911: p_pe_rec => p_plan_element,
2912: p_loading_status => x_loading_status,
2913: x_loading_status => l_loading_status
2914: );

Line 2923: cn_chk_plan_element_pkg.chk_other_quota_pe (x_return_status => x_return_status,

2919: END IF;
2920: ELSIF (p_plan_element.quota_type_code = 'NONE')
2921: THEN
2922: -- If quota type is NONE, both Formula and package must be null
2923: cn_chk_plan_element_pkg.chk_other_quota_pe (x_return_status => x_return_status,
2924: p_pe_rec => p_plan_element,
2925: p_loading_status => x_loading_status,
2926: x_loading_status => l_loading_status
2927: );

Line 2949: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_formula_id);

2945: THEN
2946: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2947: THEN
2948: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
2949: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_formula_id);
2950: fnd_msg_pub.ADD;
2951: END IF;
2952:
2953: RAISE fnd_api.g_exc_error;

Line 2999: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type ,--cn_plan_element_pvt.plan_element_rec_type,

2995: -- Desc : Check input for Formula Quota type plan element
2996: -- ----------------------------------------------------------------------------+
2997: PROCEDURE chk_formula_quota_pe (
2998: x_return_status OUT NOCOPY VARCHAR2,
2999: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type ,--cn_plan_element_pvt.plan_element_rec_type,
3000: p_loading_status IN VARCHAR2,
3001: x_loading_status OUT NOCOPY VARCHAR2
3002: )
3003: IS

Line 3081: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type , --cn_plan_element_pvt.plan_element_rec_type,

3077: -- Desc : Check input for External Quota type plan element
3078: -- ----------------------------------------------------------------------------+
3079: PROCEDURE chk_external_quota_pe (
3080: x_return_status OUT NOCOPY VARCHAR2,
3081: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type , --cn_plan_element_pvt.plan_element_rec_type,
3082: p_loading_status IN VARCHAR2,
3083: x_loading_status OUT NOCOPY VARCHAR2
3084: )
3085: IS

Line 3163: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type , --cn_plan_element_pvt.plan_element_rec_type,

3159: -- Desc : Check input for other Quota type plan element
3160: -- ----------------------------------------------------------------------------+
3161: PROCEDURE chk_other_quota_pe (
3162: x_return_status OUT NOCOPY VARCHAR2,
3163: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type , --cn_plan_element_pvt.plan_element_rec_type,
3164: p_loading_status IN VARCHAR2,
3165: x_loading_status OUT NOCOPY VARCHAR2
3166: )
3167: IS

Line 3954: END cn_chk_plan_element_pkg;

3950: THEN
3951: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3952: END IF;
3953: END chk_rate_quota_date;
3954: END cn_chk_plan_element_pkg;