DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_API

Line 93: IF ( (cn_api.invalid_date_range

89: -- Check if date range invalid
90: -- will check : if start_date is null
91: -- if start_date/end_date is missing
92: -- if start_date > end_date
93: IF ( (cn_api.invalid_date_range
94: (p_start_date => p_start_date,
95: p_end_date => p_end_date,
96: p_end_date_nullable => FND_API.G_TRUE,
97: p_loading_status => x_loading_status,

Line 868: l_date_range_action_tbl cn_api.date_range_action_tbl_type;

864:
865: l_payee_assign_date_rec payee_assign_date_curs%ROWTYPE;
866: l_ws_count NUMBER;
867:
868: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
869: l_ovn_old NUMBER;
870: l_old_assignment_start_date DATE;
871: l_old_assignment_end_date DATE;
872: l_old_salesrep_id NUMBER;

Line 1031: cn_api.get_date_range_diff_action

1027: --clku, payee check enhancement
1028: OPEN payee_check_curs(p_paygroup_assign_rec.salesrep_id);
1029: Fetch payee_check_curs into l_srp_role_id;
1030: IF payee_check_curs%FOUND THEN
1031: cn_api.get_date_range_diff_action
1032: ( start_date_new => p_paygroup_assign_rec.assignment_start_date
1033: ,end_date_new => p_paygroup_assign_rec.assignment_end_date
1034: ,start_date_old => l_old_assignment_start_date
1035: ,end_date_old => l_old_assignment_end_date

Line 1047: IF CN_API.date_range_overlap

1043: For l_payee_assign_date_rec IN payee_assign_date_curs
1044: (p_paygroup_assign_rec.salesrep_id) LOOP
1045: -- check if there is any date range over between
1046: -- srp paygroup date and payee assign date
1047: IF CN_API.date_range_overlap
1048: (l_date_range_action_tbl(i).start_date,
1049: l_date_range_action_tbl(i).end_date,
1050: l_payee_assign_date_rec.start_date,
1051: l_payee_assign_date_rec.end_date) = true THEN

Line 1422: IF CN_API.date_range_overlap

1418: For l_payee_assign_date_rec IN payee_assign_date_curs
1419: (p_paygroup_assign_rec.salesrep_id) LOOP
1420: -- check if there is any date range over between
1421: -- srp paygroup date and payee assign date
1422: IF CN_API.date_range_overlap
1423: (p_paygroup_assign_rec.assignment_start_date,
1424: p_paygroup_assign_rec.assignment_end_date,
1425: l_payee_assign_date_rec.start_date,
1426: l_payee_assign_date_rec.end_date) = true THEN