DBA Data[Home] [Help]

APPS.IGR_IMP_001 dependencies on FND_GLOBAL

Line 491: fnd_global.conc_request_id,

487: sysdate,
488: 1,
489: sysdate,
490: null,
491: fnd_global.conc_request_id,
492: fnd_global.prog_appl_id,
493: fnd_global.conc_program_id,
494: sysdate);
495: EXCEPTION WHEN OTHERS THEN

Line 492: fnd_global.prog_appl_id,

488: 1,
489: sysdate,
490: null,
491: fnd_global.conc_request_id,
492: fnd_global.prog_appl_id,
493: fnd_global.conc_program_id,
494: sysdate);
495: EXCEPTION WHEN OTHERS THEN
496: l_status:=0;

Line 493: fnd_global.conc_program_id,

489: sysdate,
490: null,
491: fnd_global.conc_request_id,
492: fnd_global.prog_appl_id,
493: fnd_global.conc_program_id,
494: sysdate);
495: EXCEPTION WHEN OTHERS THEN
496: l_status:=0;
497: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_IMP_BATCH_DET failed '||SQLERRM);

Line 628: fnd_global.conc_request_id,

624: sysdate,
625: 1,
626: sysdate,
627: null,
628: fnd_global.conc_request_id,
629: fnd_global.prog_appl_id,
630: fnd_global.conc_program_id,
631: sysdate,
632: null

Line 629: fnd_global.prog_appl_id,

625: 1,
626: sysdate,
627: null,
628: fnd_global.conc_request_id,
629: fnd_global.prog_appl_id,
630: fnd_global.conc_program_id,
631: sysdate,
632: null
633: );

Line 630: fnd_global.conc_program_id,

626: sysdate,
627: null,
628: fnd_global.conc_request_id,
629: fnd_global.prog_appl_id,
630: fnd_global.conc_program_id,
631: sysdate,
632: null
633: );
634: EXCEPTION WHEN OTHERS THEN

Line 701: fnd_global.conc_request_id,

697: sysdate ,
698: 1 ,
699: sysdate ,
700: null ,
701: fnd_global.conc_request_id,
702: fnd_global.prog_appl_id,
703: fnd_global.conc_program_id,
704: sysdate ,
705: inq_rec.ethnic_origin ,

Line 702: fnd_global.prog_appl_id,

698: 1 ,
699: sysdate ,
700: null ,
701: fnd_global.conc_request_id,
702: fnd_global.prog_appl_id,
703: fnd_global.conc_program_id,
704: sysdate ,
705: inq_rec.ethnic_origin ,
706: null ,

Line 703: fnd_global.conc_program_id,

699: sysdate ,
700: null ,
701: fnd_global.conc_request_id,
702: fnd_global.prog_appl_id,
703: fnd_global.conc_program_id,
704: sysdate ,
705: inq_rec.ethnic_origin ,
706: null ,
707: null,

Line 785: fnd_global.conc_program_id,

781: null ,
782: '2' ,
783: null ,
784: null ,
785: fnd_global.conc_program_id,
786: fnd_global.prog_appl_id,
787: sysdate,
788: 1,
789: sysdate,

Line 786: fnd_global.prog_appl_id,

782: '2' ,
783: null ,
784: null ,
785: fnd_global.conc_program_id,
786: fnd_global.prog_appl_id,
787: sysdate,
788: 1,
789: sysdate,
790: 1,

Line 792: fnd_global.login_id,

788: 1,
789: sysdate,
790: 1,
791: sysdate,
792: fnd_global.login_id,
793: fnd_global.conc_request_id
794: );
795: EXCEPTION WHEN OTHERS THEN
796: l_status:=0;

Line 793: fnd_global.conc_request_id

789: sysdate,
790: 1,
791: sysdate,
792: fnd_global.login_id,
793: fnd_global.conc_request_id
794: );
795: EXCEPTION WHEN OTHERS THEN
796: l_status:=0;
797: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);

Line 843: fnd_global.conc_program_id,

839: null ,
840: '2' ,
841: null ,
842: null ,
843: fnd_global.conc_program_id,
844: fnd_global.prog_appl_id,
845: sysdate,
846: 1,
847: sysdate,

Line 844: fnd_global.prog_appl_id,

840: '2' ,
841: null ,
842: null ,
843: fnd_global.conc_program_id,
844: fnd_global.prog_appl_id,
845: sysdate,
846: 1,
847: sysdate,
848: 1,

Line 850: fnd_global.login_id,

846: 1,
847: sysdate,
848: 1,
849: sysdate,
850: fnd_global.login_id,
851: fnd_global.conc_request_id
852: );
853: EXCEPTION WHEN OTHERS THEN
854: l_status:=0;

Line 851: fnd_global.conc_request_id

847: sysdate,
848: 1,
849: sysdate,
850: fnd_global.login_id,
851: fnd_global.conc_request_id
852: );
853: EXCEPTION WHEN OTHERS THEN
854: l_status:=0;
855: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);

Line 979: fnd_global.conc_request_id,

975: sysdate ,
976: 1 ,
977: sysdate ,
978: null ,
979: fnd_global.conc_request_id,
980: fnd_global.prog_appl_id,
981: fnd_global.conc_program_id,
982: sysdate,
983: inq_rec.source_promotion_id

Line 980: fnd_global.prog_appl_id,

976: 1 ,
977: sysdate ,
978: null ,
979: fnd_global.conc_request_id,
980: fnd_global.prog_appl_id,
981: fnd_global.conc_program_id,
982: sysdate,
983: inq_rec.source_promotion_id
984: );

Line 981: fnd_global.conc_program_id,

977: sysdate ,
978: null ,
979: fnd_global.conc_request_id,
980: fnd_global.prog_appl_id,
981: fnd_global.conc_program_id,
982: sysdate,
983: inq_rec.source_promotion_id
984: );
985: EXCEPTION WHEN OTHERS THEN

Line 1049: fnd_global.conc_request_id,

1045: SYSDATE,
1046: 1,
1047: SYSDATE,
1048: NULL,
1049: fnd_global.conc_request_id,
1050: fnd_global.prog_appl_id,
1051: fnd_global.conc_program_id,
1052: SYSDATE,
1053: inq_rec.org_id,

Line 1050: fnd_global.prog_appl_id,

1046: 1,
1047: SYSDATE,
1048: NULL,
1049: fnd_global.conc_request_id,
1050: fnd_global.prog_appl_id,
1051: fnd_global.conc_program_id,
1052: SYSDATE,
1053: inq_rec.org_id,
1054: igs_ad_contacts_int_s.nextval,

Line 1051: fnd_global.conc_program_id,

1047: SYSDATE,
1048: NULL,
1049: fnd_global.conc_request_id,
1050: fnd_global.prog_appl_id,
1051: fnd_global.conc_program_id,
1052: SYSDATE,
1053: inq_rec.org_id,
1054: igs_ad_contacts_int_s.nextval,
1055: l_interface_id,

Line 1113: fnd_global.conc_request_id,

1109: SYSDATE,
1110: 1,
1111: SYSDATE,
1112: NULL,
1113: fnd_global.conc_request_id,
1114: fnd_global.prog_appl_id,
1115: fnd_global.conc_program_id,
1116: SYSDATE,
1117: inq_rec.org_id,

Line 1114: fnd_global.prog_appl_id,

1110: 1,
1111: SYSDATE,
1112: NULL,
1113: fnd_global.conc_request_id,
1114: fnd_global.prog_appl_id,
1115: fnd_global.conc_program_id,
1116: SYSDATE,
1117: inq_rec.org_id,
1118: igs_ad_contacts_int_s.nextval,

Line 1115: fnd_global.conc_program_id,

1111: SYSDATE,
1112: NULL,
1113: fnd_global.conc_request_id,
1114: fnd_global.prog_appl_id,
1115: fnd_global.conc_program_id,
1116: SYSDATE,
1117: inq_rec.org_id,
1118: igs_ad_contacts_int_s.nextval,
1119: l_interface_id,

Line 1211: fnd_global.conc_request_id,

1207: null ,
1208: '2' ,
1209: null ,
1210: 1 ,
1211: fnd_global.conc_request_id,
1212: fnd_global.prog_appl_id,
1213: fnd_global.conc_program_id,
1214: sysdate,
1215: null ,

Line 1212: fnd_global.prog_appl_id,

1208: '2' ,
1209: null ,
1210: 1 ,
1211: fnd_global.conc_request_id,
1212: fnd_global.prog_appl_id,
1213: fnd_global.conc_program_id,
1214: sysdate,
1215: null ,
1216: null ,

Line 1213: fnd_global.conc_program_id,

1209: null ,
1210: 1 ,
1211: fnd_global.conc_request_id,
1212: fnd_global.prog_appl_id,
1213: fnd_global.conc_program_id,
1214: sysdate,
1215: null ,
1216: null ,
1217: null ,

Line 1264: fnd_global.conc_request_id,

1260: match_ind
1261: ) VALUES
1262: (
1263: null ,
1264: fnd_global.conc_request_id,
1265: fnd_global.prog_appl_id,
1266: fnd_global.conc_program_id,
1267: sysdate ,
1268: igs_ad_addr_int_s.currval,

Line 1265: fnd_global.prog_appl_id,

1261: ) VALUES
1262: (
1263: null ,
1264: fnd_global.conc_request_id,
1265: fnd_global.prog_appl_id,
1266: fnd_global.conc_program_id,
1267: sysdate ,
1268: igs_ad_addr_int_s.currval,
1269: inq_rec.org_id ,

Line 1266: fnd_global.conc_program_id,

1262: (
1263: null ,
1264: fnd_global.conc_request_id,
1265: fnd_global.prog_appl_id,
1266: fnd_global.conc_program_id,
1267: sysdate ,
1268: igs_ad_addr_int_s.currval,
1269: inq_rec.org_id ,
1270: igs_ad_addrusage_int_s.nextval,

Line 1389: fnd_global.conc_request_id ,

1385: sysdate ,
1386: 1 ,
1387: sysdate ,
1388: null ,
1389: fnd_global.conc_request_id ,
1390: fnd_global.prog_appl_id ,
1391: fnd_global.conc_program_id ,
1392: sysdate ,
1393: null ,

Line 1390: fnd_global.prog_appl_id ,

1386: 1 ,
1387: sysdate ,
1388: null ,
1389: fnd_global.conc_request_id ,
1390: fnd_global.prog_appl_id ,
1391: fnd_global.conc_program_id ,
1392: sysdate ,
1393: null ,
1394: igs_ad_acadhis_int_s.nextval ,

Line 1391: fnd_global.conc_program_id ,

1387: sysdate ,
1388: null ,
1389: fnd_global.conc_request_id ,
1390: fnd_global.prog_appl_id ,
1391: fnd_global.conc_program_id ,
1392: sysdate ,
1393: null ,
1394: igs_ad_acadhis_int_s.nextval ,
1395: l_interface_id ,

Line 1504: fnd_global.conc_request_id,

1500: sysdate ,
1501: 1 ,
1502: sysdate ,
1503: null ,
1504: fnd_global.conc_request_id,
1505: fnd_global.prog_appl_id,
1506: fnd_global.conc_program_id,
1507: sysdate ,
1508: inq_per_extra_rec.interest_type_code ,

Line 1505: fnd_global.prog_appl_id,

1501: 1 ,
1502: sysdate ,
1503: null ,
1504: fnd_global.conc_request_id,
1505: fnd_global.prog_appl_id,
1506: fnd_global.conc_program_id,
1507: sysdate ,
1508: inq_per_extra_rec.interest_type_code ,
1509: null ,

Line 1506: fnd_global.conc_program_id,

1502: sysdate ,
1503: null ,
1504: fnd_global.conc_request_id,
1505: fnd_global.prog_appl_id,
1506: fnd_global.conc_program_id,
1507: sysdate ,
1508: inq_per_extra_rec.interest_type_code ,
1509: null ,
1510: null ,

Line 1584: fnd_global.conc_request_id,

1580: sysdate ,
1581: 1 ,
1582: sysdate ,
1583: null ,
1584: fnd_global.conc_request_id,
1585: fnd_global.prog_appl_id,
1586: fnd_global.conc_program_id,
1587: sysdate
1588: );

Line 1585: fnd_global.prog_appl_id,

1581: 1 ,
1582: sysdate ,
1583: null ,
1584: fnd_global.conc_request_id,
1585: fnd_global.prog_appl_id,
1586: fnd_global.conc_program_id,
1587: sysdate
1588: );
1589: EXCEPTION WHEN OTHERS THEN

Line 1586: fnd_global.conc_program_id,

1582: sysdate ,
1583: null ,
1584: fnd_global.conc_request_id,
1585: fnd_global.prog_appl_id,
1586: fnd_global.conc_program_id,
1587: sysdate
1588: );
1589: EXCEPTION WHEN OTHERS THEN
1590: l_status:=0;

Line 1655: fnd_global.conc_request_id ,

1651: sysdate ,
1652: 1 ,
1653: sysdate ,
1654: null ,
1655: fnd_global.conc_request_id ,
1656: fnd_global.prog_appl_id ,
1657: fnd_global.conc_program_id ,
1658: sysdate ,
1659: igs_ad_test_segs_int_s.nextval ,

Line 1656: fnd_global.prog_appl_id ,

1652: 1 ,
1653: sysdate ,
1654: null ,
1655: fnd_global.conc_request_id ,
1656: fnd_global.prog_appl_id ,
1657: fnd_global.conc_program_id ,
1658: sysdate ,
1659: igs_ad_test_segs_int_s.nextval ,
1660: igs_ad_test_int_s.currval ,

Line 1657: fnd_global.conc_program_id ,

1653: sysdate ,
1654: null ,
1655: fnd_global.conc_request_id ,
1656: fnd_global.prog_appl_id ,
1657: fnd_global.conc_program_id ,
1658: sysdate ,
1659: igs_ad_test_segs_int_s.nextval ,
1660: igs_ad_test_int_s.currval ,
1661: inq_per_test_rec.admission_test_type,

Line 1719: fnd_global.conc_request_id ,

1715: sysdate ,
1716: 1 ,
1717: sysdate ,
1718: null ,
1719: fnd_global.conc_request_id ,
1720: fnd_global.prog_appl_id ,
1721: fnd_global.conc_program_id ,
1722: sysdate
1723: );

Line 1720: fnd_global.prog_appl_id ,

1716: 1 ,
1717: sysdate ,
1718: null ,
1719: fnd_global.conc_request_id ,
1720: fnd_global.prog_appl_id ,
1721: fnd_global.conc_program_id ,
1722: sysdate
1723: );
1724: EXCEPTION WHEN OTHERS THEN

Line 1721: fnd_global.conc_program_id ,

1717: sysdate ,
1718: null ,
1719: fnd_global.conc_request_id ,
1720: fnd_global.prog_appl_id ,
1721: fnd_global.conc_program_id ,
1722: sysdate
1723: );
1724: EXCEPTION WHEN OTHERS THEN
1725: l_status:=0;

Line 1779: fnd_global.conc_request_id,

1775: sysdate ,
1776: 1 ,
1777: sysdate ,
1778: null ,
1779: fnd_global.conc_request_id,
1780: fnd_global.prog_appl_id,
1781: fnd_global.conc_program_id,
1782: sysdate
1783: );

Line 1780: fnd_global.prog_appl_id,

1776: 1 ,
1777: sysdate ,
1778: null ,
1779: fnd_global.conc_request_id,
1780: fnd_global.prog_appl_id,
1781: fnd_global.conc_program_id,
1782: sysdate
1783: );
1784: EXCEPTION WHEN OTHERS THEN

Line 1781: fnd_global.conc_program_id,

1777: sysdate ,
1778: null ,
1779: fnd_global.conc_request_id,
1780: fnd_global.prog_appl_id,
1781: fnd_global.conc_program_id,
1782: sysdate
1783: );
1784: EXCEPTION WHEN OTHERS THEN
1785: l_status:=0;

Line 1827: fnd_global.conc_request_id,

1823: inq_per_race_rec.race_cd,
1824: '2',
1825: null,
1826: null,
1827: fnd_global.conc_request_id,
1828: fnd_global.conc_program_id,
1829: fnd_global.prog_appl_id,
1830: sysdate,
1831: 1,

Line 1828: fnd_global.conc_program_id,

1824: '2',
1825: null,
1826: null,
1827: fnd_global.conc_request_id,
1828: fnd_global.conc_program_id,
1829: fnd_global.prog_appl_id,
1830: sysdate,
1831: 1,
1832: sysdate,

Line 1829: fnd_global.prog_appl_id,

1825: null,
1826: null,
1827: fnd_global.conc_request_id,
1828: fnd_global.conc_program_id,
1829: fnd_global.prog_appl_id,
1830: sysdate,
1831: 1,
1832: sysdate,
1833: 1,