APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_SRP_PAY_GROUPS

Line 169: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

165:
166: l_return_status VARCHAR2(200);
167: l_msg_count NUMBER;
168: l_msg_data VARCHAR2(2000);
169: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
170: l_loading_status VARCHAR2(2000);
171:
172: BEGIN
173:

Line 179: debugmsg('insert into cn_srp_pay_groups...');

175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176: x_loading_status := p_loading_status;
177:
178: FOR l_rec IN l_cur LOOP
179: debugmsg('insert into cn_srp_pay_groups...');
180: debugmsg('p_srp_role_id = ' || p_srp_role_id);
181: debugmsg('l_rec.role_pay_group_id = ' || l_rec.role_pay_group_id);
182:
183: -- strange to call PUB here, but there for historical reason

Line 478: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

474: l_rec l_cur%ROWTYPE;
475: l_return_status VARCHAR2(2000);
476: l_msg_count NUMBER;
477: l_msg_data VARCHAR2(2000);
478: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
479: l_loading_status VARCHAR2(2000);
480:
481: BEGIN
482: -- Initialize API return status to success

Line 488: debugmsg('update cn_srp_pay_groups.......');

484: x_loading_status := p_loading_status;
485:
486: FOR l_rec IN l_cur LOOP
487:
488: debugmsg('update cn_srp_pay_groups.......');
489: debugmsg('p_srp_role_id = ' || p_srp_role_id);
490: debugmsg('l_rec.role_pay_group_id = ' || l_rec.role_pay_group_id);
491:
492: -- strange to call PUB here, but there for historical reason