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.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 1953: from ff_routes where route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';

1949: and length(con3.context) = 11 -- Added for bug 11712075
1950: /* 3rd context of city jurisdiction_code*/';
1951:
1952: select route_id into l_route_id
1953: from ff_routes where route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';
1954:
1955: update ff_routes
1956: set text = l_text
1957: where route_id = l_route_id;

Line 1955: update ff_routes

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

Line 1962: insert into ff_routes

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

Line 1973: values (ff_routes_s.nextval,

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

Line 1992: ff_routes_s.currval,

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

Line 2003: values (ff_routes_s.currval,

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

Line 2011: values (ff_routes_s.currval,

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

Line 2019: values (ff_routes_s.currval,

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

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

2050: and length(con3.context) = 11 -- Added for bug 11712075
2051: /* 3rd context of county jurisdiction_code*/';
2052:
2053: select route_id into l_route_id
2054: from ff_routes where route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';
2055:
2056: update ff_routes
2057: set text = l_text
2058: where route_id = l_route_id;

Line 2056: update ff_routes

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

Line 2063: insert into ff_routes

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

Line 2074: values (ff_routes_s.nextval,

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

Line 2093: ff_routes_s.currval,

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

Line 2104: values (ff_routes_s.currval,

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

Line 2112: values (ff_routes_s.currval,

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

Line 2120: values (ff_routes_s.currval,

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

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

2150: and length(con3.context) = 11 -- Added for bug 11712075
2151: /* 3rd context of state jurisdiction_code*/';
2152:
2153: select route_id into l_route_id
2154: from ff_routes where route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';
2155:
2156: update ff_routes
2157: set text = l_text
2158: where route_id = l_route_id;

Line 2156: update ff_routes

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

Line 2163: insert into ff_routes

2159:
2160: EXCEPTION
2161: WHEN NO_DATA_FOUND THEN
2162:
2163: insert into ff_routes
2164: (route_id,
2165: route_name,
2166: user_defined_flag,
2167: description,

Line 2174: values (ff_routes_s.nextval,

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

Line 2193: ff_routes_s.currval,

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

Line 2204: values (ff_routes_s.currval,

2200: insert into ff_route_context_usages
2201: (route_id,
2202: context_id,
2203: sequence_no)
2204: values (ff_routes_s.currval,
2205: l_assignment_action_context_id,
2206: 1);
2207:
2208: insert into ff_route_context_usages

Line 2212: values (ff_routes_s.currval,

2208: insert into ff_route_context_usages
2209: (route_id,
2210: context_id,
2211: sequence_no)
2212: values (ff_routes_s.currval,
2213: l_tax_unit_context_id,
2214: 2);
2215:
2216: insert into ff_route_context_usages

Line 2220: values (ff_routes_s.currval,

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

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

2250: and length(con3.context) = 8 -- Added for bug 11712075
2251: /* 3rd context of scholl jurisdiction_code*/';
2252:
2253: select route_id into l_route_id
2254: from ff_routes where route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';
2255:
2256: update ff_routes
2257: set text = l_text
2258: where route_id = l_route_id;

Line 2256: update ff_routes

2252:
2253: select route_id into l_route_id
2254: from ff_routes where route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';
2255:
2256: update ff_routes
2257: set text = l_text
2258: where route_id = l_route_id;
2259:
2260: EXCEPTION

Line 2263: insert into ff_routes

2259:
2260: EXCEPTION
2261: WHEN NO_DATA_FOUND THEN
2262:
2263: insert into ff_routes
2264: (route_id,
2265: route_name,
2266: user_defined_flag,
2267: description,

Line 2274: values (ff_routes_s.nextval,

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

Line 2293: ff_routes_s.currval,

2289: DATA_TYPE,
2290: PARAMETER_NAME,
2291: SEQUENCE_NO )
2292: values (ff_route_parameters_s.nextval,
2293: ff_routes_s.currval,
2294: 'N',
2295: 'User Entity ID',
2296: 1);
2297:

Line 2304: values (ff_routes_s.currval,

2300: insert into ff_route_context_usages
2301: (route_id,
2302: context_id,
2303: sequence_no)
2304: values (ff_routes_s.currval,
2305: l_assignment_action_context_id,
2306: 1);
2307:
2308: insert into ff_route_context_usages

Line 2312: values (ff_routes_s.currval,

2308: insert into ff_route_context_usages
2309: (route_id,
2310: context_id,
2311: sequence_no)
2312: values (ff_routes_s.currval,
2313: l_tax_unit_context_id,
2314: 2);
2315:
2316: insert into ff_route_context_usages

Line 2320: values (ff_routes_s.currval,

2316: insert into ff_route_context_usages
2317: (route_id,
2318: context_id,
2319: sequence_no)
2320: values (ff_routes_s.currval,
2321: l_jurisdiction_context_id,
2322: 3);
2323:
2324:

Line 2357: from ff_routes where route_name = 'ASSIGNMENT_GRE_PSD_JD_ARCHIVE';

2353: and length(con3.context) = 16
2354: /* 3rd context of scholl jurisdiction_code*/';
2355:
2356: select route_id into l_route_id
2357: from ff_routes where route_name = 'ASSIGNMENT_GRE_PSD_JD_ARCHIVE';
2358:
2359: update ff_routes
2360: set text = l_text
2361: where route_id = l_route_id;

Line 2359: update ff_routes

2355:
2356: select route_id into l_route_id
2357: from ff_routes where route_name = 'ASSIGNMENT_GRE_PSD_JD_ARCHIVE';
2358:
2359: update ff_routes
2360: set text = l_text
2361: where route_id = l_route_id;
2362:
2363: EXCEPTION

Line 2366: insert into ff_routes

2362:
2363: EXCEPTION
2364: WHEN NO_DATA_FOUND THEN
2365:
2366: insert into ff_routes
2367: (route_id,
2368: route_name,
2369: user_defined_flag,
2370: description,

Line 2377: values (ff_routes_s.nextval,

2373: last_updated_by,
2374: last_update_login,
2375: created_by,
2376: creation_date)
2377: values (ff_routes_s.nextval,
2378: 'ASSIGNMENT_GRE_PSD_JD_ARCHIVE',
2379: 'N',
2380: 'sql to retrieve Assignment,GRE and PSD JD based archived items',
2381: l_text,

Line 2396: ff_routes_s.currval,

2392: DATA_TYPE,
2393: PARAMETER_NAME,
2394: SEQUENCE_NO )
2395: values (ff_route_parameters_s.nextval,
2396: ff_routes_s.currval,
2397: 'N',
2398: 'User Entity ID',
2399: 1);
2400:

Line 2407: values (ff_routes_s.currval,

2403: insert into ff_route_context_usages
2404: (route_id,
2405: context_id,
2406: sequence_no)
2407: values (ff_routes_s.currval,
2408: l_assignment_action_context_id,
2409: 1);
2410:
2411: insert into ff_route_context_usages

Line 2415: values (ff_routes_s.currval,

2411: insert into ff_route_context_usages
2412: (route_id,
2413: context_id,
2414: sequence_no)
2415: values (ff_routes_s.currval,
2416: l_tax_unit_context_id,
2417: 2);
2418:
2419: insert into ff_route_context_usages

Line 2423: values (ff_routes_s.currval,

2419: insert into ff_route_context_usages
2420: (route_id,
2421: context_id,
2422: sequence_no)
2423: values (ff_routes_s.currval,
2424: l_jurisdiction_context_id,
2425: 3);
2426:
2427:

Line 2492: from ff_routes where

2488: from dual;
2489:
2490:
2491: select route_id into l_er_archive_route_id
2492: from ff_routes where
2493: route_name = 'EMPLOYER_ARCHIVE';
2494:
2495: select route_id into l_er_archive_date_route_id
2496: from ff_routes where

Line 2496: from ff_routes where

2492: from ff_routes where
2493: route_name = 'EMPLOYER_ARCHIVE';
2494:
2495: select route_id into l_er_archive_date_route_id
2496: from ff_routes where
2497: route_name = 'EMPLOYER_ARCHIVE_DATE';
2498:
2499: select route_id into l_er_archive_number_route_id
2500: from ff_routes where

Line 2500: from ff_routes where

2496: from ff_routes where
2497: route_name = 'EMPLOYER_ARCHIVE_DATE';
2498:
2499: select route_id into l_er_archive_number_route_id
2500: from ff_routes where
2501: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2502:
2503: select route_id into l_ass_archive_route_id
2504: from ff_routes where

Line 2504: from ff_routes where

2500: from ff_routes where
2501: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2502:
2503: select route_id into l_ass_archive_route_id
2504: from ff_routes where
2505: route_name = 'ASSIGNMENT_ARCHIVE';
2506:
2507: select route_id into l_ass_archive_date_route_id
2508: from ff_routes where

Line 2508: from ff_routes where

2504: from ff_routes where
2505: route_name = 'ASSIGNMENT_ARCHIVE';
2506:
2507: select route_id into l_ass_archive_date_route_id
2508: from ff_routes where
2509: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2510:
2511: select route_id into l_ass_archive_number_route_id
2512: from ff_routes where

Line 2512: from ff_routes where

2508: from ff_routes where
2509: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2510:
2511: select route_id into l_ass_archive_number_route_id
2512: from ff_routes where
2513: route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
2514:
2515: if l_dbi_data_type = 'N' then
2516: l_definition_text := 'fnd_number.canonical_to_number(target.value)';

Line 2712: from ff_routes where

2708:
2709: hr_utility.trace('getting route ids');
2710:
2711: select route_id into l_er_archive_route_id
2712: from ff_routes where
2713: route_name = 'EMPLOYER_ARCHIVE';
2714:
2715: select route_id into l_er_archive_date_route_id
2716: from ff_routes where

Line 2716: from ff_routes where

2712: from ff_routes where
2713: route_name = 'EMPLOYER_ARCHIVE';
2714:
2715: select route_id into l_er_archive_date_route_id
2716: from ff_routes where
2717: route_name = 'EMPLOYER_ARCHIVE_DATE';
2718:
2719: select route_id into l_er_archive_number_route_id
2720: from ff_routes where

Line 2720: from ff_routes where

2716: from ff_routes where
2717: route_name = 'EMPLOYER_ARCHIVE_DATE';
2718:
2719: select route_id into l_er_archive_number_route_id
2720: from ff_routes where
2721: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2722:
2723: select route_id into l_er_tax_unit_arch_rid
2724: from ff_routes where

Line 2724: from ff_routes where

2720: from ff_routes where
2721: route_name = 'EMPLOYER_ARCHIVE_NUMBER';
2722:
2723: select route_id into l_er_tax_unit_arch_rid
2724: from ff_routes where
2725: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
2726:
2727: select route_id into l_er_tax_unit_arch_date_rid
2728: from ff_routes where

Line 2728: from ff_routes where

2724: from ff_routes where
2725: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE';
2726:
2727: select route_id into l_er_tax_unit_arch_date_rid
2728: from ff_routes where
2729: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
2730:
2731: select route_id into l_er_tax_unit_arch_number_rid
2732: from ff_routes where

Line 2732: from ff_routes where

2728: from ff_routes where
2729: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE';
2730:
2731: select route_id into l_er_tax_unit_arch_number_rid
2732: from ff_routes where
2733: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';
2734:
2735: select route_id into l_er_jursd_arch_rid
2736: from ff_routes where

Line 2736: from ff_routes where

2732: from ff_routes where
2733: route_name = 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER';
2734:
2735: select route_id into l_er_jursd_arch_rid
2736: from ff_routes where
2737: route_name = 'EMPLOYER_JURSD_ARCHIVE';
2738:
2739: select route_id into l_er_jursd_arch_date_rid
2740: from ff_routes where

Line 2740: from ff_routes where

2736: from ff_routes where
2737: route_name = 'EMPLOYER_JURSD_ARCHIVE';
2738:
2739: select route_id into l_er_jursd_arch_date_rid
2740: from ff_routes where
2741: route_name = 'EMPLOYER_JURSD_ARCHIVE_DATE';
2742:
2743: select route_id into l_er_jursd_arch_number_rid
2744: from ff_routes where

Line 2744: from ff_routes where

2740: from ff_routes where
2741: route_name = 'EMPLOYER_JURSD_ARCHIVE_DATE';
2742:
2743: select route_id into l_er_jursd_arch_number_rid
2744: from ff_routes where
2745: route_name = 'EMPLOYER_JURSD_ARCHIVE_NUMBER';
2746:
2747: select route_id into l_ass_archive_route_id
2748: from ff_routes where

Line 2748: from ff_routes where

2744: from ff_routes where
2745: route_name = 'EMPLOYER_JURSD_ARCHIVE_NUMBER';
2746:
2747: select route_id into l_ass_archive_route_id
2748: from ff_routes where
2749: route_name = 'ASSIGNMENT_ARCHIVE';
2750:
2751: select route_id into l_ass_archive_date_route_id
2752: from ff_routes where

Line 2752: from ff_routes where

2748: from ff_routes where
2749: route_name = 'ASSIGNMENT_ARCHIVE';
2750:
2751: select route_id into l_ass_archive_date_route_id
2752: from ff_routes where
2753: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2754:
2755: select route_id into l_ass_archive_number_route_id
2756: from ff_routes where

Line 2756: from ff_routes where

2752: from ff_routes where
2753: route_name = 'ASSIGNMENT_ARCHIVE_DATE';
2754:
2755: select route_id into l_ass_archive_number_route_id
2756: from ff_routes where
2757: route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
2758:
2759: select route_id into l_ass_gre_archive_route_id
2760: from ff_routes where

Line 2760: from ff_routes where

2756: from ff_routes where
2757: route_name = 'ASSIGNMENT_ARCHIVE_NUMBER';
2758:
2759: select route_id into l_ass_gre_archive_route_id
2760: from ff_routes where
2761: route_name = 'ASSIGNMENT_GRE_ARCHIVE';
2762:
2763: select route_id into l_ass_jd_archive_route_id
2764: from ff_routes where

Line 2764: from ff_routes where

2760: from ff_routes where
2761: route_name = 'ASSIGNMENT_GRE_ARCHIVE';
2762:
2763: select route_id into l_ass_jd_archive_route_id
2764: from ff_routes where
2765: route_name = 'ASSIGNMENT_JD_ARCHIVE';
2766:
2767: /*
2768: select route_id into l_ass_gre_jd_archive_route_id

Line 2769: from ff_routes where

2765: route_name = 'ASSIGNMENT_JD_ARCHIVE';
2766:
2767: /*
2768: select route_id into l_ass_gre_jd_archive_route_id
2769: from ff_routes where
2770: route_name = 'ASSIGNMENT_GRE_JD_ARCHIVE';
2771: */
2772: select route_id into l_ass_gre_ct_jd_arch_route_id
2773: from ff_routes where

Line 2773: from ff_routes where

2769: from ff_routes where
2770: route_name = 'ASSIGNMENT_GRE_JD_ARCHIVE';
2771: */
2772: select route_id into l_ass_gre_ct_jd_arch_route_id
2773: from ff_routes where
2774: route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';
2775:
2776: select route_id into l_ass_gre_cn_jd_arch_route_id
2777: from ff_routes where

Line 2777: from ff_routes where

2773: from ff_routes where
2774: route_name = 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE';
2775:
2776: select route_id into l_ass_gre_cn_jd_arch_route_id
2777: from ff_routes where
2778: route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';
2779:
2780: select route_id into l_ass_gre_st_jd_arch_route_id
2781: from ff_routes where

Line 2781: from ff_routes where

2777: from ff_routes where
2778: route_name = 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE';
2779:
2780: select route_id into l_ass_gre_st_jd_arch_route_id
2781: from ff_routes where
2782: route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';
2783:
2784: select route_id into l_ass_gre_sd_jd_arch_route_id
2785: from ff_routes where

Line 2785: from ff_routes where

2781: from ff_routes where
2782: route_name = 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE';
2783:
2784: select route_id into l_ass_gre_sd_jd_arch_route_id
2785: from ff_routes where
2786: route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';
2787:
2788: /* Changes for bug 11712075 - Start*/
2789: select route_id into l_ass_gre_psd_jd_arch_route_id

Line 2790: from ff_routes where

2786: route_name = 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE';
2787:
2788: /* Changes for bug 11712075 - Start*/
2789: select route_id into l_ass_gre_psd_jd_arch_route_id
2790: from ff_routes where
2791: route_name = 'ASSIGNMENT_GRE_PSD_JD_ARCHIVE';
2792: /* Changes for bug 11712075 - End*/
2793:
2794: hr_utility.trace('got route');