eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENRQ_BINS_PVT dependencies on PV_ENRL_REQ_PARAM

Line 264: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();

260: AND active_flag = 'Y'
261: );
262:
263:
264: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();
265: l_api_name CONSTANT VARCHAR2(30) := 'new_programs';
266: l_api_version_number CONSTANT NUMBER := 1.0;
267: l_request_status_code VARCHAR2(30):=null;
268: l_membership_status_code VARCHAR2(30);

Line 342: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM

338: --populate the table
339: -- ----dbms_output.PUT_LINE('inside enrollment null');
340: l_enrq_param_tbl.EXTEND(1);
341: ----dbms_output.PUT_LINE('after extend ');
342: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM
343: (
344: rec_prgm.program_id
345: ,rec_prgm.program_name
346: ,rec_prgm.citem_version_id

Line 365: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM

361: -- Fixed for bug 4749395
362: ELSIF ( l_request_status_code ='REJECTED' OR l_request_status_code='CANCELLED' ) and l_enrollment_type_code IN ('NEW') THEN
363: l_enrq_param_tbl.EXTEND(1);
364: ----dbms_output.PUT_LINE('after extend ');
365: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM
366: (
367: rec_prgm.program_id
368: ,rec_prgm.program_name
369: ,rec_prgm.citem_version_id

Line 390: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM

386: FETCH memb_csr INTO l_membership_id,l_membership_status_code;
387: CLOSE memb_csr;
388: IF l_membership_status_code='TERMINATED' THEN
389: l_enrq_param_tbl.EXTEND(1);
390: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM
391: (
392: rec_prgm.program_id
393: ,rec_prgm.program_name
394: ,rec_prgm.citem_version_id

Line 429: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM (

425: END IF;
426: END IF;
427: IF l_eligible_flag=true THEN
428: l_enrq_param_tbl.EXTEND(1);
429: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM (
430: rec_prgm.program_id
431: ,null
432: ,null
433: ,null

Line 453: OPEN x_enrq_param_cur FOR SELECT * FROM TABLE( CAST (l_enrq_param_tbl AS PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;

449: ----dbms_output.PUT_LINE('before for looop ');
450:
451: --We'll query l_enrq_param_tbl once all the programs related parameters are populated in l_enrq_param_tbl.
452:
453: OPEN x_enrq_param_cur FOR SELECT * FROM TABLE( CAST (l_enrq_param_tbl AS PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
454:
455: -- Check for commit
456: IF FND_API.to_boolean(p_commit) THEN
457: COMMIT;

Line 604: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();

600: SELECT membership_status_code
601: FROM pv_pg_memberships
602: WHERE enrl_request_id=enrl_id;
603:
604: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();
605: l_api_name CONSTANT VARCHAR2(30) := 'renewable_programs';
606: l_api_version_number CONSTANT NUMBER := 1.0;
607: l_request_status_code VARCHAR2(30);
608: l_membership_status_code VARCHAR2(30);

Line 714: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM(

710: END IF;
711: END IF;
712: IF isValid=true THEN
713: l_enrq_param_tbl.EXTEND(1);
714: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM(
715: rec_p.program_id
716: ,rec_p.program_name
717: ,rec_p.citem_version_id
718: , getInviteHeaderId(p_partner_id ,rec_p.program_id , 'INVITE')

Line 739: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;

735: END IF; -- end of if for preewquite cache
736: END LOOP;-- END OF FOR LOOP
737:
738: -- open ref cursor by querying l_enrq_param_tbl once all the programs related parameters are populated in l_enrq_param_tbl.
739: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
740:
741: -- Check for commit
742: IF FND_API.to_boolean(p_commit) THEN
743: COMMIT;

Line 896: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();

892: and enrq.enrl_request_id=memb.enrl_request_id(+);
893:
894:
895:
896: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();
897: l_api_name CONSTANT VARCHAR2(30) := 'upgradable_programs';
898: l_api_version_number CONSTANT NUMBER := 1.0;
899: l_eligible_flag boolean:=true;
900: l_memb_flag boolean:=true;

Line 979: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM(

975:
976: IF l_program_id=rec_prgm.program_id THEN
977: l_prevMembrId:=l_prevMembrId || ':' || to_char(rec_prgm.membership_id);
978: l_upgrdRlId:=l_upgrdRlId || ':' || to_char(rec_prgm.enrl_change_rule_id);
979: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM(
980: rec_prgm.program_id
981: ,rec_prgm.program_name
982: ,rec_prgm.citem_version_id
983: , getInviteHeaderId(p_partner_id ,rec_prgm.program_id , 'UPGRADE')

Line 1001: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM(

997: counter:=counter+1;
998: l_prevMembrId:=to_char(rec_prgm.membership_id);
999: l_upgrdRlId:=to_char(rec_prgm.enrl_change_rule_id);
1000: l_enrq_param_tbl.EXTEND(1);
1001: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM(
1002: rec_prgm.program_id
1003: ,rec_prgm.program_name
1004: ,rec_prgm.citem_version_id
1005: ,getInviteHeaderId(p_partner_id ,rec_prgm.program_id , 'UPGRADE')

Line 1025: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;

1021: END IF; -- end of if for preewquite cache
1022: END LOOP;
1023:
1024: --We'll query l_enrq_param_tbl once all the programs related parameters are populated in l_enrq_param_tbl.
1025: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
1026:
1027: -- Check for commit
1028: IF FND_API.to_boolean(p_commit) THEN
1029: COMMIT;

Line 1122: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();

1118: )
1119: */
1120: ;
1121:
1122: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();
1123: l_api_name CONSTANT VARCHAR2(30) := 'incomplete_programs';
1124: l_api_version_number CONSTANT NUMBER := 1.0;
1125: counter NUMBER:=0;
1126: TYPE csr_type IS REF CURSOR;

Line 1172: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM( rec_prgm.program_id

1168:
1169: IF l_cache='X' THEN
1170: counter:=counter+1;
1171: l_enrq_param_tbl.EXTEND(1);
1172: l_enrq_param_tbl(counter) := PV_ENRL_REQ_PARAM( rec_prgm.program_id
1173: ,rec_prgm.program_name
1174: ,rec_prgm.citem_version_id
1175: ,null -- need to clarify business logic here
1176: ,null -- previous membership id

Line 1190: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;

1186: END IF; -- end of if for preewquite cache
1187: END LOOP;
1188:
1189: --We'll query l_enrq_param_tbl once all the programs related parameters are populated in l_enrq_param_tbl.
1190: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
1191:
1192: -- Check for commit
1193: IF FND_API.to_boolean(p_commit) THEN
1194: COMMIT;

Line 1241: l_nienrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();

1237: l_api_version_number CONSTANT NUMBER := 1.0;
1238: l_new_enrq_param_ref enrq_param_ref;
1239: l_inc_enrq_param_ref enrq_param_ref;
1240: --l_newinc_enrq_param_ref enrq_param_ref;
1241: l_nienrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();
1242: l_programId NUMBER;
1243: l_programName VARCHAR2(60);
1244: l_citemVersionId NUMBER;
1245: l_inviteHeaderId NUMBER;

Line 1302: l_nienrq_param_tbl(counter) := PV_ENRL_REQ_PARAM( l_programId

1298: EXIT WHEN l_new_enrq_param_ref%NOTFOUND;
1299:
1300: IF l_programId IS NOT NULL THEN
1301: l_nienrq_param_tbl.EXTEND(1);
1302: l_nienrq_param_tbl(counter) := PV_ENRL_REQ_PARAM( l_programId
1303: ,l_programName
1304: , l_citemVersionId
1305: , l_inviteHeaderId
1306: ,l_prevMembrId

Line 1348: l_nienrq_param_tbl(counter) := PV_ENRL_REQ_PARAM( l_programId

1344: EXIT WHEN l_inc_enrq_param_ref%NOTFOUND;
1345:
1346: IF l_programId IS NOT NULL THEN
1347: l_nienrq_param_tbl.EXTEND(1);
1348: l_nienrq_param_tbl(counter) := PV_ENRL_REQ_PARAM( l_programId
1349: ,l_programName
1350: , l_citemVersionId
1351: , l_inviteHeaderId
1352: ,l_prevMembrId

Line 1371: OPEN x_enrq_param_cur FOR SELECT * FROM TABLE( CAST (l_nienrq_param_tbl AS PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;

1367: END LOOP;
1368: close l_inc_enrq_param_ref ;
1369:
1370:
1371: OPEN x_enrq_param_cur FOR SELECT * FROM TABLE( CAST (l_nienrq_param_tbl AS PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
1372:
1373:
1374: -- Check for commit
1375: IF FND_API.to_boolean(p_commit) THEN