APPS.CN_ROLE_PMT_PLANS_PVT dependencies on CN_SRP_PMT_PLANS

Line 836: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

832:
833: l_return_status VARCHAR2(2000);
834: l_msg_count NUMBER;
835: l_msg_data VARCHAR2(2000);
836: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
837: l_org_id cn_srp_pmt_plans.org_id%TYPE;
838: l_loading_status VARCHAR2(2000);
839:
840:

Line 837: l_org_id cn_srp_pmt_plans.org_id%TYPE;

833: l_return_status VARCHAR2(2000);
834: l_msg_count NUMBER;
835: l_msg_data VARCHAR2(2000);
836: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
837: l_org_id cn_srp_pmt_plans.org_id%TYPE;
838: l_loading_status VARCHAR2(2000);
839:
840:
841: BEGIN

Line 855: -- dbms_output.put_line('insert into cn_srp_pmt_plans...');

851:
852: FOR l_rec IN l_cur(l_org_id)
853: LOOP
854:
855: -- dbms_output.put_line('insert into cn_srp_pmt_plans...');
856: -- dbms_output.put_line('p_srp_role_id = ' || l_rec.srp_role_id);
857: -- dbms_output.put_line('p_role_pmt_plan_id = ' || p_role_pmt_plan_id);
858:
859: CN_SRP_PMT_PLANS_PUB.create_mass_asgn_srp_pmt_plan

Line 859: CN_SRP_PMT_PLANS_PUB.create_mass_asgn_srp_pmt_plan

855: -- dbms_output.put_line('insert into cn_srp_pmt_plans...');
856: -- dbms_output.put_line('p_srp_role_id = ' || l_rec.srp_role_id);
857: -- dbms_output.put_line('p_role_pmt_plan_id = ' || p_role_pmt_plan_id);
858:
859: CN_SRP_PMT_PLANS_PUB.create_mass_asgn_srp_pmt_plan
860: (p_api_version => 1.0,
861: x_return_status => l_return_status,
862: x_msg_count => l_msg_count,
863: x_msg_data => l_msg_data,

Line 934: l_srp_pmt_plan_assign_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

930:
931: l_return_status VARCHAR2(2000);
932: l_msg_count NUMBER;
933: l_msg_data VARCHAR2(2000);
934: l_srp_pmt_plan_assign_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
935: l_org_id cn_srp_pmt_plans.org_id%TYPE;
936: l_loading_status VARCHAR2(2000);
937:
938: BEGIN

Line 935: l_org_id cn_srp_pmt_plans.org_id%TYPE;

931: l_return_status VARCHAR2(2000);
932: l_msg_count NUMBER;
933: l_msg_data VARCHAR2(2000);
934: l_srp_pmt_plan_assign_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
935: l_org_id cn_srp_pmt_plans.org_id%TYPE;
936: l_loading_status VARCHAR2(2000);
937:
938: BEGIN
939:

Line 956: CN_SRP_PMT_PLANS_PUB.update_mass_asgn_srp_pmt_plan

952: where role_pmt_plan_id = p_role_pmt_plan_id;
953:
954: FOR l_rec IN l_cur(l_org_id) LOOP
955:
956: CN_SRP_PMT_PLANS_PUB.update_mass_asgn_srp_pmt_plan
957: (p_api_version => 1.0,
958: x_return_status => l_return_status,
959: x_msg_count => l_msg_count,
960: x_msg_data => l_msg_data,

Line 997: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

993:
994: l_return_status VARCHAR2(2000);
995: l_msg_count NUMBER;
996: l_msg_data VARCHAR2(2000);
997: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
998: l_org_id cn_srp_pmt_plans.org_id%TYPE;
999: l_loading_status VARCHAR2(2000);
1000:
1001: BEGIN

Line 998: l_org_id cn_srp_pmt_plans.org_id%TYPE;

994: l_return_status VARCHAR2(2000);
995: l_msg_count NUMBER;
996: l_msg_data VARCHAR2(2000);
997: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
998: l_org_id cn_srp_pmt_plans.org_id%TYPE;
999: l_loading_status VARCHAR2(2000);
1000:
1001: BEGIN
1002:

Line 1014: CN_SRP_PMT_PLANS_PUB.delete_mass_asgn_srp_pmt_plan

1010:
1011: FOR l_rec IN l_cur(l_org_id)
1012: LOOP
1013:
1014: CN_SRP_PMT_PLANS_PUB.delete_mass_asgn_srp_pmt_plan
1015: (
1016: p_api_version => 1.0,
1017: p_init_msg_list => fnd_api.g_true,
1018: p_commit => fnd_api.g_true,