APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_SRP_PAYGROUP_PVT

Line 224: l_create_rec cn_srp_paygroup_pvt.paygroup_assign_rec;

220: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
221: l_status VARCHAR2(1);
222:
223: l_pay_group_name cn_pay_groups.name%TYPE;
224: l_create_rec cn_srp_paygroup_pvt.paygroup_assign_rec;
225:
226: CURSOR get_pay_group_id_cur IS
227: SELECT pay_group_id
228: FROM cn_pay_groups_all

Line 479: cn_srp_paygroup_pvt.Create_Srp_Pay_Group

475: l_create_rec.attribute13 := l_paygroup_assign_rec.attribute13;
476: l_create_rec.attribute14 := l_paygroup_assign_rec.attribute14;
477: l_create_rec.attribute15 := l_paygroup_assign_rec.attribute15;
478:
479: cn_srp_paygroup_pvt.Create_Srp_Pay_Group
480: ( p_api_version => 1.0,
481: x_return_status => x_return_status,
482: x_loading_status => x_loading_status,
483: x_msg_count => x_msg_count,

Line 685: l_update_rec cn_srp_paygroup_pvt.paygroup_assign_rec;

681: --
682: l_OAI_array JTF_USR_HKS.oai_data_array_type;
683: l_old_paygroup_assign_rec paygroup_assign_rec;
684: l_paygroup_assign_rec paygroup_assign_rec;
685: l_update_rec cn_srp_paygroup_pvt.paygroup_assign_rec;
686: l_bind_data_id NUMBER;
687:
688: CURSOR get_pay_group_id_cur(p_name VARCHAR2, p_org_id NUMBER) IS
689: SELECT pay_group_id

Line 1092: cn_srp_paygroup_pvt.Update_Srp_Pay_Group

1088: l_update_rec.attribute15 := l_paygroup_assign_rec.attribute15;
1089:
1090:
1091: -- call private API
1092: cn_srp_paygroup_pvt.Update_Srp_Pay_Group
1093: ( p_api_version => 1.0,
1094: x_return_status => x_return_status,
1095: x_loading_status => x_loading_status,
1096: x_msg_count => x_msg_count,

Line 1507: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;

1503:
1504: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1505: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1506:
1507: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1508: l_salesrep_type_new cn_salesreps.type%TYPE;
1509: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1510: l_emp_num_new cn_salesreps.employee_number%TYPE;
1511: l_pay_group_name_new cn_pay_groups.name%TYPE;

Line 1714: cn_srp_paygroup_pvt.delete_srp_pay_group

1710:
1711: l_return_status := FND_API.G_RET_STS_SUCCESS;
1712:
1713: IF l_loading_status = 'CN_INVALID_SRP_PGRP_ASGN_DT' THEN
1714: cn_srp_paygroup_pvt.delete_srp_pay_group
1715: (
1716: p_api_version => 1.0,
1717: x_return_status => l_return_status,
1718: x_loading_status => l_loading_status,

Line 1765: cn_srp_paygroup_pvt.delete_srp_pay_group

1761:
1762: END IF;
1763:
1764: ELSIF l_count <> 0 THEN
1765: cn_srp_paygroup_pvt.delete_srp_pay_group
1766: (
1767: p_api_version => 1.0,
1768: x_return_status => l_return_status,
1769: x_loading_status => l_loading_status,