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.

[Home] [Help]

APPS.PY_W2_DBITEMS dependencies on FF_ROUTES

Line 25: select ff_routes_s.currval,

21: insert into ff_route_context_usages
22: (route_id,
23: context_id,
24: sequence_no)
25: select ff_routes_s.currval,
26: p_context_id,
27: p_sequence_no
28: from dual;
29: end insert_route_context_usages; -- ]

Line 59: ff_routes_s.currval,

55: --
56: values (ff_user_entities_s.nextval,
57: null,
58: 'US',
59: ff_routes_s.currval,
60: 'N',
61: p_user_entity_name ,
62: 0,
63: 'SEH', /* SEH */

Line 164: insert into ff_routes

160: ) is
161: begin -- [
162: hr_utility.trace ('creating route : ' || p_route_name);
163: hr_utility.set_location('gbstrdbi.insert_route', 1);
164: insert into ff_routes
165: (route_id,
166: route_name,
167: user_defined_flag,
168: description,

Line 175: values (ff_routes_s.nextval,

171: last_updated_by,
172: last_update_login,
173: created_by,
174: creation_date)
175: values (ff_routes_s.nextval,
176: p_route_name,
177: 'N',
178: p_description,
179: p_text,

Line 427: from ff_routes where route_name = 'EMPLOYER_ARCHIVE';

423:
424: hr_utility.trace('selecting the route_id for EMPLOYER_ARCHIVE');
425:
426: select route_id into l_route_id
427: from ff_routes where route_name = 'EMPLOYER_ARCHIVE';
428:
429: hr_utility.trace('updating the route text for EMPLOYER_ARCHIVE');
430:
431: update ff_routes

Line 431: update ff_routes

427: from ff_routes where route_name = 'EMPLOYER_ARCHIVE';
428:
429: hr_utility.trace('updating the route text for EMPLOYER_ARCHIVE');
430:
431: update ff_routes
432: set text = l_text
433: where route_id = l_route_id;
434:
435: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_ARCHIVE');

Line 468: hr_utility.trace('inserting ff_routes for EMPLOYER_ARCHIVE');

464: end if;
465: close c_check_context;
466:
467: EXCEPTION WHEN NO_DATA_FOUND THEN
468: hr_utility.trace('inserting ff_routes for EMPLOYER_ARCHIVE');
469:
470: insert into ff_routes
471: (route_id,
472: route_name,

Line 470: insert into ff_routes

466:
467: EXCEPTION WHEN NO_DATA_FOUND THEN
468: hr_utility.trace('inserting ff_routes for EMPLOYER_ARCHIVE');
469:
470: insert into ff_routes
471: (route_id,
472: route_name,
473: user_defined_flag,
474: description,

Line 481: values (ff_routes_s.nextval,

477: last_updated_by,
478: last_update_login,
479: created_by,
480: creation_date)
481: values (ff_routes_s.nextval,
482: 'EMPLOYER_ARCHIVE',
483: 'N',
484: 'sql to retrieve GRE based archived items',
485: l_text,

Line 502: ff_routes_s.currval,

498: DATA_TYPE,
499: PARAMETER_NAME,
500: SEQUENCE_NO )
501: select ff_route_parameters_s.nextval,
502: ff_routes_s.currval,
503: 'N',
504: 'User Entity ID',
505: 1 from dual;
506:

Line 515: select ff_routes_s.currval,

511: insert into ff_route_context_usages
512: (route_id,
513: context_id,
514: sequence_no)
515: select ff_routes_s.currval,
516: l_payroll_action_context_id,
517: 1
518: from dual;
519:

Line 526: select ff_routes_s.currval,

522: insert into ff_route_context_usages
523: (route_id,
524: context_id,
525: sequence_no)
526: select ff_routes_s.currval,
527: l_tax_unit_context_id,
528: 2
529: from dual;
530:

Line 550: from ff_routes where route_name = 'EMPLOYER_ARCHIVE_DATE';

546: and ltrim(rtrim(con2.context)) = to_char(&B2)
547: /* 2nd context of tax_unit_id */';
548:
549: select route_id into l_route_id
550: from ff_routes where route_name = 'EMPLOYER_ARCHIVE_DATE';
551:
552: update ff_routes
553: set text = l_text
554: where route_id = l_route_id;

Line 552: update ff_routes

548:
549: select route_id into l_route_id
550: from ff_routes where route_name = 'EMPLOYER_ARCHIVE_DATE';
551:
552: update ff_routes
553: set text = l_text
554: where route_id = l_route_id;
555:
556: /* delete ff_route_context_usages

Line 584: insert into ff_routes

580:
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN
583:
584: insert into ff_routes
585: (route_id,
586: route_name,
587: user_defined_flag,
588: description,

Line 595: values (ff_routes_s.nextval,

591: last_updated_by,
592: last_update_login,
593: created_by,
594: creation_date)
595: values (ff_routes_s.nextval,
596: 'EMPLOYER_ARCHIVE_DATE',
597: 'N',
598: 'sql to retrieve GRE based date archived items',
599: l_text,

Line 615: ff_routes_s.currval,

611: DATA_TYPE,
612: PARAMETER_NAME,
613: SEQUENCE_NO )
614: select ff_route_parameters_s.nextval,
615: ff_routes_s.currval,
616: 'N',
617: 'User Entity ID',
618: 1 from dual;
619:

Line 626: select ff_routes_s.currval,

622: insert into ff_route_context_usages
623: (route_id,
624: context_id,
625: sequence_no)
626: select ff_routes_s.currval,
627: l_payroll_action_context_id,
628: 1
629: from dual;
630:

Line 635: select ff_routes_s.currval,

631: insert into ff_route_context_usages
632: (route_id,
633: context_id,
634: sequence_no)
635: select ff_routes_s.currval,
636: l_tax_unit_context_id,
637: 2
638: from dual;
639:

Line 659: from ff_routes where route_name = 'EMPLOYER_ARCHIVE_NUMBER';

655: and trim(rtrim(con2.context)) = to_char(&B2)
656: /* 2nd context of tax_unit_id */';
657:
658: select route_id into l_route_id
659: from ff_routes where route_name = 'EMPLOYER_ARCHIVE_NUMBER';
660:
661: update ff_routes
662: set text = l_text
663: where route_id = l_route_id;

Line 661: update ff_routes

657:
658: select route_id into l_route_id
659: from ff_routes where route_name = 'EMPLOYER_ARCHIVE_NUMBER';
660:
661: update ff_routes
662: set text = l_text
663: where route_id = l_route_id;
664:
665: /* delete ff_route_context_usages

Line 695: insert into ff_routes

691:
692: EXCEPTION
693: WHEN NO_DATA_FOUND THEN
694:
695: insert into ff_routes
696: (route_id,
697: route_name,
698: user_defined_flag,
699: description,

Line 706: values (ff_routes_s.nextval,

702: last_updated_by,
703: last_update_login,
704: created_by,
705: creation_date)
706: values (ff_routes_s.nextval,
707: 'EMPLOYER_ARCHIVE_NUMBER',
708: 'N',
709: 'sql to retrieve GRE based numeric archived items',
710: l_text,

Line 726: ff_routes_s.currval,

722: DATA_TYPE,
723: PARAMETER_NAME,
724: SEQUENCE_NO )
725: select ff_route_parameters_s.nextval,
726: ff_routes_s.currval,
727: 'N',
728: 'User Entity ID',
729: 1 from dual;
730:

Line 737: select ff_routes_s.currval,

733: insert into ff_route_context_usages
734: (route_id,
735: context_id,
736: sequence_no)
737: select ff_routes_s.currval,
738: l_payroll_action_context_id,
739: 1
740: from dual;
741:

Line 746: select ff_routes_s.currval,

742: insert into ff_route_context_usages
743: (route_id,
744: context_id,
745: sequence_no)
746: select ff_routes_s.currval,
747: l_tax_unit_context_id,
748: 2
749: from dual;
750:

Line 782: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';

778:
779: hr_utility.trace('selecting route id for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
780:
781: select route_id into l_route_id
782: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
783:
784: hr_utility.trace('updating ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
785:
786: update ff_routes

Line 784: hr_utility.trace('updating ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');

780:
781: select route_id into l_route_id
782: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
783:
784: hr_utility.trace('updating ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
785:
786: update ff_routes
787: set text = l_text
788: where route_id = l_route_id;

Line 786: update ff_routes

782: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
783:
784: hr_utility.trace('updating ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
785:
786: update ff_routes
787: set text = l_text
788: where route_id = l_route_id;
789:
790: hr_utility.trace('deleting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');

Line 790: hr_utility.trace('deleting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');

786: update ff_routes
787: set text = l_text
788: where route_id = l_route_id;
789:
790: hr_utility.trace('deleting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
791:
792: /* delete ff_route_context_usages
793: where route_id = l_route_id; */
794:

Line 818: insert into ff_routes

814: end if;
815: close c_check_context;
816:
817: EXCEPTION WHEN NO_DATA_FOUND THEN
818: insert into ff_routes
819: (route_id,
820: route_name,
821: user_defined_flag,
822: description,

Line 829: values (ff_routes_s.nextval,

825: last_updated_by,
826: last_update_login,
827: created_by,
828: creation_date)
829: values (ff_routes_s.nextval,
830: 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE',
831: 'N',
832: 'sql to retrieve GRE based employer archived items',
833: l_text,

Line 848: ff_routes_s.currval,

844: DATA_TYPE,
845: PARAMETER_NAME,
846: SEQUENCE_NO )
847: select ff_route_parameters_s.nextval,
848: ff_routes_s.currval,
849: 'N',
850: 'User Entity ID',
851: 1 from dual;
852:

Line 859: select ff_routes_s.currval,

855: insert into ff_route_context_usages
856: (route_id,
857: context_id,
858: sequence_no)
859: select ff_routes_s.currval,
860: l_payroll_action_context_id,
861: 1
862: from dual;
863:

Line 868: select ff_routes_s.currval,

864: insert into ff_route_context_usages
865: (route_id,
866: context_id,
867: sequence_no)
868: select ff_routes_s.currval,
869: l_tax_unit_context_id,
870: 2
871: from dual;
872:

Line 905: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';

901:
902: hr_utility.trace('selecting route_id for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
903:
904: select route_id into l_route_id
905: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';
906:
907: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
908:
909:

Line 910: update ff_routes

906:
907: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
908:
909:
910: update ff_routes
911: set text = l_text
912: where route_id = l_route_id;
913:
914: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

Line 948: hr_utility.trace('inserting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');

944: close c_check_context;
945:
946:
947: EXCEPTION WHEN NO_DATA_FOUND THEN
948: hr_utility.trace('inserting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
949:
950: insert into ff_routes
951: (route_id,
952: route_name,

Line 950: insert into ff_routes

946:
947: EXCEPTION WHEN NO_DATA_FOUND THEN
948: hr_utility.trace('inserting ff_routes for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
949:
950: insert into ff_routes
951: (route_id,
952: route_name,
953: user_defined_flag,
954: description,

Line 961: values (ff_routes_s.nextval,

957: last_updated_by,
958: last_update_login,
959: created_by,
960: creation_date)
961: values (ff_routes_s.nextval,
962: 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER',
963: 'N',
964: 'sql to retrieve GRE based employer archived items',
965: l_text,

Line 980: ff_routes_s.currval,

976: DATA_TYPE,
977: PARAMETER_NAME,
978: SEQUENCE_NO )
979: select ff_route_parameters_s.nextval,
980: ff_routes_s.currval,
981: 'N',
982: 'User Entity ID',
983: 1 from dual;
984:

Line 991: select ff_routes_s.currval,

987: insert into ff_route_context_usages
988: (route_id,
989: context_id,
990: sequence_no)
991: select ff_routes_s.currval,
992: l_payroll_action_context_id,
993: 1
994: from dual;
995:

Line 1000: select ff_routes_s.currval,

996: insert into ff_route_context_usages
997: (route_id,
998: context_id,
999: sequence_no)
1000: select ff_routes_s.currval,
1001: l_tax_unit_context_id,
1002: 2
1003: from dual;
1004:

Line 1036: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';

1032:
1033: hr_utility.trace('selecting route_id for EMPLOYER_TAX_UNIT_ARCHIVE');
1034:
1035: select route_id into l_route_id
1036: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
1037:
1038: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE');
1039:
1040: update ff_routes

Line 1040: update ff_routes

1036: from ff_routes where route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
1037:
1038: hr_utility.trace('updating route_text for EMPLOYER_TAX_UNIT_ARCHIVE');
1039:
1040: update ff_routes
1041: set text = l_text
1042: where route_id = l_route_id;
1043:
1044: hr_utility.trace('deleting ff_route_context_usages for EMPLOYER_TAX_UNIT_ARCHIVE');

Line 1077: insert into ff_routes

1073: close c_check_context;
1074:
1075:
1076: EXCEPTION WHEN NO_DATA_FOUND THEN
1077: insert into ff_routes
1078: (route_id,
1079: route_name,
1080: user_defined_flag,
1081: description,

Line 1088: values (ff_routes_s.nextval,

1084: last_updated_by,
1085: last_update_login,
1086: created_by,
1087: creation_date)
1088: values (ff_routes_s.nextval,
1089: 'EMPLOYER_TAX_UNIT_ARCHIVE',
1090: 'N',
1091: 'sql to retrieve GRE based employer archived items',
1092: l_text,

Line 1107: ff_routes_s.currval,

1103: DATA_TYPE,
1104: PARAMETER_NAME,
1105: SEQUENCE_NO )
1106: select ff_route_parameters_s.nextval,
1107: ff_routes_s.currval,
1108: 'N',
1109: 'User Entity ID',
1110: 1 from dual;
1111:

Line 1118: select ff_routes_s.currval,

1114: insert into ff_route_context_usages
1115: (route_id,
1116: context_id,
1117: sequence_no)
1118: select ff_routes_s.currval,
1119: l_payroll_action_context_id,
1120: 1
1121: from dual;
1122:

Line 1127: select ff_routes_s.currval,

1123: insert into ff_route_context_usages
1124: (route_id,
1125: context_id,
1126: sequence_no)
1127: select ff_routes_s.currval,
1128: l_tax_unit_context_id,
1129: 2
1130: from dual;
1131:

Line 1167: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE';

1163: and substr(ltrim(rtrim(con3.context)),1,&U2) = substr(&B3,1,&U2)
1164: /* 3rd context of jurisdiction code */';
1165:
1166: select route_id into l_route_id
1167: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE';
1168:
1169: update ff_routes
1170: set text = l_text
1171: where route_id = l_route_id;

Line 1169: update ff_routes

1165:
1166: select route_id into l_route_id
1167: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE';
1168:
1169: update ff_routes
1170: set text = l_text
1171: where route_id = l_route_id;
1172:
1173: /* delete ff_route_context_usages

Line 1209: insert into ff_routes

1205: close c_check_context;
1206:
1207:
1208: EXCEPTION WHEN NO_DATA_FOUND THEN
1209: insert into ff_routes
1210: (route_id,
1211: route_name,
1212: user_defined_flag,
1213: description,

Line 1220: values (ff_routes_s.nextval,

1216: last_updated_by,
1217: last_update_login,
1218: created_by,
1219: creation_date)
1220: values (ff_routes_s.nextval,
1221: 'EMPLOYER_JURSD_ARCHIVE',
1222: 'N',
1223: 'sql to retrieve GRE based employer archived items',
1224: l_text,

Line 1239: ff_routes_s.currval,

1235: DATA_TYPE,
1236: PARAMETER_NAME,
1237: SEQUENCE_NO )
1238: select ff_route_parameters_s.nextval,
1239: ff_routes_s.currval,
1240: 'N',
1241: 'User Entity ID',
1242: 1 from dual;
1243:

Line 1250: select ff_routes_s.currval,

1246: insert into ff_route_context_usages
1247: (route_id,
1248: context_id,
1249: sequence_no)
1250: select ff_routes_s.currval,
1251: l_payroll_action_context_id,
1252: 1
1253: from dual;
1254:

Line 1259: select ff_routes_s.currval,

1255: insert into ff_route_context_usages
1256: (route_id,
1257: context_id,
1258: sequence_no)
1259: select ff_routes_s.currval,
1260: l_tax_unit_context_id,
1261: 2
1262: from dual;
1263:

Line 1268: select ff_routes_s.currval,

1264: insert into ff_route_context_usages
1265: (route_id,
1266: context_id,
1267: sequence_no)
1268: select ff_routes_s.currval,
1269: l_jurisdiction_context_id,
1270: 3
1271: from dual;
1272: END;

Line 1307: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE_DATE';

1303: and substr(ltrim(rtrim(con3.context)),1,&U2) = substr(&B3,1,&U2)
1304: /* 3rd context of jurisdiction code */';
1305:
1306: select route_id into l_route_id
1307: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE_DATE';
1308:
1309: update ff_routes
1310: set text = l_text
1311: where route_id = l_route_id;

Line 1309: update ff_routes

1305:
1306: select route_id into l_route_id
1307: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE_DATE';
1308:
1309: update ff_routes
1310: set text = l_text
1311: where route_id = l_route_id;
1312:
1313: /* delete ff_route_context_usages

Line 1349: insert into ff_routes

1345: close c_check_context;
1346:
1347:
1348: EXCEPTION WHEN NO_DATA_FOUND THEN
1349: insert into ff_routes
1350: (route_id,
1351: route_name,
1352: user_defined_flag,
1353: description,

Line 1360: values (ff_routes_s.nextval,

1356: last_updated_by,
1357: last_update_login,
1358: created_by,
1359: creation_date)
1360: values (ff_routes_s.nextval,
1361: 'EMPLOYER_JURSD_ARCHIVE_DATE',
1362: 'N',
1363: 'sql to retrieve GRE based employer archived items',
1364: l_text,

Line 1379: ff_routes_s.currval,

1375: DATA_TYPE,
1376: PARAMETER_NAME,
1377: SEQUENCE_NO )
1378: select ff_route_parameters_s.nextval,
1379: ff_routes_s.currval,
1380: 'N',
1381: 'User Entity ID',
1382: 1 from dual;
1383:

Line 1390: select ff_routes_s.currval,

1386: insert into ff_route_context_usages
1387: (route_id,
1388: context_id,
1389: sequence_no)
1390: select ff_routes_s.currval,
1391: l_payroll_action_context_id,
1392: 1
1393: from dual;
1394:

Line 1399: select ff_routes_s.currval,

1395: insert into ff_route_context_usages
1396: (route_id,
1397: context_id,
1398: sequence_no)
1399: select ff_routes_s.currval,
1400: l_tax_unit_context_id,
1401: 2
1402: from dual;
1403:

Line 1408: select ff_routes_s.currval,

1404: insert into ff_route_context_usages
1405: (route_id,
1406: context_id,
1407: sequence_no)
1408: select ff_routes_s.currval,
1409: l_jurisdiction_context_id,
1410: 3
1411: from dual;
1412: END;

Line 1447: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE_NUMBER';

1443: and substr(ltrim(rtrim(con3.context)),1,&U2) = substr(&B3,1,&U2)
1444: /* 3rd context of jurisdiction code */';
1445:
1446: select route_id into l_route_id
1447: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE_NUMBER';
1448:
1449: update ff_routes
1450: set text = l_text
1451: where route_id = l_route_id;

Line 1449: update ff_routes

1445:
1446: select route_id into l_route_id
1447: from ff_routes where route_name = 'EMPLOYER_JURSD_ARCHIVE_NUMBER';
1448:
1449: update ff_routes
1450: set text = l_text
1451: where route_id = l_route_id;
1452:
1453: /* delete ff_route_context_usages

Line 1489: insert into ff_routes

1485: close c_check_context;
1486:
1487:
1488: EXCEPTION WHEN NO_DATA_FOUND THEN
1489: insert into ff_routes
1490: (route_id,
1491: route_name,
1492: user_defined_flag,
1493: description,

Line 1500: values (ff_routes_s.nextval,

1496: last_updated_by,
1497: last_update_login,
1498: created_by,
1499: creation_date)
1500: values (ff_routes_s.nextval,
1501: 'EMPLOYER_JURSD_ARCHIVE_NUMBER',
1502: 'N',
1503: 'sql to retrieve GRE based employer archived items',
1504: l_text,

Line 1519: ff_routes_s.currval,

1515: DATA_TYPE,
1516: PARAMETER_NAME,
1517: SEQUENCE_NO )
1518: select ff_route_parameters_s.nextval,
1519: ff_routes_s.currval,
1520: 'N',
1521: 'User Entity ID',
1522: 1 from dual;
1523:

Line 1530: select ff_routes_s.currval,

1526: insert into ff_route_context_usages
1527: (route_id,
1528: context_id,
1529: sequence_no)
1530: select ff_routes_s.currval,
1531: l_payroll_action_context_id,
1532: 1
1533: from dual;
1534:

Line 1539: select ff_routes_s.currval,

1535: insert into ff_route_context_usages
1536: (route_id,
1537: context_id,
1538: sequence_no)
1539: select ff_routes_s.currval,
1540: l_tax_unit_context_id,
1541: 2
1542: from dual;
1543:

Line 1548: select ff_routes_s.currval,

1544: insert into ff_route_context_usages
1545: (route_id,
1546: context_id,
1547: sequence_no)
1548: select ff_routes_s.currval,
1549: l_jurisdiction_context_id,
1550: 3
1551: from dual;
1552: END;

Line 1564: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE';

1560: and target.context1 = to_char(&B1)
1561: /* context of assignment action id */';
1562:
1563: select route_id into l_route_id
1564: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE';
1565:
1566: update ff_routes
1567: set text = l_text
1568: where route_id = l_route_id;

Line 1566: update ff_routes

1562:
1563: select route_id into l_route_id
1564: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE';
1565:
1566: update ff_routes
1567: set text = l_text
1568: where route_id = l_route_id;
1569:
1570: EXCEPTION

Line 1573: insert into ff_routes

1569:
1570: EXCEPTION
1571: WHEN NO_DATA_FOUND THEN
1572:
1573: insert into ff_routes
1574: (route_id,
1575: route_name,
1576: user_defined_flag,
1577: description,

Line 1584: values (ff_routes_s.nextval,

1580: last_updated_by,
1581: last_update_login,
1582: created_by,
1583: creation_date)
1584: values (ff_routes_s.nextval,
1585: 'ASSIGNMENT_ARCHIVE',
1586: 'N',
1587: 'sql to retrieve Assignment based archived items',
1588: l_text,

Line 1603: ff_routes_s.currval,

1599: DATA_TYPE,
1600: PARAMETER_NAME,
1601: SEQUENCE_NO )
1602: select ff_route_parameters_s.nextval,
1603: ff_routes_s.currval,
1604: 'N',
1605: 'User Entity ID',
1606: 1 from dual;
1607:

Line 1614: select ff_routes_s.currval,

1610: insert into ff_route_context_usages
1611: (route_id,
1612: context_id,
1613: sequence_no)
1614: select ff_routes_s.currval,
1615: l_assignment_action_context_id,
1616: 1
1617: from dual;
1618:

Line 1631: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE_DATE';

1627: and target.context1 = to_char(&B1)
1628: /* context of assignment action id */';
1629:
1630: select route_id into l_route_id
1631: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE_DATE';
1632:
1633: update ff_routes
1634: set text = l_text
1635: where route_id = l_route_id;

Line 1633: update ff_routes

1629:
1630: select route_id into l_route_id
1631: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE_DATE';
1632:
1633: update ff_routes
1634: set text = l_text
1635: where route_id = l_route_id;
1636:
1637: EXCEPTION

Line 1640: insert into ff_routes

1636:
1637: EXCEPTION
1638: WHEN NO_DATA_FOUND THEN
1639:
1640: insert into ff_routes
1641: (route_id,
1642: route_name,
1643: user_defined_flag,
1644: description,

Line 1651: values (ff_routes_s.nextval,

1647: last_updated_by,
1648: last_update_login,
1649: created_by,
1650: creation_date)
1651: values (ff_routes_s.nextval,
1652: 'ASSIGNMENT_ARCHIVE_DATE',
1653: 'N',
1654: 'sql to retrieve Assignment based archived items',
1655: l_text,

Line 1670: ff_routes_s.currval,

1666: DATA_TYPE,
1667: PARAMETER_NAME,
1668: SEQUENCE_NO )
1669: select ff_route_parameters_s.nextval,
1670: ff_routes_s.currval,
1671: 'N',
1672: 'User Entity ID',
1673: 1 from dual;
1674:

Line 1681: select ff_routes_s.currval,

1677: insert into ff_route_context_usages
1678: (route_id,
1679: context_id,
1680: sequence_no)
1681: select ff_routes_s.currval,
1682: l_assignment_action_context_id,
1683: 1
1684: from dual;
1685:

Line 1698: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';

1694: and target.context1 = to_char(&B1)
1695: /* context of assignment action id */';
1696:
1697: select route_id into l_route_id
1698: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
1699:
1700: update ff_routes
1701: set text = l_text
1702: where route_id = l_route_id;

Line 1700: update ff_routes

1696:
1697: select route_id into l_route_id
1698: from ff_routes where route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
1699:
1700: update ff_routes
1701: set text = l_text
1702: where route_id = l_route_id;
1703:
1704: EXCEPTION

Line 1707: insert into ff_routes

1703:
1704: EXCEPTION
1705: WHEN NO_DATA_FOUND THEN
1706:
1707: insert into ff_routes
1708: (route_id,
1709: route_name,
1710: user_defined_flag,
1711: description,

Line 1718: values (ff_routes_s.nextval,

1714: last_updated_by,
1715: last_update_login,
1716: created_by,
1717: creation_date)
1718: values (ff_routes_s.nextval,
1719: 'ASSIGNMENT_ARCHIVE_NUMBER', 'N',
1720: 'sql to retrieve Assignment based archived items',
1721: l_text,
1722: sysdate,

Line 1736: ff_routes_s.currval,

1732: DATA_TYPE,
1733: PARAMETER_NAME,
1734: SEQUENCE_NO )
1735: select ff_route_parameters_s.nextval,
1736: ff_routes_s.currval,
1737: 'N',
1738: 'User Entity ID',
1739: 1 from dual;
1740:

Line 1747: select ff_routes_s.currval,

1743: insert into ff_route_context_usages
1744: (route_id,
1745: context_id,
1746: sequence_no)
1747: select ff_routes_s.currval,
1748: l_assignment_action_context_id,
1749: 1
1750: from dual;
1751: END;

Line 1775: from ff_routes where route_name = 'ASSIGNMENT_GRE_ARCHIVE';

1771: and ltrim(rtrim(con2.context)) = to_char(&B2)
1772: /* 2nd context of tax_unit_id */';
1773:
1774: select route_id into l_route_id
1775: from ff_routes where route_name = 'ASSIGNMENT_GRE_ARCHIVE';
1776:
1777: update ff_routes
1778: set text = l_text
1779: where route_id = l_route_id;

Line 1777: update ff_routes

1773:
1774: select route_id into l_route_id
1775: from ff_routes where route_name = 'ASSIGNMENT_GRE_ARCHIVE';
1776:
1777: update ff_routes
1778: set text = l_text
1779: where route_id = l_route_id;
1780:
1781: EXCEPTION

Line 1783: insert into ff_routes

1779: where route_id = l_route_id;
1780:
1781: EXCEPTION
1782: WHEN NO_DATA_FOUND THEN
1783: insert into ff_routes
1784: (route_id,
1785: route_name,
1786: user_defined_flag,
1787: description,

Line 1794: values (ff_routes_s.nextval,

1790: last_updated_by,
1791: last_update_login,
1792: created_by,
1793: creation_date)
1794: values (ff_routes_s.nextval,
1795: 'ASSIGNMENT_GRE_ARCHIVE',
1796: 'N',
1797: 'sql to retrieve Assignment and GRE based archived items',
1798: l_text,

Line 1813: ff_routes_s.currval,

1809: DATA_TYPE,
1810: PARAMETER_NAME,
1811: SEQUENCE_NO )
1812: values (ff_route_parameters_s.nextval,
1813: ff_routes_s.currval,
1814: 'N',
1815: 'User Entity ID',
1816: 1);
1817:

Line 1824: values (ff_routes_s.currval,

1820: insert into ff_route_context_usages
1821: (route_id,
1822: context_id,
1823: sequence_no)
1824: values (ff_routes_s.currval,
1825: l_assignment_action_context_id,
1826: 1);
1827:
1828: insert into ff_route_context_usages

Line 1832: values (ff_routes_s.currval,

1828: insert into ff_route_context_usages
1829: (route_id,
1830: context_id,
1831: sequence_no)
1832: values (ff_routes_s.currval,
1833: l_tax_unit_context_id,
1834: 2);
1835:
1836: END;

Line 1861: from ff_routes where route_name = 'ASSIGNMENT_JD_ARCHIVE';

1857: and substr(con2.context,1,&U2) = substr(&B2,1,&U2)
1858: /* 2nd context of jurisdiction code */';
1859:
1860: select route_id into l_route_id
1861: from ff_routes where route_name = 'ASSIGNMENT_JD_ARCHIVE';
1862:
1863: update ff_routes
1864: set text = l_text
1865: where route_id = l_route_id;

Line 1863: update ff_routes

1859:
1860: select route_id into l_route_id
1861: from ff_routes where route_name = 'ASSIGNMENT_JD_ARCHIVE';
1862:
1863: update ff_routes
1864: set text = l_text
1865: where route_id = l_route_id;
1866:
1867: EXCEPTION

Line 1869: insert into ff_routes

1865: where route_id = l_route_id;
1866:
1867: EXCEPTION
1868: WHEN NO_DATA_FOUND THEN
1869: insert into ff_routes
1870: (route_id,
1871: route_name,
1872: user_defined_flag,
1873: description,

Line 1880: values (ff_routes_s.nextval,

1876: last_updated_by,
1877: last_update_login,
1878: created_by,
1879: creation_date)
1880: values (ff_routes_s.nextval,
1881: 'ASSIGNMENT_JD_ARCHIVE',
1882: 'N',
1883: 'sql to retrieve Assignment and JD based archived items',
1884: l_text,

Line 1899: ff_routes_s.currval,

1895: DATA_TYPE,
1896: PARAMETER_NAME,
1897: SEQUENCE_NO )
1898: values (ff_route_parameters_s.nextval,
1899: ff_routes_s.currval,
1900: 'N',
1901: 'User Entity ID',
1902: 1);
1903:

Line 1910: values (ff_routes_s.currval,

1906: insert into ff_route_context_usages
1907: (route_id,
1908: context_id,
1909: sequence_no)
1910: values (ff_routes_s.currval,
1911: l_assignment_action_context_id,
1912: 1);
1913:
1914: insert into ff_route_context_usages

Line 1918: values (ff_routes_s.currval,

1914: insert into ff_route_context_usages
1915: (route_id,
1916: context_id,
1917: sequence_no)
1918: values (ff_routes_s.currval,
1919: l_jurisdiction_context_id,
1920: 2);
1921:
1922: END;

Line 1952: from ff_routes where route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';

1948: and ltrim(rtrim(con3.context)) = &B3
1949: /* 3rd context of city jurisdiction_code*/';
1950:
1951: select route_id into l_route_id
1952: from ff_routes where route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';
1953:
1954: update ff_routes
1955: set text = l_text
1956: where route_id = l_route_id;

Line 1954: update ff_routes

1950:
1951: select route_id into l_route_id
1952: from ff_routes where route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';
1953:
1954: update ff_routes
1955: set text = l_text
1956: where route_id = l_route_id;
1957:
1958: EXCEPTION

Line 1961: insert into ff_routes

1957:
1958: EXCEPTION
1959: WHEN NO_DATA_FOUND THEN
1960:
1961: insert into ff_routes
1962: (route_id,
1963: route_name,
1964: user_defined_flag,
1965: description,

Line 1972: values (ff_routes_s.nextval,

1968: last_updated_by,
1969: last_update_login,
1970: created_by,
1971: creation_date)
1972: values (ff_routes_s.nextval,
1973: 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE',
1974: 'N',
1975: 'sql to retrieve Assignment,GRE and city JD based archived items',
1976: l_text,

Line 1991: ff_routes_s.currval,

1987: DATA_TYPE,
1988: PARAMETER_NAME,
1989: SEQUENCE_NO )
1990: values (ff_route_parameters_s.nextval,
1991: ff_routes_s.currval,
1992: 'N',
1993: 'User Entity ID',
1994: 1);
1995:

Line 2002: values (ff_routes_s.currval,

1998: insert into ff_route_context_usages
1999: (route_id,
2000: context_id,
2001: sequence_no)
2002: values (ff_routes_s.currval,
2003: l_assignment_action_context_id,
2004: 1);
2005:
2006: insert into ff_route_context_usages

Line 2010: values (ff_routes_s.currval,

2006: insert into ff_route_context_usages
2007: (route_id,
2008: context_id,
2009: sequence_no)
2010: values (ff_routes_s.currval,
2011: l_tax_unit_context_id,
2012: 2);
2013:
2014: insert into ff_route_context_usages

Line 2018: values (ff_routes_s.currval,

2014: insert into ff_route_context_usages
2015: (route_id,
2016: context_id,
2017: sequence_no)
2018: values (ff_routes_s.currval,
2019: l_jurisdiction_context_id,
2020: 3);
2021:
2022:

Line 2052: from ff_routes where route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';

2048: and substr(con3.context,1,6) = substr(&B3,1,6)
2049: /* 3rd context of county jurisdiction_code*/';
2050:
2051: select route_id into l_route_id
2052: from ff_routes where route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';
2053:
2054: update ff_routes
2055: set text = l_text
2056: where route_id = l_route_id;

Line 2054: update ff_routes

2050:
2051: select route_id into l_route_id
2052: from ff_routes where route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';
2053:
2054: update ff_routes
2055: set text = l_text
2056: where route_id = l_route_id;
2057:
2058: EXCEPTION

Line 2061: insert into ff_routes

2057:
2058: EXCEPTION
2059: WHEN NO_DATA_FOUND THEN
2060:
2061: insert into ff_routes
2062: (route_id,
2063: route_name,
2064: user_defined_flag,
2065: description,

Line 2072: values (ff_routes_s.nextval,

2068: last_updated_by,
2069: last_update_login,
2070: created_by,
2071: creation_date)
2072: values (ff_routes_s.nextval,
2073: 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE',
2074: 'N',
2075: 'sql to retrieve Assignment,GRE and county JD based archived items',
2076: l_text,

Line 2091: ff_routes_s.currval,

2087: DATA_TYPE,
2088: PARAMETER_NAME,
2089: SEQUENCE_NO )
2090: values (ff_route_parameters_s.nextval,
2091: ff_routes_s.currval,
2092: 'N',
2093: 'User Entity ID',
2094: 1);
2095:

Line 2102: values (ff_routes_s.currval,

2098: insert into ff_route_context_usages
2099: (route_id,
2100: context_id,
2101: sequence_no)
2102: values (ff_routes_s.currval,
2103: l_assignment_action_context_id,
2104: 1);
2105:
2106: insert into ff_route_context_usages

Line 2110: values (ff_routes_s.currval,

2106: insert into ff_route_context_usages
2107: (route_id,
2108: context_id,
2109: sequence_no)
2110: values (ff_routes_s.currval,
2111: l_tax_unit_context_id,
2112: 2);
2113:
2114: insert into ff_route_context_usages

Line 2118: values (ff_routes_s.currval,

2114: insert into ff_route_context_usages
2115: (route_id,
2116: context_id,
2117: sequence_no)
2118: values (ff_routes_s.currval,
2119: l_jurisdiction_context_id,
2120: 3);
2121:
2122: END;

Line 2151: from ff_routes where route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';

2147: and substr(con3.context,1,2) = substr(&B3,1,2)
2148: /* 3rd context of state jurisdiction_code*/';
2149:
2150: select route_id into l_route_id
2151: from ff_routes where route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';
2152:
2153: update ff_routes
2154: set text = l_text
2155: where route_id = l_route_id;

Line 2153: update ff_routes

2149:
2150: select route_id into l_route_id
2151: from ff_routes where route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';
2152:
2153: update ff_routes
2154: set text = l_text
2155: where route_id = l_route_id;
2156:
2157: EXCEPTION

Line 2160: insert into ff_routes

2156:
2157: EXCEPTION
2158: WHEN NO_DATA_FOUND THEN
2159:
2160: insert into ff_routes
2161: (route_id,
2162: route_name,
2163: user_defined_flag,
2164: description,

Line 2171: values (ff_routes_s.nextval,

2167: last_updated_by,
2168: last_update_login,
2169: created_by,
2170: creation_date)
2171: values (ff_routes_s.nextval,
2172: 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE',
2173: 'N',
2174: 'sql to retrieve Assignment,GRE and state JD based archived items',
2175: l_text,

Line 2190: ff_routes_s.currval,

2186: DATA_TYPE,
2187: PARAMETER_NAME,
2188: SEQUENCE_NO )
2189: values (ff_route_parameters_s.nextval,
2190: ff_routes_s.currval,
2191: 'N',
2192: 'User Entity ID',
2193: 1);
2194:

Line 2201: values (ff_routes_s.currval,

2197: insert into ff_route_context_usages
2198: (route_id,
2199: context_id,
2200: sequence_no)
2201: values (ff_routes_s.currval,
2202: l_assignment_action_context_id,
2203: 1);
2204:
2205: insert into ff_route_context_usages

Line 2209: values (ff_routes_s.currval,

2205: insert into ff_route_context_usages
2206: (route_id,
2207: context_id,
2208: sequence_no)
2209: values (ff_routes_s.currval,
2210: l_tax_unit_context_id,
2211: 2);
2212:
2213: insert into ff_route_context_usages

Line 2217: values (ff_routes_s.currval,

2213: insert into ff_route_context_usages
2214: (route_id,
2215: context_id,
2216: sequence_no)
2217: values (ff_routes_s.currval,
2218: l_jurisdiction_context_id,
2219: 3);
2220:
2221: END;

Line 2250: from ff_routes where route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';

2246: and substr(con3.context,1,8) = substr(&B3,1,8)
2247: /* 3rd context of scholl jurisdiction_code*/';
2248:
2249: select route_id into l_route_id
2250: from ff_routes where route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';
2251:
2252: update ff_routes
2253: set text = l_text
2254: where route_id = l_route_id;

Line 2252: update ff_routes

2248:
2249: select route_id into l_route_id
2250: from ff_routes where route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';
2251:
2252: update ff_routes
2253: set text = l_text
2254: where route_id = l_route_id;
2255:
2256: EXCEPTION

Line 2259: insert into ff_routes

2255:
2256: EXCEPTION
2257: WHEN NO_DATA_FOUND THEN
2258:
2259: insert into ff_routes
2260: (route_id,
2261: route_name,
2262: user_defined_flag,
2263: description,

Line 2270: values (ff_routes_s.nextval,

2266: last_updated_by,
2267: last_update_login,
2268: created_by,
2269: creation_date)
2270: values (ff_routes_s.nextval,
2271: 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE',
2272: 'N',
2273: 'sql to retrieve Assignment,GRE and school JD based archived items',
2274: l_text,

Line 2289: ff_routes_s.currval,

2285: DATA_TYPE,
2286: PARAMETER_NAME,
2287: SEQUENCE_NO )
2288: values (ff_route_parameters_s.nextval,
2289: ff_routes_s.currval,
2290: 'N',
2291: 'User Entity ID',
2292: 1);
2293:

Line 2300: values (ff_routes_s.currval,

2296: insert into ff_route_context_usages
2297: (route_id,
2298: context_id,
2299: sequence_no)
2300: values (ff_routes_s.currval,
2301: l_assignment_action_context_id,
2302: 1);
2303:
2304: insert into ff_route_context_usages

Line 2308: values (ff_routes_s.currval,

2304: insert into ff_route_context_usages
2305: (route_id,
2306: context_id,
2307: sequence_no)
2308: values (ff_routes_s.currval,
2309: l_tax_unit_context_id,
2310: 2);
2311:
2312: insert into ff_route_context_usages

Line 2316: values (ff_routes_s.currval,

2312: insert into ff_route_context_usages
2313: (route_id,
2314: context_id,
2315: sequence_no)
2316: values (ff_routes_s.currval,
2317: l_jurisdiction_context_id,
2318: 3);
2319:
2320:

Line 2383: from ff_routes where

2379: from dual;
2380:
2381:
2382: select route_id into l_er_archive_route_id
2383: from ff_routes where
2384: route_name = 'EMPLOYER_ARCHIVE';
2385:
2386: select route_id into l_er_archive_date_route_id
2387: from ff_routes where

Line 2387: from ff_routes where

2383: from ff_routes where
2384: route_name = 'EMPLOYER_ARCHIVE';
2385:
2386: select route_id into l_er_archive_date_route_id
2387: from ff_routes where
2388: route_name = 'EMPLOYER_ARCHIVE_DATE';
2389:
2390: select route_id into l_er_archive_number_route_id
2391: from ff_routes where

Line 2391: from ff_routes where

2387: from ff_routes where
2388: route_name = 'EMPLOYER_ARCHIVE_DATE';
2389:
2390: select route_id into l_er_archive_number_route_id
2391: from ff_routes where
2392: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2393:
2394: select route_id into l_ass_archive_route_id
2395: from ff_routes where

Line 2395: from ff_routes where

2391: from ff_routes where
2392: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2393:
2394: select route_id into l_ass_archive_route_id
2395: from ff_routes where
2396: route_name = 'ASSIGNMENT_ARCHIVE';
2397:
2398: select route_id into l_ass_archive_date_route_id
2399: from ff_routes where

Line 2399: from ff_routes where

2395: from ff_routes where
2396: route_name = 'ASSIGNMENT_ARCHIVE';
2397:
2398: select route_id into l_ass_archive_date_route_id
2399: from ff_routes where
2400: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2401:
2402: select route_id into l_ass_archive_number_route_id
2403: from ff_routes where

Line 2403: from ff_routes where

2399: from ff_routes where
2400: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2401:
2402: select route_id into l_ass_archive_number_route_id
2403: from ff_routes where
2404: route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
2405:
2406: if l_dbi_data_type = 'N' then
2407: l_definition_text := 'fnd_number.canonical_to_number(target.value)';

Line 2602: from ff_routes where

2598:
2599: hr_utility.trace('getting route ids');
2600:
2601: select route_id into l_er_archive_route_id
2602: from ff_routes where
2603: route_name = 'EMPLOYER_ARCHIVE';
2604:
2605: select route_id into l_er_archive_date_route_id
2606: from ff_routes where

Line 2606: from ff_routes where

2602: from ff_routes where
2603: route_name = 'EMPLOYER_ARCHIVE';
2604:
2605: select route_id into l_er_archive_date_route_id
2606: from ff_routes where
2607: route_name = 'EMPLOYER_ARCHIVE_DATE';
2608:
2609: select route_id into l_er_archive_number_route_id
2610: from ff_routes where

Line 2610: from ff_routes where

2606: from ff_routes where
2607: route_name = 'EMPLOYER_ARCHIVE_DATE';
2608:
2609: select route_id into l_er_archive_number_route_id
2610: from ff_routes where
2611: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2612:
2613: select route_id into l_er_tax_unit_arch_rid
2614: from ff_routes where

Line 2614: from ff_routes where

2610: from ff_routes where
2611: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2612:
2613: select route_id into l_er_tax_unit_arch_rid
2614: from ff_routes where
2615: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
2616:
2617: select route_id into l_er_tax_unit_arch_date_rid
2618: from ff_routes where

Line 2618: from ff_routes where

2614: from ff_routes where
2615: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
2616:
2617: select route_id into l_er_tax_unit_arch_date_rid
2618: from ff_routes where
2619: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
2620:
2621: select route_id into l_er_tax_unit_arch_number_rid
2622: from ff_routes where

Line 2622: from ff_routes where

2618: from ff_routes where
2619: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
2620:
2621: select route_id into l_er_tax_unit_arch_number_rid
2622: from ff_routes where
2623: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';
2624:
2625: select route_id into l_er_jursd_arch_rid
2626: from ff_routes where

Line 2626: from ff_routes where

2622: from ff_routes where
2623: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';
2624:
2625: select route_id into l_er_jursd_arch_rid
2626: from ff_routes where
2627: route_name = 'EMPLOYER_JURSD_ARCHIVE';
2628:
2629: select route_id into l_er_jursd_arch_date_rid
2630: from ff_routes where

Line 2630: from ff_routes where

2626: from ff_routes where
2627: route_name = 'EMPLOYER_JURSD_ARCHIVE';
2628:
2629: select route_id into l_er_jursd_arch_date_rid
2630: from ff_routes where
2631: route_name = 'EMPLOYER_JURSD_ARCHIVE_DATE';
2632:
2633: select route_id into l_er_jursd_arch_number_rid
2634: from ff_routes where

Line 2634: from ff_routes where

2630: from ff_routes where
2631: route_name = 'EMPLOYER_JURSD_ARCHIVE_DATE';
2632:
2633: select route_id into l_er_jursd_arch_number_rid
2634: from ff_routes where
2635: route_name = 'EMPLOYER_JURSD_ARCHIVE_NUMBER';
2636:
2637: select route_id into l_ass_archive_route_id
2638: from ff_routes where

Line 2638: from ff_routes where

2634: from ff_routes where
2635: route_name = 'EMPLOYER_JURSD_ARCHIVE_NUMBER';
2636:
2637: select route_id into l_ass_archive_route_id
2638: from ff_routes where
2639: route_name = 'ASSIGNMENT_ARCHIVE';
2640:
2641: select route_id into l_ass_archive_date_route_id
2642: from ff_routes where

Line 2642: from ff_routes where

2638: from ff_routes where
2639: route_name = 'ASSIGNMENT_ARCHIVE';
2640:
2641: select route_id into l_ass_archive_date_route_id
2642: from ff_routes where
2643: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2644:
2645: select route_id into l_ass_archive_number_route_id
2646: from ff_routes where

Line 2646: from ff_routes where

2642: from ff_routes where
2643: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2644:
2645: select route_id into l_ass_archive_number_route_id
2646: from ff_routes where
2647: route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
2648:
2649: select route_id into l_ass_gre_archive_route_id
2650: from ff_routes where

Line 2650: from ff_routes where

2646: from ff_routes where
2647: route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
2648:
2649: select route_id into l_ass_gre_archive_route_id
2650: from ff_routes where
2651: route_name = 'ASSIGNMENT_GRE_ARCHIVE';
2652:
2653: select route_id into l_ass_jd_archive_route_id
2654: from ff_routes where

Line 2654: from ff_routes where

2650: from ff_routes where
2651: route_name = 'ASSIGNMENT_GRE_ARCHIVE';
2652:
2653: select route_id into l_ass_jd_archive_route_id
2654: from ff_routes where
2655: route_name = 'ASSIGNMENT_JD_ARCHIVE';
2656:
2657: /*
2658: select route_id into l_ass_gre_jd_archive_route_id

Line 2659: from ff_routes where

2655: route_name = 'ASSIGNMENT_JD_ARCHIVE';
2656:
2657: /*
2658: select route_id into l_ass_gre_jd_archive_route_id
2659: from ff_routes where
2660: route_name = 'ASSIGNMENT_GRE_JD_ARCHIVE';
2661: */
2662: select route_id into l_ass_gre_ct_jd_arch_route_id
2663: from ff_routes where

Line 2663: from ff_routes where

2659: from ff_routes where
2660: route_name = 'ASSIGNMENT_GRE_JD_ARCHIVE';
2661: */
2662: select route_id into l_ass_gre_ct_jd_arch_route_id
2663: from ff_routes where
2664: route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';
2665:
2666: select route_id into l_ass_gre_cn_jd_arch_route_id
2667: from ff_routes where

Line 2667: from ff_routes where

2663: from ff_routes where
2664: route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';
2665:
2666: select route_id into l_ass_gre_cn_jd_arch_route_id
2667: from ff_routes where
2668: route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';
2669:
2670: select route_id into l_ass_gre_st_jd_arch_route_id
2671: from ff_routes where

Line 2671: from ff_routes where

2667: from ff_routes where
2668: route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';
2669:
2670: select route_id into l_ass_gre_st_jd_arch_route_id
2671: from ff_routes where
2672: route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';
2673:
2674: select route_id into l_ass_gre_sd_jd_arch_route_id
2675: from ff_routes where

Line 2675: from ff_routes where

2671: from ff_routes where
2672: route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';
2673:
2674: select route_id into l_ass_gre_sd_jd_arch_route_id
2675: from ff_routes where
2676: route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';
2677:
2678: hr_utility.trace('got route');
2679: