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.

[Home] [Help]

APPS.CN_PMT_PLANS_PKG dependencies on CN_PMT_PLANS_S

Line 17: SELECT cn_pmt_plans_s.nextval

13: PROCEDURE Get_UID( X_pmt_plan_id IN OUT NOCOPY NUMBER) IS
14:
15: BEGIN
16:
17: SELECT cn_pmt_plans_s.nextval
18: INTO X_pmt_plan_id
19: FROM sys.dual;
20:
21: END Get_UID;

Line 41: ,x_start_date cn_pmt_plans.start_date%TYPE

37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE

Line 215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date

211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char

Line 251: l_start_date cn_pmt_plans.start_date%TYPE;

247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;

Line 489: ,x_start_date cn_pmt_plans.start_date%TYPE

485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE