DBA Data[Home] [Help]

APPS.CN_QUOTA_RULE_PVT dependencies on CN_PLAN_ELEMENT_PUB

Line 17: p_revenue_class_rec IN cn_plan_element_pub.revenue_class_rec_type,

13:
14: --- convert the public rec to the private one
15: FUNCTION convert_rev_class_user_input (
16: p_quota_name IN VARCHAR2,
17: p_revenue_class_rec IN cn_plan_element_pub.revenue_class_rec_type,
18: p_old_revenue_class_name IN VARCHAR2 := NULL,
19: x_loading_status IN OUT NOCOPY VARCHAR2
20: )
21: RETURN quota_rule_rec_type

Line 856: -- p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_typ

852: -- p_commit IN VARCHAR2 Optional
853: -- Default = FND_API.G_FALSE
854: -- p_validation_level IN NUMBER Optional
855: -- Default = FND_API.G_VALID_LEVEL_FULL
856: -- p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_typ
857: -- OUT : x_return_status OUT VARCHAR2(1)
858: -- x_msg_count OUT NUMBER
859: -- x_msg_data OUT VARCHAR2(2000)
860: -- x_quota_rule_id OUT NUMBER

Line 871: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,

867: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
868: p_commit IN VARCHAR2 := fnd_api.g_false,
869: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
870: p_quota_name IN VARCHAR2,
871: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
872: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
873: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
874: x_loading_status OUT NOCOPY VARCHAR2,
875: x_return_status OUT NOCOPY VARCHAR2,

Line 872: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,

868: p_commit IN VARCHAR2 := fnd_api.g_false,
869: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
870: p_quota_name IN VARCHAR2,
871: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
872: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
873: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
874: x_loading_status OUT NOCOPY VARCHAR2,
875: x_return_status OUT NOCOPY VARCHAR2,
876: x_msg_count OUT NOCOPY NUMBER,

Line 873: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,

869: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
870: p_quota_name IN VARCHAR2,
871: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
872: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
873: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
874: x_loading_status OUT NOCOPY VARCHAR2,
875: x_return_status OUT NOCOPY VARCHAR2,
876: x_msg_count OUT NOCOPY NUMBER,
877: x_msg_data OUT NOCOPY VARCHAR2

Line 1210: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,

1206: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1207: p_commit IN VARCHAR2 := fnd_api.g_false,
1208: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1209: p_quota_name IN VARCHAR2,
1210: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
1211: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
1212: x_loading_status OUT NOCOPY VARCHAR2,
1213: x_return_status OUT NOCOPY VARCHAR2,
1214: x_msg_count OUT NOCOPY NUMBER,

Line 1211: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,

1207: p_commit IN VARCHAR2 := fnd_api.g_false,
1208: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1209: p_quota_name IN VARCHAR2,
1210: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
1211: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
1212: x_loading_status OUT NOCOPY VARCHAR2,
1213: x_return_status OUT NOCOPY VARCHAR2,
1214: x_msg_count OUT NOCOPY NUMBER,
1215: x_msg_data OUT NOCOPY VARCHAR2

Line 1487: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,

1483: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1484: p_commit IN VARCHAR2 := fnd_api.g_false,
1485: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1486: p_quota_name IN VARCHAR2,
1487: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
1488: x_return_status OUT NOCOPY VARCHAR2,
1489: x_msg_count OUT NOCOPY NUMBER,
1490: x_msg_data OUT NOCOPY VARCHAR2,
1491: x_loading_status OUT NOCOPY VARCHAR2