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.JTF_TERRITORY_GET_PUB dependencies on DUAL

Line 181: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;

177:
178: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Rec_Type';
179:
180: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
181: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
182: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
183:
184: /* return values from cursors */
185: str_csr1 NUMBER;

Line 182: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;

178: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Rec_Type';
179:
180: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
181: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
182: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
183:
184: /* return values from cursors */
185: str_csr1 NUMBER;
186: str_csr2 NUMBER;

Line 688: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;

684:
685: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Usgs';
686:
687: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
688: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
689: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
690:
691: /* return values from cursors */
692: str_csr1 NUMBER;

Line 689: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;

685: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Usgs';
686:
687: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
688: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
689: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
690:
691: /* return values from cursors */
692: str_csr1 NUMBER;
693: str_csr2 NUMBER;

Line 851: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;

847:
848: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Type';
849:
850: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
851: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
852: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
853:
854: /* return values from cursors */
855: str_csr1 NUMBER;

Line 852: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;

848: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Type';
849:
850: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
851: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
852: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
853:
854: /* return values from cursors */
855: str_csr1 NUMBER;
856: str_csr2 NUMBER;

Line 1099: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;

1095:
1096: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_QType_Usgs';
1097:
1098: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
1099: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
1100: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
1101:
1102: /* return values from cursors */
1103: str_csr1 NUMBER;

Line 1100: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;

1096: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_QType_Usgs';
1097:
1098: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
1099: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
1100: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
1101:
1102: /* return values from cursors */
1103: str_csr1 NUMBER;
1104: str_csr2 NUMBER;

Line 1333: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;

1329:
1330: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Qual';
1331:
1332: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
1333: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
1334: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
1335:
1336: /* return values from cursors */
1337: str_csr1 NUMBER;

Line 1334: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;

1330: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Qual';
1331:
1332: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
1333: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
1334: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
1335:
1336: /* return values from cursors */
1337: str_csr1 NUMBER;
1338: str_csr2 NUMBER;

Line 1747: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;

1743:
1744: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Values';
1745:
1746: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
1747: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
1748: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
1749:
1750: /* return values from cursors */
1751: str_csr1 NUMBER;

Line 1748: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;

1744: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Values';
1745:
1746: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
1747: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
1748: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
1749:
1750: /* return values from cursors */
1751: str_csr1 NUMBER;
1752: str_csr2 NUMBER;

Line 2132: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;

2128:
2129: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Rsc';
2130:
2131: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
2132: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
2133: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
2134:
2135: /* return values from cursors */
2136: str_csr1 NUMBER;

Line 2133: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;

2129: l_proc_name VARCHAR2(30) := 'Gen_Where: Terr_Rsc';
2130:
2131: /* cursors to check if wildcard values '%' and '_' have been passed as item values */
2132: CURSOR c_chk_str1 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '%', 1, 1) FROM DUAL;
2133: CURSOR c_chk_str2 (p_rec_item VARCHAR2) IS SELECT INSTR(p_rec_item, '_', 1, 1) FROM DUAL;
2134:
2135: /* return values from cursors */
2136: str_csr1 NUMBER;
2137: str_csr2 NUMBER;