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.IGS_CO_SUBMIT dependencies on DBMS_SQL

Line 693: l_cursor_id := DBMS_SQL.open_cursor;

689:
690: IF l_sql_stmt IS NOT NULL THEN
691: --Included last two system letter codes as a part of bug 2376434
692:
693: l_cursor_id := DBMS_SQL.open_cursor;
694: fnd_dsql.set_cursor (l_cursor_id);
695: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
696: fnd_dsql.do_binds;
697:

Line 695: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);

691: --Included last two system letter codes as a part of bug 2376434
692:
693: l_cursor_id := DBMS_SQL.open_cursor;
694: fnd_dsql.set_cursor (l_cursor_id);
695: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
696: fnd_dsql.do_binds;
697:
698: IF l_sys_ltr_code IN ('ADRESID',
699: 'FAADHOC',

Line 705: DBMS_SQL.define_column (

701: 'GENERIC',
702: 'ENADHOC',
703: 'SFADHOC'
704: ) THEN
705: DBMS_SQL.define_column (
706: l_cursor_id,
707: 1,
708: l_email_address_dy,
709: 2000

Line 711: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

707: 1,
708: l_email_address_dy,
709: 2000
710: );
711: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
712: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
713: DBMS_SQL.define_column (
714: l_cursor_id,
715: 1,

Line 713: DBMS_SQL.define_column (

709: 2000
710: );
711: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
712: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
713: DBMS_SQL.define_column (
714: l_cursor_id,
715: 1,
716: l_email_address_dy,
717: 2000

Line 719: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

715: 1,
716: l_email_address_dy,
717: 2000
718: );
719: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
720: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
721: DBMS_SQL.define_column (
722: l_cursor_id,
723: 4,

Line 720: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);

716: l_email_address_dy,
717: 2000
718: );
719: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
720: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
721: DBMS_SQL.define_column (
722: l_cursor_id,
723: 4,
724: l_nominated_course_cd_dy,

Line 721: DBMS_SQL.define_column (

717: 2000
718: );
719: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
720: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
721: DBMS_SQL.define_column (
722: l_cursor_id,
723: 4,
724: l_nominated_course_cd_dy,
725: 6

Line 727: DBMS_SQL.define_column (

723: 4,
724: l_nominated_course_cd_dy,
725: 6
726: );
727: DBMS_SQL.define_column (
728: l_cursor_id,
729: 5,
730: l_appl_sequence_number_dy
731: );

Line 733: DBMS_SQL.define_column (

729: 5,
730: l_appl_sequence_number_dy
731: );
732: ELSIF l_sys_ltr_code IN ('FAAWARD', 'FAMISTM', 'FADISBT') THEN
733: DBMS_SQL.define_column (
734: l_cursor_id,
735: 1,
736: l_email_address_dy,
737: 2000

Line 739: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

735: 1,
736: l_email_address_dy,
737: 2000
738: );
739: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
740: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);
741: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
742: DBMS_SQL.define_column (
743: l_cursor_id,

Line 740: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);

736: l_email_address_dy,
737: 2000
738: );
739: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
740: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);
741: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
742: DBMS_SQL.define_column (
743: l_cursor_id,
744: 1,

Line 742: DBMS_SQL.define_column (

738: );
739: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
740: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);
741: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
742: DBMS_SQL.define_column (
743: l_cursor_id,
744: 1,
745: l_email_address_dy,
746: 2000

Line 748: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

744: 1,
745: l_email_address_dy,
746: 2000
747: );
748: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
749: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
750: DBMS_SQL.define_column (
751: l_cursor_id,
752: 4,

Line 749: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);

745: l_email_address_dy,
746: 2000
747: );
748: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
749: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
750: DBMS_SQL.define_column (
751: l_cursor_id,
752: 4,
753: l_nominated_course_cd_dy,

Line 750: DBMS_SQL.define_column (

746: 2000
747: );
748: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
749: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
750: DBMS_SQL.define_column (
751: l_cursor_id,
752: 4,
753: l_nominated_course_cd_dy,
754: 6

Line 756: DBMS_SQL.define_column (

752: 4,
753: l_nominated_course_cd_dy,
754: 6
755: );
756: DBMS_SQL.define_column (
757: l_cursor_id,
758: 5,
759: l_appl_sequence_number_dy
760: );

Line 761: DBMS_SQL.define_column (l_cursor_id, 6, l_panel_code_dy, 200);

757: l_cursor_id,
758: 5,
759: l_appl_sequence_number_dy
760: );
761: DBMS_SQL.define_column (l_cursor_id, 6, l_panel_code_dy, 200);
762: ELSE
763: DBMS_SQL.define_column (
764: l_cursor_id,
765: 1,

Line 763: DBMS_SQL.define_column (

759: l_appl_sequence_number_dy
760: );
761: DBMS_SQL.define_column (l_cursor_id, 6, l_panel_code_dy, 200);
762: ELSE
763: DBMS_SQL.define_column (
764: l_cursor_id,
765: 1,
766: l_email_address_dy,
767: 2000

Line 769: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

765: 1,
766: l_email_address_dy,
767: 2000
768: );
769: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
770: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
771: DBMS_SQL.define_column (
772: l_cursor_id,
773: 4,

Line 770: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);

766: l_email_address_dy,
767: 2000
768: );
769: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
770: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
771: DBMS_SQL.define_column (
772: l_cursor_id,
773: 4,
774: l_nominated_course_cd_dy,

Line 771: DBMS_SQL.define_column (

767: 2000
768: );
769: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
770: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
771: DBMS_SQL.define_column (
772: l_cursor_id,
773: 4,
774: l_nominated_course_cd_dy,
775: 6

Line 777: DBMS_SQL.define_column (

773: 4,
774: l_nominated_course_cd_dy,
775: 6
776: );
777: DBMS_SQL.define_column (
778: l_cursor_id,
779: 5,
780: l_appl_sequence_number_dy
781: );

Line 784: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);

780: l_appl_sequence_number_dy
781: );
782: END IF;
783:
784: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
785:
786: /*This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
787: l_dsql_debug := fnd_dsql.get_text(TRUE);
788: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

Line 791: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN

787: l_dsql_debug := fnd_dsql.get_text(TRUE);
788: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
789: */
790: LOOP
791: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN
792: l_person_processed := l_person_processed + 1;
793:
794: IF l_sys_ltr_code IN ('ADRESID',
795: 'FAADHOC',

Line 801: DBMS_SQL.column_value (

797: 'GENERIC',
798: 'ENADHOC',
799: 'SFADHOC'
800: ) THEN
801: DBMS_SQL.column_value (
802: l_cursor_id,
803: 1,
804: l_email_address_dy
805: );

Line 806: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

802: l_cursor_id,
803: 1,
804: l_email_address_dy
805: );
806: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
807: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
808: DBMS_SQL.column_value (
809: l_cursor_id,
810: 1,

Line 808: DBMS_SQL.column_value (

804: l_email_address_dy
805: );
806: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
807: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
808: DBMS_SQL.column_value (
809: l_cursor_id,
810: 1,
811: l_email_address_dy
812: );

Line 813: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

809: l_cursor_id,
810: 1,
811: l_email_address_dy
812: );
813: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
814: DBMS_SQL.column_value (
815: l_cursor_id,
816: 3,
817: l_adm_appl_number_dy

Line 814: DBMS_SQL.column_value (

810: 1,
811: l_email_address_dy
812: );
813: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
814: DBMS_SQL.column_value (
815: l_cursor_id,
816: 3,
817: l_adm_appl_number_dy
818: );

Line 819: DBMS_SQL.column_value (

815: l_cursor_id,
816: 3,
817: l_adm_appl_number_dy
818: );
819: DBMS_SQL.column_value (
820: l_cursor_id,
821: 4,
822: l_nominated_course_cd_dy
823: );

Line 824: DBMS_SQL.column_value (

820: l_cursor_id,
821: 4,
822: l_nominated_course_cd_dy
823: );
824: DBMS_SQL.column_value (
825: l_cursor_id,
826: 5,
827: l_appl_sequence_number_dy
828: );

Line 830: DBMS_SQL.column_value (

826: 5,
827: l_appl_sequence_number_dy
828: );
829: ELSIF l_sys_ltr_code IN ('FAAWARD', 'FAMISTM', 'FADISBT') THEN
830: DBMS_SQL.column_value (
831: l_cursor_id,
832: 1,
833: l_email_address_dy
834: );

Line 835: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

831: l_cursor_id,
832: 1,
833: l_email_address_dy
834: );
835: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
836: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);
837: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
838: DBMS_SQL.column_value (
839: l_cursor_id,

Line 836: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);

832: 1,
833: l_email_address_dy
834: );
835: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
836: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);
837: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
838: DBMS_SQL.column_value (
839: l_cursor_id,
840: 1,

Line 838: DBMS_SQL.column_value (

834: );
835: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
836: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);
837: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
838: DBMS_SQL.column_value (
839: l_cursor_id,
840: 1,
841: l_email_address_dy
842: );

Line 843: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

839: l_cursor_id,
840: 1,
841: l_email_address_dy
842: );
843: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
844: DBMS_SQL.column_value (
845: l_cursor_id,
846: 3,
847: l_adm_appl_number_dy

Line 844: DBMS_SQL.column_value (

840: 1,
841: l_email_address_dy
842: );
843: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
844: DBMS_SQL.column_value (
845: l_cursor_id,
846: 3,
847: l_adm_appl_number_dy
848: );

Line 849: DBMS_SQL.column_value (

845: l_cursor_id,
846: 3,
847: l_adm_appl_number_dy
848: );
849: DBMS_SQL.column_value (
850: l_cursor_id,
851: 4,
852: l_nominated_course_cd_dy
853: );

Line 854: DBMS_SQL.column_value (

850: l_cursor_id,
851: 4,
852: l_nominated_course_cd_dy
853: );
854: DBMS_SQL.column_value (
855: l_cursor_id,
856: 5,
857: l_appl_sequence_number_dy
858: );

Line 859: DBMS_SQL.column_value (l_cursor_id, 6, l_panel_code_dy);

855: l_cursor_id,
856: 5,
857: l_appl_sequence_number_dy
858: );
859: DBMS_SQL.column_value (l_cursor_id, 6, l_panel_code_dy);
860: ELSE
861: DBMS_SQL.column_value (
862: l_cursor_id,
863: 1,

Line 861: DBMS_SQL.column_value (

857: l_appl_sequence_number_dy
858: );
859: DBMS_SQL.column_value (l_cursor_id, 6, l_panel_code_dy);
860: ELSE
861: DBMS_SQL.column_value (
862: l_cursor_id,
863: 1,
864: l_email_address_dy
865: );

Line 866: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

862: l_cursor_id,
863: 1,
864: l_email_address_dy
865: );
866: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
867: DBMS_SQL.column_value (
868: l_cursor_id,
869: 3,
870: l_adm_appl_number_dy

Line 867: DBMS_SQL.column_value (

863: 1,
864: l_email_address_dy
865: );
866: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
867: DBMS_SQL.column_value (
868: l_cursor_id,
869: 3,
870: l_adm_appl_number_dy
871: );

Line 872: DBMS_SQL.column_value (

868: l_cursor_id,
869: 3,
870: l_adm_appl_number_dy
871: );
872: DBMS_SQL.column_value (
873: l_cursor_id,
874: 4,
875: l_nominated_course_cd_dy
876: );

Line 877: DBMS_SQL.column_value (

873: l_cursor_id,
874: 4,
875: l_nominated_course_cd_dy
876: );
877: DBMS_SQL.column_value (
878: l_cursor_id,
879: 5,
880: l_appl_sequence_number_dy
881: );

Line 1135: DBMS_SQL.close_cursor (l_cursor_id);

1131: END IF;
1132: END IF;
1133: END LOOP;
1134:
1135: DBMS_SQL.close_cursor (l_cursor_id);
1136:
1137: IF p_preview = 'Y' THEN
1138: -- If in preview mode then build the HTML in the concurrent request to take the user to the workbench.
1139: -- PACROSS - 11-SEP-2005

Line 1253: l_cursor_id := DBMS_SQL.open_cursor;

1249:
1250: -- executing Dynamic SQL. Either received from build_sql_stmt procedure (for Admissions) or Pre_Process (for FAM related letters)
1251: IF l_sql_stmt IS NOT NULL THEN
1252: --Included last two system letter codes as a part of bug 2376434
1253: l_cursor_id := DBMS_SQL.open_cursor;
1254: fnd_dsql.set_cursor (l_cursor_id);
1255: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
1256: fnd_dsql.do_binds;
1257:

Line 1255: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);

1251: IF l_sql_stmt IS NOT NULL THEN
1252: --Included last two system letter codes as a part of bug 2376434
1253: l_cursor_id := DBMS_SQL.open_cursor;
1254: fnd_dsql.set_cursor (l_cursor_id);
1255: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
1256: fnd_dsql.do_binds;
1257:
1258: IF l_sys_ltr_code IN ('ADRESID',
1259: 'FAADHOC',

Line 1265: DBMS_SQL.define_column (

1261: 'GENERIC',
1262: 'ENADHOC',
1263: 'SFADHOC'
1264: ) THEN
1265: DBMS_SQL.define_column (
1266: l_cursor_id,
1267: 1,
1268: l_email_address_dy,
1269: 2000

Line 1271: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

1267: 1,
1268: l_email_address_dy,
1269: 2000
1270: );
1271: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1272: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
1273: DBMS_SQL.define_column (
1274: l_cursor_id,
1275: 1,

Line 1273: DBMS_SQL.define_column (

1269: 2000
1270: );
1271: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1272: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
1273: DBMS_SQL.define_column (
1274: l_cursor_id,
1275: 1,
1276: l_email_address_dy,
1277: 2000

Line 1279: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

1275: 1,
1276: l_email_address_dy,
1277: 2000
1278: );
1279: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1280: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1281: DBMS_SQL.define_column (
1282: l_cursor_id,
1283: 4,

Line 1280: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);

1276: l_email_address_dy,
1277: 2000
1278: );
1279: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1280: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1281: DBMS_SQL.define_column (
1282: l_cursor_id,
1283: 4,
1284: l_nominated_course_cd_dy,

Line 1281: DBMS_SQL.define_column (

1277: 2000
1278: );
1279: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1280: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1281: DBMS_SQL.define_column (
1282: l_cursor_id,
1283: 4,
1284: l_nominated_course_cd_dy,
1285: 6

Line 1287: DBMS_SQL.define_column (

1283: 4,
1284: l_nominated_course_cd_dy,
1285: 6
1286: );
1287: DBMS_SQL.define_column (
1288: l_cursor_id,
1289: 5,
1290: l_appl_sequence_number_dy
1291: );

Line 1293: DBMS_SQL.define_column (

1289: 5,
1290: l_appl_sequence_number_dy
1291: );
1292: ELSIF l_sys_ltr_code IN ('FAAWARD', 'FAMISTM', 'FADISBT') THEN
1293: DBMS_SQL.define_column (
1294: l_cursor_id,
1295: 1,
1296: l_email_address_dy,
1297: 2000

Line 1299: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

1295: 1,
1296: l_email_address_dy,
1297: 2000
1298: );
1299: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1300: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);
1301: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
1302: DBMS_SQL.define_column (
1303: l_cursor_id,

Line 1300: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);

1296: l_email_address_dy,
1297: 2000
1298: );
1299: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1300: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);
1301: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
1302: DBMS_SQL.define_column (
1303: l_cursor_id,
1304: 1,

Line 1302: DBMS_SQL.define_column (

1298: );
1299: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1300: DBMS_SQL.define_column (l_cursor_id, 3, l_award_year_dy, 17);
1301: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
1302: DBMS_SQL.define_column (
1303: l_cursor_id,
1304: 1,
1305: l_email_address_dy,
1306: 2000

Line 1308: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

1304: 1,
1305: l_email_address_dy,
1306: 2000
1307: );
1308: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1309: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1310: DBMS_SQL.define_column (
1311: l_cursor_id,
1312: 4,

Line 1309: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);

1305: l_email_address_dy,
1306: 2000
1307: );
1308: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1309: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1310: DBMS_SQL.define_column (
1311: l_cursor_id,
1312: 4,
1313: l_nominated_course_cd_dy,

Line 1310: DBMS_SQL.define_column (

1306: 2000
1307: );
1308: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1309: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1310: DBMS_SQL.define_column (
1311: l_cursor_id,
1312: 4,
1313: l_nominated_course_cd_dy,
1314: 6

Line 1316: DBMS_SQL.define_column (

1312: 4,
1313: l_nominated_course_cd_dy,
1314: 6
1315: );
1316: DBMS_SQL.define_column (
1317: l_cursor_id,
1318: 5,
1319: l_appl_sequence_number_dy
1320: );

Line 1321: DBMS_SQL.define_column (l_cursor_id, 6, l_panel_code_dy, 200);

1317: l_cursor_id,
1318: 5,
1319: l_appl_sequence_number_dy
1320: );
1321: DBMS_SQL.define_column (l_cursor_id, 6, l_panel_code_dy, 200);
1322: ELSE
1323: DBMS_SQL.define_column (
1324: l_cursor_id,
1325: 1,

Line 1323: DBMS_SQL.define_column (

1319: l_appl_sequence_number_dy
1320: );
1321: DBMS_SQL.define_column (l_cursor_id, 6, l_panel_code_dy, 200);
1322: ELSE
1323: DBMS_SQL.define_column (
1324: l_cursor_id,
1325: 1,
1326: l_email_address_dy,
1327: 2000

Line 1329: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);

1325: 1,
1326: l_email_address_dy,
1327: 2000
1328: );
1329: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1330: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1331: DBMS_SQL.define_column (
1332: l_cursor_id,
1333: 4,

Line 1330: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);

1326: l_email_address_dy,
1327: 2000
1328: );
1329: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1330: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1331: DBMS_SQL.define_column (
1332: l_cursor_id,
1333: 4,
1334: l_nominated_course_cd_dy,

Line 1331: DBMS_SQL.define_column (

1327: 2000
1328: );
1329: DBMS_SQL.define_column (l_cursor_id, 2, l_person_id_dy);
1330: DBMS_SQL.define_column (l_cursor_id, 3, l_adm_appl_number_dy);
1331: DBMS_SQL.define_column (
1332: l_cursor_id,
1333: 4,
1334: l_nominated_course_cd_dy,
1335: 6

Line 1337: DBMS_SQL.define_column (

1333: 4,
1334: l_nominated_course_cd_dy,
1335: 6
1336: );
1337: DBMS_SQL.define_column (
1338: l_cursor_id,
1339: 5,
1340: l_appl_sequence_number_dy
1341: );

Line 1344: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);

1340: l_appl_sequence_number_dy
1341: );
1342: END IF;
1343:
1344: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
1345:
1346: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
1347: l_dsql_debug := fnd_dsql.get_text(TRUE);
1348: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

Line 1351: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN

1347: l_dsql_debug := fnd_dsql.get_text(TRUE);
1348: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
1349: */
1350: LOOP
1351: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN
1352: l_person_processed := l_person_processed + 1;
1353:
1354: IF l_sys_ltr_code IN ('ADRESID',
1355: 'FAADHOC',

Line 1361: DBMS_SQL.column_value (

1357: 'GENERIC',
1358: 'ENADHOC',
1359: 'SFADHOC'
1360: ) THEN
1361: DBMS_SQL.column_value (
1362: l_cursor_id,
1363: 1,
1364: l_email_address_dy
1365: );

Line 1366: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

1362: l_cursor_id,
1363: 1,
1364: l_email_address_dy
1365: );
1366: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1367: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
1368: DBMS_SQL.column_value (
1369: l_cursor_id,
1370: 1,

Line 1368: DBMS_SQL.column_value (

1364: l_email_address_dy
1365: );
1366: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1367: ELSIF l_sys_ltr_code = 'ADACKMT' THEN
1368: DBMS_SQL.column_value (
1369: l_cursor_id,
1370: 1,
1371: l_email_address_dy
1372: );

Line 1373: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

1369: l_cursor_id,
1370: 1,
1371: l_email_address_dy
1372: );
1373: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1374: DBMS_SQL.column_value (
1375: l_cursor_id,
1376: 3,
1377: l_adm_appl_number_dy

Line 1374: DBMS_SQL.column_value (

1370: 1,
1371: l_email_address_dy
1372: );
1373: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1374: DBMS_SQL.column_value (
1375: l_cursor_id,
1376: 3,
1377: l_adm_appl_number_dy
1378: );

Line 1379: DBMS_SQL.column_value (

1375: l_cursor_id,
1376: 3,
1377: l_adm_appl_number_dy
1378: );
1379: DBMS_SQL.column_value (
1380: l_cursor_id,
1381: 4,
1382: l_nominated_course_cd_dy
1383: );

Line 1384: DBMS_SQL.column_value (

1380: l_cursor_id,
1381: 4,
1382: l_nominated_course_cd_dy
1383: );
1384: DBMS_SQL.column_value (
1385: l_cursor_id,
1386: 5,
1387: l_appl_sequence_number_dy
1388: );

Line 1390: DBMS_SQL.column_value (

1386: 5,
1387: l_appl_sequence_number_dy
1388: );
1389: ELSIF l_sys_ltr_code IN ('FAAWARD', 'FAMISTM', 'FADISBT') THEN
1390: DBMS_SQL.column_value (
1391: l_cursor_id,
1392: 1,
1393: l_email_address_dy
1394: );

Line 1395: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

1391: l_cursor_id,
1392: 1,
1393: l_email_address_dy
1394: );
1395: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1396: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);
1397: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
1398: DBMS_SQL.column_value (
1399: l_cursor_id,

Line 1396: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);

1392: 1,
1393: l_email_address_dy
1394: );
1395: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1396: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);
1397: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
1398: DBMS_SQL.column_value (
1399: l_cursor_id,
1400: 1,

Line 1398: DBMS_SQL.column_value (

1394: );
1395: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1396: DBMS_SQL.column_value (l_cursor_id, 3, l_award_year_dy);
1397: ELSIF l_sys_ltr_code = 'ADINTRW' THEN
1398: DBMS_SQL.column_value (
1399: l_cursor_id,
1400: 1,
1401: l_email_address_dy
1402: );

Line 1403: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

1399: l_cursor_id,
1400: 1,
1401: l_email_address_dy
1402: );
1403: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1404: DBMS_SQL.column_value (
1405: l_cursor_id,
1406: 3,
1407: l_adm_appl_number_dy

Line 1404: DBMS_SQL.column_value (

1400: 1,
1401: l_email_address_dy
1402: );
1403: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1404: DBMS_SQL.column_value (
1405: l_cursor_id,
1406: 3,
1407: l_adm_appl_number_dy
1408: );

Line 1409: DBMS_SQL.column_value (

1405: l_cursor_id,
1406: 3,
1407: l_adm_appl_number_dy
1408: );
1409: DBMS_SQL.column_value (
1410: l_cursor_id,
1411: 4,
1412: l_nominated_course_cd_dy
1413: );

Line 1414: DBMS_SQL.column_value (

1410: l_cursor_id,
1411: 4,
1412: l_nominated_course_cd_dy
1413: );
1414: DBMS_SQL.column_value (
1415: l_cursor_id,
1416: 5,
1417: l_appl_sequence_number_dy
1418: );

Line 1419: DBMS_SQL.column_value (l_cursor_id, 6, l_panel_code_dy);

1415: l_cursor_id,
1416: 5,
1417: l_appl_sequence_number_dy
1418: );
1419: DBMS_SQL.column_value (l_cursor_id, 6, l_panel_code_dy);
1420: ELSE
1421: DBMS_SQL.column_value (
1422: l_cursor_id,
1423: 1,

Line 1421: DBMS_SQL.column_value (

1417: l_appl_sequence_number_dy
1418: );
1419: DBMS_SQL.column_value (l_cursor_id, 6, l_panel_code_dy);
1420: ELSE
1421: DBMS_SQL.column_value (
1422: l_cursor_id,
1423: 1,
1424: l_email_address_dy
1425: );

Line 1426: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);

1422: l_cursor_id,
1423: 1,
1424: l_email_address_dy
1425: );
1426: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1427: DBMS_SQL.column_value (
1428: l_cursor_id,
1429: 3,
1430: l_adm_appl_number_dy

Line 1427: DBMS_SQL.column_value (

1423: 1,
1424: l_email_address_dy
1425: );
1426: DBMS_SQL.column_value (l_cursor_id, 2, l_person_id_dy);
1427: DBMS_SQL.column_value (
1428: l_cursor_id,
1429: 3,
1430: l_adm_appl_number_dy
1431: );

Line 1432: DBMS_SQL.column_value (

1428: l_cursor_id,
1429: 3,
1430: l_adm_appl_number_dy
1431: );
1432: DBMS_SQL.column_value (
1433: l_cursor_id,
1434: 4,
1435: l_nominated_course_cd_dy
1436: );

Line 1437: DBMS_SQL.column_value (

1433: l_cursor_id,
1434: 4,
1435: l_nominated_course_cd_dy
1436: );
1437: DBMS_SQL.column_value (
1438: l_cursor_id,
1439: 5,
1440: l_appl_sequence_number_dy
1441: );

Line 1728: DBMS_SQL.close_cursor (l_cursor_id);

1724:
1725: --** exec level logging.
1726:
1727: --**
1728: DBMS_SQL.close_cursor (l_cursor_id);
1729:
1730: IF p_preview = 'Y' THEN
1731: -- If in preview mode then build the HTML in the concurrent request to take the user to the workbench.
1732: -- PACROSS - 11-SEP-2005