42: p_srp_role_id IN NUMBER,
43: x_start_date OUT NOCOPY DATE,
44: x_end_date OUT NOCOPY DATE) IS
45:
46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
43: x_start_date OUT NOCOPY DATE,
44: x_end_date OUT NOCOPY DATE) IS
45:
46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:
62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:
62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;
64: l_pay_group_id NUMBER;
859:
860: l_role_pg_rec role_pay_groups_rec_type;
861: l_rec l_srp_cur%ROWTYPE;
862: l_lock_flag VARCHAR2(1);
863: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
864: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;
865: l_start_date DATE;
866: l_end_date DATE;
867:
1007:
1008: IF l_count = 0 THEN
1009: l_lock_flag := 'N';
1010:
1011: SELECT cn_srp_pay_groups_s.NEXTVAL
1012: INTO l_srp_pay_group_id
1013: FROM dual;
1014:
1015: CN_SRP_Pay_Groups_Pkg.Begin_Record