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.QA_QLTRSLTR_XMLP_PKG dependencies on QLTSTORB

Line 1793: QLTSTORB.MAKE_REC_GROUP;

1789: FETCH PCURSOR
1790: INTO V_PLAN_ID,V_TITLE,V_DESCRIPTION;
1791: CLOSE PCURSOR;
1792: V_CRITERIA_ID := X_CRITERIA_ID;
1793: QLTSTORB.MAKE_REC_GROUP;
1794: LOOP_THROUGH_RECORDS;
1795: LAUNCH_PRODUCT(V_PLAN_ID);
1796: IF (P_SECURITY_PROFILE = 1) THEN
1797: SELECT

Line 1852: ROW_COUNT := QLTSTORB.ROWS_IN_REC_GROUP;

1848: V_FXN_PROMPT VARCHAR2(10);
1849: V_GROUP_FLAG BOOLEAN := FALSE;
1850: TOTAL_ROWS_IN_REPORT NUMBER := 30;
1851: BEGIN
1852: ROW_COUNT := QLTSTORB.ROWS_IN_REC_GROUP;
1853: QLTSTORB.MAKE_FROM_REC_GRP;
1854: QLTSTORB.MAKE_WHERE_REC_GRP;
1855: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('QA_RESULTS QR');
1856: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('qr.plan_id = ''' || TO_CHAR(X_PLAN_ID) || '''');

Line 1853: QLTSTORB.MAKE_FROM_REC_GRP;

1849: V_GROUP_FLAG BOOLEAN := FALSE;
1850: TOTAL_ROWS_IN_REPORT NUMBER := 30;
1851: BEGIN
1852: ROW_COUNT := QLTSTORB.ROWS_IN_REC_GROUP;
1853: QLTSTORB.MAKE_FROM_REC_GRP;
1854: QLTSTORB.MAKE_WHERE_REC_GRP;
1855: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('QA_RESULTS QR');
1856: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('qr.plan_id = ''' || TO_CHAR(X_PLAN_ID) || '''');
1857: FOR i IN 1 .. ROW_COUNT LOOP

Line 1854: QLTSTORB.MAKE_WHERE_REC_GRP;

1850: TOTAL_ROWS_IN_REPORT NUMBER := 30;
1851: BEGIN
1852: ROW_COUNT := QLTSTORB.ROWS_IN_REC_GROUP;
1853: QLTSTORB.MAKE_FROM_REC_GRP;
1854: QLTSTORB.MAKE_WHERE_REC_GRP;
1855: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('QA_RESULTS QR');
1856: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('qr.plan_id = ''' || TO_CHAR(X_PLAN_ID) || '''');
1857: FOR i IN 1 .. ROW_COUNT LOOP
1858: IF QLTSTORB.GET_NUMBER('sel'

Line 1855: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('QA_RESULTS QR');

1851: BEGIN
1852: ROW_COUNT := QLTSTORB.ROWS_IN_REC_GROUP;
1853: QLTSTORB.MAKE_FROM_REC_GRP;
1854: QLTSTORB.MAKE_WHERE_REC_GRP;
1855: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('QA_RESULTS QR');
1856: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('qr.plan_id = ''' || TO_CHAR(X_PLAN_ID) || '''');
1857: FOR i IN 1 .. ROW_COUNT LOOP
1858: IF QLTSTORB.GET_NUMBER('sel'
1859: ,I) = 1 THEN

Line 1856: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('qr.plan_id = ''' || TO_CHAR(X_PLAN_ID) || '''');

1852: ROW_COUNT := QLTSTORB.ROWS_IN_REC_GROUP;
1853: QLTSTORB.MAKE_FROM_REC_GRP;
1854: QLTSTORB.MAKE_WHERE_REC_GRP;
1855: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('QA_RESULTS QR');
1856: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('qr.plan_id = ''' || TO_CHAR(X_PLAN_ID) || '''');
1857: FOR i IN 1 .. ROW_COUNT LOOP
1858: IF QLTSTORB.GET_NUMBER('sel'
1859: ,I) = 1 THEN
1860: Y_NAME := FKEY_RESOLVER(I);

Line 1858: IF QLTSTORB.GET_NUMBER('sel'

1854: QLTSTORB.MAKE_WHERE_REC_GRP;
1855: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('QA_RESULTS QR');
1856: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('qr.plan_id = ''' || TO_CHAR(X_PLAN_ID) || '''');
1857: FOR i IN 1 .. ROW_COUNT LOOP
1858: IF QLTSTORB.GET_NUMBER('sel'
1859: ,I) = 1 THEN
1860: Y_NAME := FKEY_RESOLVER(I);
1861: V_NAME := ADD_FXN_RPT(I
1862: ,Y_NAME);

Line 1864: IF QLTSTORB.GET_NUMBER('datatype'

1860: Y_NAME := FKEY_RESOLVER(I);
1861: V_NAME := ADD_FXN_RPT(I
1862: ,Y_NAME);
1863: V_SELECT := V_SELECT || ', ' || V_NAME || ' col_' || TO_CHAR(V_COUNTER);
1864: IF QLTSTORB.GET_NUMBER('datatype'
1865: ,I) = 2 THEN
1866: IF QLTSTORB.GET_CHAR('hardcoded_column'
1867: ,I) IS NULL THEN
1868: Y_NAME := 'to_number(' || Y_NAME || ')';

Line 1866: IF QLTSTORB.GET_CHAR('hardcoded_column'

1862: ,Y_NAME);
1863: V_SELECT := V_SELECT || ', ' || V_NAME || ' col_' || TO_CHAR(V_COUNTER);
1864: IF QLTSTORB.GET_NUMBER('datatype'
1865: ,I) = 2 THEN
1866: IF QLTSTORB.GET_CHAR('hardcoded_column'
1867: ,I) IS NULL THEN
1868: Y_NAME := 'to_number(' || Y_NAME || ')';
1869: END IF;
1870: Y_NAME := ADD_FXN(I

Line 1872: IF QLTSTORB.GET_NUMBER('function'

1868: Y_NAME := 'to_number(' || Y_NAME || ')';
1869: END IF;
1870: Y_NAME := ADD_FXN(I
1871: ,Y_NAME);
1872: IF QLTSTORB.GET_NUMBER('function'
1873: ,I) = 3 THEN
1874: Y_NAME := 'ROUND(' || Y_NAME || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('precision'
1875: ,I) + 5) || ')';
1876: END IF;

Line 1874: Y_NAME := 'ROUND(' || Y_NAME || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('precision'

1870: Y_NAME := ADD_FXN(I
1871: ,Y_NAME);
1872: IF QLTSTORB.GET_NUMBER('function'
1873: ,I) = 3 THEN
1874: Y_NAME := 'ROUND(' || Y_NAME || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('precision'
1875: ,I) + 5) || ')';
1876: END IF;
1877: V_SELECT := V_SELECT || ', ' || Y_NAME || ' num_' || TO_CHAR(V_COUNTER);
1878: V_SELECT := V_SELECT || ', '|| 'QA_QLTRSLTR_XMLP_PKG.C_AST_'||TO_CHAR(V_COUNTER)||'FORMULA(' ||Y_NAME||','||V_NAME||')'||' C_AST_'||TO_CHAR(V_COUNTER) ;

Line 1885: V_PROMPT := QLTSTORB.GET_CHAR('prompt'

1881: V_SELECT := V_SELECT || ', '|| 'QA_QLTRSLTR_XMLP_PKG.C_AST_'||TO_CHAR(V_COUNTER)||'FORMULA(' ||999 ||','||V_NAME||')'||' C_AST_'||TO_CHAR(V_COUNTER) ;
1882:
1883: END IF;
1884: V_COUNTER := V_COUNTER + 1;
1885: V_PROMPT := QLTSTORB.GET_CHAR('prompt'
1886: ,I);
1887: V_FXN_PROMPT := QLTSTORB.GET_CHAR('fxn_prompt'
1888: ,I);
1889: IF V_FXN_PROMPT IS NOT NULL THEN

Line 1887: V_FXN_PROMPT := QLTSTORB.GET_CHAR('fxn_prompt'

1883: END IF;
1884: V_COUNTER := V_COUNTER + 1;
1885: V_PROMPT := QLTSTORB.GET_CHAR('prompt'
1886: ,I);
1887: V_FXN_PROMPT := QLTSTORB.GET_CHAR('fxn_prompt'
1888: ,I);
1889: IF V_FXN_PROMPT IS NOT NULL THEN
1890: V_PROMPT := V_PROMPT || '(' || V_FXN_PROMPT || ')';
1891: V_GROUP_FLAG := TRUE;

Line 1894: IF QLTSTORB.GET_NUMBER('datatype'

1890: V_PROMPT := V_PROMPT || '(' || V_FXN_PROMPT || ')';
1891: V_GROUP_FLAG := TRUE;
1892: ELSE
1893: V_GROUP_BY := V_GROUP_BY || ', ' || V_NAME;
1894: IF QLTSTORB.GET_NUMBER('datatype'
1895: ,I) = 2 THEN
1896: V_GROUP_BY := V_GROUP_BY || ', ' || Y_NAME;
1897: END IF;
1898: END IF;

Line 1903: IF QLTSTORB.GET_NUMBER('datatype'

1899: V_PROMPT := REPLACE(V_PROMPT
1900: ,''''
1901: ,'''''''''');
1902: V_PROMPT := '''' || V_PROMPT || '''';
1903: IF QLTSTORB.GET_NUMBER('datatype'
1904: ,I) = 2 THEN
1905: V_PROMPT := 'lpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'
1906: ,I)) || ')';
1907: ELSE

Line 1905: V_PROMPT := 'lpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'

1901: ,'''''''''');
1902: V_PROMPT := '''' || V_PROMPT || '''';
1903: IF QLTSTORB.GET_NUMBER('datatype'
1904: ,I) = 2 THEN
1905: V_PROMPT := 'lpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'
1906: ,I)) || ')';
1907: ELSE
1908: V_PROMPT := 'rpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'
1909: ,I)) || ')';

Line 1908: V_PROMPT := 'rpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'

1904: ,I) = 2 THEN
1905: V_PROMPT := 'lpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'
1906: ,I)) || ')';
1907: ELSE
1908: V_PROMPT := 'rpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'
1909: ,I)) || ')';
1910: END IF;
1911: V_PROMPTS := V_PROMPTS || ', ' || V_PROMPT;
1912: V_LENGTH := QLTSTORB.GET_NUMBER('disp_length'

Line 1912: V_LENGTH := QLTSTORB.GET_NUMBER('disp_length'

1908: V_PROMPT := 'rpad(' || V_PROMPT || ', ' || TO_CHAR(QLTSTORB.GET_NUMBER('disp_length'
1909: ,I)) || ')';
1910: END IF;
1911: V_PROMPTS := V_PROMPTS || ', ' || V_PROMPT;
1912: V_LENGTH := QLTSTORB.GET_NUMBER('disp_length'
1913: ,I);
1914: V_LENGTHS := V_LENGTHS || ', ' || TO_CHAR(V_LENGTH);
1915: V_SUM := QLTSTORB.GET_NUMBER('total',I);
1916:

Line 1915: V_SUM := QLTSTORB.GET_NUMBER('total',I);

1911: V_PROMPTS := V_PROMPTS || ', ' || V_PROMPT;
1912: V_LENGTH := QLTSTORB.GET_NUMBER('disp_length'
1913: ,I);
1914: V_LENGTHS := V_LENGTHS || ', ' || TO_CHAR(V_LENGTH);
1915: V_SUM := QLTSTORB.GET_NUMBER('total',I);
1916:
1917: IF V_SUM = 2 OR V_SUM IS NULL THEN
1918: V_SUMS := V_SUMS || ', null';
1919: ELSE

Line 1926: V_FROM := QLTSTORB.CREATE_FROM_CLAUSE;

1922: ELSE
1923: CREATE_WHERE(I);
1924: END IF;
1925: END LOOP;
1926: V_FROM := QLTSTORB.CREATE_FROM_CLAUSE;
1927: V_WHERE := QLTSTORB.CREATE_WHERE_CLAUSE;
1928: FOR i IN V_COUNTER .. TOTAL_ROWS_IN_REPORT LOOP
1929: V_SELECT := V_SELECT || ', null col_' || TO_CHAR(I) || ', 999 num_' || TO_CHAR(I);
1930: V_PROMPTS := V_PROMPTS || ', null';

Line 1927: V_WHERE := QLTSTORB.CREATE_WHERE_CLAUSE;

1923: CREATE_WHERE(I);
1924: END IF;
1925: END LOOP;
1926: V_FROM := QLTSTORB.CREATE_FROM_CLAUSE;
1927: V_WHERE := QLTSTORB.CREATE_WHERE_CLAUSE;
1928: FOR i IN V_COUNTER .. TOTAL_ROWS_IN_REPORT LOOP
1929: V_SELECT := V_SELECT || ', null col_' || TO_CHAR(I) || ', 999 num_' || TO_CHAR(I);
1930: V_PROMPTS := V_PROMPTS || ', null';
1931: V_LENGTHS := V_LENGTHS || ', null';

Line 1954: QLTSTORB.KILL_REC_GROUP;

1950: ,3);
1951: ELSE
1952: V_GROUP_BY := NULL;
1953: END IF;
1954: QLTSTORB.KILL_REC_GROUP;
1955: QA_QLTRSLTR_XMLP_PKG.V_SELECT := V_SELECT ||' '|| ' ' || V_FROM;
1956: QA_QLTRSLTR_XMLP_PKG.V_WHERE := V_WHERE || ' ' || V_ORDER_BY || ' ' || V_GROUP_BY;
1957: QA_QLTRSLTR_XMLP_PKG.V_PROMPTS := V_PROMPTS;
1958: QA_QLTRSLTR_XMLP_PKG.V_LENGTH := V_LENGTHS;

Line 1981: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'

1977: QA_IN_LISTS
1978: WHERE PARENT_BLOCK_NAME = V_PARENT_BLOCK_NAME
1979: AND LIST_ID = V_LIST_ID;
1980: BEGIN
1981: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'
1982: ,X_ROW);
1983: V_NAME := FKEY_RESOLVER(X_ROW);
1984: V_NAME := RESOLVE_TYPE(X_ROW
1985: ,V_NAME);

Line 1986: V_OPER := QLTSTORB.GET_CHAR('op'

1982: ,X_ROW);
1983: V_NAME := FKEY_RESOLVER(X_ROW);
1984: V_NAME := RESOLVE_TYPE(X_ROW
1985: ,V_NAME);
1986: V_OPER := QLTSTORB.GET_CHAR('op'
1987: ,X_ROW);
1988: V_LOW := QLTSTORB.GET_CHAR('low'
1989: ,X_ROW);
1990: V_HIGH := QLTSTORB.GET_CHAR('high'

Line 1988: V_LOW := QLTSTORB.GET_CHAR('low'

1984: V_NAME := RESOLVE_TYPE(X_ROW
1985: ,V_NAME);
1986: V_OPER := QLTSTORB.GET_CHAR('op'
1987: ,X_ROW);
1988: V_LOW := QLTSTORB.GET_CHAR('low'
1989: ,X_ROW);
1990: V_HIGH := QLTSTORB.GET_CHAR('high'
1991: ,X_ROW);
1992: IF ((V_OPER = 'IN') OR (V_OPER = 'NOT IN')) THEN

Line 1990: V_HIGH := QLTSTORB.GET_CHAR('high'

1986: V_OPER := QLTSTORB.GET_CHAR('op'
1987: ,X_ROW);
1988: V_LOW := QLTSTORB.GET_CHAR('low'
1989: ,X_ROW);
1990: V_HIGH := QLTSTORB.GET_CHAR('high'
1991: ,X_ROW);
1992: IF ((V_OPER = 'IN') OR (V_OPER = 'NOT IN')) THEN
1993: V_PARENT_BLOCK_NAME := QLTSTORB.GET_CHAR('parent_block_name'
1994: ,X_ROW);

Line 1993: V_PARENT_BLOCK_NAME := QLTSTORB.GET_CHAR('parent_block_name'

1989: ,X_ROW);
1990: V_HIGH := QLTSTORB.GET_CHAR('high'
1991: ,X_ROW);
1992: IF ((V_OPER = 'IN') OR (V_OPER = 'NOT IN')) THEN
1993: V_PARENT_BLOCK_NAME := QLTSTORB.GET_CHAR('parent_block_name'
1994: ,X_ROW);
1995: V_LIST_ID := QLTSTORB.GET_NUMBER('list_id'
1996: ,X_ROW);
1997: OPEN C;

Line 1995: V_LIST_ID := QLTSTORB.GET_NUMBER('list_id'

1991: ,X_ROW);
1992: IF ((V_OPER = 'IN') OR (V_OPER = 'NOT IN')) THEN
1993: V_PARENT_BLOCK_NAME := QLTSTORB.GET_CHAR('parent_block_name'
1994: ,X_ROW);
1995: V_LIST_ID := QLTSTORB.GET_NUMBER('list_id'
1996: ,X_ROW);
1997: OPEN C;
1998: WHILE (NOT DONE) LOOP
1999:

Line 2062: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(V_WHERE);

2058: V_WHERE := V_WHERE || ' AND ' || V_HIGH;
2059: END IF;
2060: END IF;
2061: END IF;
2062: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(V_WHERE);
2063: END CREATE_WHERE;
2064:
2065: FUNCTION FKEY_RESOLVER(X_ROW IN NUMBER) RETURN VARCHAR2 IS
2066: X_NAME VARCHAR2(100);

Line 2073: X_LOOKUP := QLTSTORB.GET_NUMBER('fk_lookup_type'

2069: V_FROM VARCHAR2(100);
2070: V_TABLE_SH_NAME VARCHAR2(5);
2071: V_CATEGORY_SET_ID NUMBER;
2072: BEGIN
2073: X_LOOKUP := QLTSTORB.GET_NUMBER('fk_lookup_type'
2074: ,X_ROW);
2075: X_NAME := QLTSTORB.GET_CHAR('hardcoded_column'
2076: ,X_ROW);
2077: IF X_NAME IS NULL THEN

Line 2075: X_NAME := QLTSTORB.GET_CHAR('hardcoded_column'

2071: V_CATEGORY_SET_ID NUMBER;
2072: BEGIN
2073: X_LOOKUP := QLTSTORB.GET_NUMBER('fk_lookup_type'
2074: ,X_ROW);
2075: X_NAME := QLTSTORB.GET_CHAR('hardcoded_column'
2076: ,X_ROW);
2077: IF X_NAME IS NULL THEN
2078: X_NAME := 'qr.' || QLTSTORB.GET_CHAR('result_column_name'
2079: ,X_ROW);

Line 2078: X_NAME := 'qr.' || QLTSTORB.GET_CHAR('result_column_name'

2074: ,X_ROW);
2075: X_NAME := QLTSTORB.GET_CHAR('hardcoded_column'
2076: ,X_ROW);
2077: IF X_NAME IS NULL THEN
2078: X_NAME := 'qr.' || QLTSTORB.GET_CHAR('result_column_name'
2079: ,X_ROW);
2080: ELSE
2081: X_NAME := 'qr.' || X_NAME;
2082: END IF;

Line 2084: V_TABLE_SH_NAME := QLTSTORB.GET_CHAR('fk_table_short_name'

2080: ELSE
2081: X_NAME := 'qr.' || X_NAME;
2082: END IF;
2083: IF (X_LOOKUP = 1) OR (X_LOOKUP = 3) OR (X_LOOKUP = 0) THEN
2084: V_TABLE_SH_NAME := QLTSTORB.GET_CHAR('fk_table_short_name'
2085: ,X_ROW);
2086: V_FROM := QLTSTORB.GET_CHAR('fk_table_name'
2087: ,X_ROW);
2088: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP(V_FROM || ' ' || V_TABLE_SH_NAME);

Line 2086: V_FROM := QLTSTORB.GET_CHAR('fk_table_name'

2082: END IF;
2083: IF (X_LOOKUP = 1) OR (X_LOOKUP = 3) OR (X_LOOKUP = 0) THEN
2084: V_TABLE_SH_NAME := QLTSTORB.GET_CHAR('fk_table_short_name'
2085: ,X_ROW);
2086: V_FROM := QLTSTORB.GET_CHAR('fk_table_name'
2087: ,X_ROW);
2088: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP(V_FROM || ' ' || V_TABLE_SH_NAME);
2089: V_FROM := QLTSTORB.GET_CHAR('pk_id'
2090: ,X_ROW);

Line 2088: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP(V_FROM || ' ' || V_TABLE_SH_NAME);

2084: V_TABLE_SH_NAME := QLTSTORB.GET_CHAR('fk_table_short_name'
2085: ,X_ROW);
2086: V_FROM := QLTSTORB.GET_CHAR('fk_table_name'
2087: ,X_ROW);
2088: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP(V_FROM || ' ' || V_TABLE_SH_NAME);
2089: V_FROM := QLTSTORB.GET_CHAR('pk_id'
2090: ,X_ROW);
2091: X_WHERE := X_NAME || ' = ' || V_TABLE_SH_NAME || '.' || V_FROM || ' (+)';
2092: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);

Line 2089: V_FROM := QLTSTORB.GET_CHAR('pk_id'

2085: ,X_ROW);
2086: V_FROM := QLTSTORB.GET_CHAR('fk_table_name'
2087: ,X_ROW);
2088: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP(V_FROM || ' ' || V_TABLE_SH_NAME);
2089: V_FROM := QLTSTORB.GET_CHAR('pk_id'
2090: ,X_ROW);
2091: X_WHERE := X_NAME || ' = ' || V_TABLE_SH_NAME || '.' || V_FROM || ' (+)';
2092: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2093: V_FROM := QLTSTORB.GET_CHAR('pk_id2'

Line 2092: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);

2088: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP(V_FROM || ' ' || V_TABLE_SH_NAME);
2089: V_FROM := QLTSTORB.GET_CHAR('pk_id'
2090: ,X_ROW);
2091: X_WHERE := X_NAME || ' = ' || V_TABLE_SH_NAME || '.' || V_FROM || ' (+)';
2092: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2093: V_FROM := QLTSTORB.GET_CHAR('pk_id2'
2094: ,X_ROW);
2095: IF V_FROM IS NOT NULL THEN
2096: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;

Line 2093: V_FROM := QLTSTORB.GET_CHAR('pk_id2'

2089: V_FROM := QLTSTORB.GET_CHAR('pk_id'
2090: ,X_ROW);
2091: X_WHERE := X_NAME || ' = ' || V_TABLE_SH_NAME || '.' || V_FROM || ' (+)';
2092: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2093: V_FROM := QLTSTORB.GET_CHAR('pk_id2'
2094: ,X_ROW);
2095: IF V_FROM IS NOT NULL THEN
2096: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;
2097: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id2'

Line 2097: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id2'

2093: V_FROM := QLTSTORB.GET_CHAR('pk_id2'
2094: ,X_ROW);
2095: IF V_FROM IS NOT NULL THEN
2096: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;
2097: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id2'
2098: ,X_ROW) || ' = ' || V_FROM || ' (+)';
2099: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2100: V_FROM := QLTSTORB.GET_CHAR('pk_id3'
2101: ,X_ROW);

Line 2099: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);

2095: IF V_FROM IS NOT NULL THEN
2096: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;
2097: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id2'
2098: ,X_ROW) || ' = ' || V_FROM || ' (+)';
2099: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2100: V_FROM := QLTSTORB.GET_CHAR('pk_id3'
2101: ,X_ROW);
2102: IF V_FROM IS NOT NULL THEN
2103: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;

Line 2100: V_FROM := QLTSTORB.GET_CHAR('pk_id3'

2096: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;
2097: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id2'
2098: ,X_ROW) || ' = ' || V_FROM || ' (+)';
2099: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2100: V_FROM := QLTSTORB.GET_CHAR('pk_id3'
2101: ,X_ROW);
2102: IF V_FROM IS NOT NULL THEN
2103: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;
2104: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id3'

Line 2104: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id3'

2100: V_FROM := QLTSTORB.GET_CHAR('pk_id3'
2101: ,X_ROW);
2102: IF V_FROM IS NOT NULL THEN
2103: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;
2104: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id3'
2105: ,X_ROW) || ' = ' || V_FROM || ' (+)';
2106: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2107: END IF;
2108: END IF;

Line 2106: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);

2102: IF V_FROM IS NOT NULL THEN
2103: V_FROM := V_TABLE_SH_NAME || '.' || V_FROM;
2104: X_WHERE := 'qr.' || QLTSTORB.GET_CHAR('fk_id3'
2105: ,X_ROW) || ' = ' || V_FROM || ' (+)';
2106: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2107: END IF;
2108: END IF;
2109: X_WHERE := QLTSTORB.GET_CHAR('fk_add_where'
2110: ,X_ROW);

Line 2109: X_WHERE := QLTSTORB.GET_CHAR('fk_add_where'

2105: ,X_ROW) || ' = ' || V_FROM || ' (+)';
2106: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2107: END IF;
2108: END IF;
2109: X_WHERE := QLTSTORB.GET_CHAR('fk_add_where'
2110: ,X_ROW);
2111: IF X_WHERE IS NOT NULL THEN
2112: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2113: END IF;

Line 2112: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);

2108: END IF;
2109: X_WHERE := QLTSTORB.GET_CHAR('fk_add_where'
2110: ,X_ROW);
2111: IF X_WHERE IS NOT NULL THEN
2112: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2113: END IF;
2114: X_NAME := QLTSTORB.GET_CHAR('fk_meaning'
2115: ,X_ROW);
2116: X_NAME := V_TABLE_SH_NAME || '.' || X_NAME;

Line 2114: X_NAME := QLTSTORB.GET_CHAR('fk_meaning'

2110: ,X_ROW);
2111: IF X_WHERE IS NOT NULL THEN
2112: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2113: END IF;
2114: X_NAME := QLTSTORB.GET_CHAR('fk_meaning'
2115: ,X_ROW);
2116: X_NAME := V_TABLE_SH_NAME || '.' || X_NAME;
2117: IF X_NAME = 'SH.ORDER_NUMBER' THEN
2118: X_NAME := 'NVL(MSO1.SEGMENT1,TO_CHAR(SH.ORDER_NUMBER))';

Line 2119: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('MTL_SALES_ORDERS MSO1');

2115: ,X_ROW);
2116: X_NAME := V_TABLE_SH_NAME || '.' || X_NAME;
2117: IF X_NAME = 'SH.ORDER_NUMBER' THEN
2118: X_NAME := 'NVL(MSO1.SEGMENT1,TO_CHAR(SH.ORDER_NUMBER))';
2119: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('MTL_SALES_ORDERS MSO1');
2120: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('QR.SO_HEADER_ID=MSO1.SALES_ORDER_ID(+)');
2121: END IF;
2122: END IF;
2123: IF (X_LOOKUP = 3) THEN

Line 2120: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('QR.SO_HEADER_ID=MSO1.SALES_ORDER_ID(+)');

2116: X_NAME := V_TABLE_SH_NAME || '.' || X_NAME;
2117: IF X_NAME = 'SH.ORDER_NUMBER' THEN
2118: X_NAME := 'NVL(MSO1.SEGMENT1,TO_CHAR(SH.ORDER_NUMBER))';
2119: QLTSTORB.ADD_ROW_TO_FROM_REC_GROUP('MTL_SALES_ORDERS MSO1');
2120: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP('QR.SO_HEADER_ID=MSO1.SALES_ORDER_ID(+)');
2121: END IF;
2122: END IF;
2123: IF (X_LOOKUP = 3) THEN
2124: V_CATEGORY_SET_ID := FND_PROFILE.VALUE('QA_CATEGORY_SET');

Line 2128: QLTSTORB.KILL_REC_GROUP;

2124: V_CATEGORY_SET_ID := FND_PROFILE.VALUE('QA_CATEGORY_SET');
2125: IF V_CATEGORY_SET_ID IS NULL THEN
2126: FND_MESSAGE.SET_NAME('QA'
2127: ,'QA_PROFILE_NOT_SET');
2128: QLTSTORB.KILL_REC_GROUP;
2129: QLTSTORB.KILL_FROM_REC_GRP;
2130: QLTSTORB.KILL_WHERE_REC_GRP;
2131: END IF;
2132: X_WHERE := 'micsv.CATEGORY_SET_ID = ' || TO_CHAR(V_CATEGORY_SET_ID);

Line 2129: QLTSTORB.KILL_FROM_REC_GRP;

2125: IF V_CATEGORY_SET_ID IS NULL THEN
2126: FND_MESSAGE.SET_NAME('QA'
2127: ,'QA_PROFILE_NOT_SET');
2128: QLTSTORB.KILL_REC_GROUP;
2129: QLTSTORB.KILL_FROM_REC_GRP;
2130: QLTSTORB.KILL_WHERE_REC_GRP;
2131: END IF;
2132: X_WHERE := 'micsv.CATEGORY_SET_ID = ' || TO_CHAR(V_CATEGORY_SET_ID);
2133: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);

Line 2130: QLTSTORB.KILL_WHERE_REC_GRP;

2126: FND_MESSAGE.SET_NAME('QA'
2127: ,'QA_PROFILE_NOT_SET');
2128: QLTSTORB.KILL_REC_GROUP;
2129: QLTSTORB.KILL_FROM_REC_GRP;
2130: QLTSTORB.KILL_WHERE_REC_GRP;
2131: END IF;
2132: X_WHERE := 'micsv.CATEGORY_SET_ID = ' || TO_CHAR(V_CATEGORY_SET_ID);
2133: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2134: END IF;

Line 2133: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);

2129: QLTSTORB.KILL_FROM_REC_GRP;
2130: QLTSTORB.KILL_WHERE_REC_GRP;
2131: END IF;
2132: X_WHERE := 'micsv.CATEGORY_SET_ID = ' || TO_CHAR(V_CATEGORY_SET_ID);
2133: QLTSTORB.ADD_ROW_TO_WHERE_REC_GROUP(X_WHERE);
2134: END IF;
2135: RETURN (X_NAME);
2136: END FKEY_RESOLVER;
2137:

Line 2144: V_HARDCODED := QLTSTORB.GET_CHAR('hardcoded_column'

2140: V_DATATYPE NUMBER;
2141: V_NAME VARCHAR2(100);
2142: V_HARDCODED VARCHAR2(100);
2143: BEGIN
2144: V_HARDCODED := QLTSTORB.GET_CHAR('hardcoded_column'
2145: ,X_ROW);
2146: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'
2147: ,X_ROW);
2148: IF V_HARDCODED IS NULL THEN

Line 2146: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'

2142: V_HARDCODED VARCHAR2(100);
2143: BEGIN
2144: V_HARDCODED := QLTSTORB.GET_CHAR('hardcoded_column'
2145: ,X_ROW);
2146: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'
2147: ,X_ROW);
2148: IF V_HARDCODED IS NULL THEN
2149: IF V_DATATYPE = 2 THEN
2150: V_NAME := 'qltdate.any_to_number(' || X_NAME || ')';

Line 2173: V_FUNCTION := QLTSTORB.GET_NUMBER('function'

2169: ,X_NAME IN VARCHAR2) RETURN VARCHAR2 IS
2170: V_FUNCTION NUMBER;
2171: V_NAME VARCHAR2(100);
2172: BEGIN
2173: V_FUNCTION := QLTSTORB.GET_NUMBER('function'
2174: ,X_ROW);
2175: IF V_FUNCTION = 1 THEN
2176: V_NAME := 'SUM(' || X_NAME || ')';
2177: ELSIF V_FUNCTION = 2 THEN

Line 2199: V_HARDCODED := QLTSTORB.GET_CHAR('hardcoded_column'

2195: V_FUNCTION NUMBER;
2196: V_DATATYPE NUMBER;
2197: V_DISP_LEN NUMBER;
2198: BEGIN
2199: V_HARDCODED := QLTSTORB.GET_CHAR('hardcoded_column'
2200: ,X_ROW);
2201: V_FUNCTION := QLTSTORB.GET_NUMBER('function'
2202: ,X_ROW);
2203: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'

Line 2201: V_FUNCTION := QLTSTORB.GET_NUMBER('function'

2197: V_DISP_LEN NUMBER;
2198: BEGIN
2199: V_HARDCODED := QLTSTORB.GET_CHAR('hardcoded_column'
2200: ,X_ROW);
2201: V_FUNCTION := QLTSTORB.GET_NUMBER('function'
2202: ,X_ROW);
2203: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'
2204: ,X_ROW);
2205: V_DISP_LEN := QLTSTORB.GET_NUMBER('disp_length'

Line 2203: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'

2199: V_HARDCODED := QLTSTORB.GET_CHAR('hardcoded_column'
2200: ,X_ROW);
2201: V_FUNCTION := QLTSTORB.GET_NUMBER('function'
2202: ,X_ROW);
2203: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'
2204: ,X_ROW);
2205: V_DISP_LEN := QLTSTORB.GET_NUMBER('disp_length'
2206: ,X_ROW);
2207: IF V_FUNCTION IS NULL THEN

Line 2205: V_DISP_LEN := QLTSTORB.GET_NUMBER('disp_length'

2201: V_FUNCTION := QLTSTORB.GET_NUMBER('function'
2202: ,X_ROW);
2203: V_DATATYPE := QLTSTORB.GET_NUMBER('datatype'
2204: ,X_ROW);
2205: V_DISP_LEN := QLTSTORB.GET_NUMBER('disp_length'
2206: ,X_ROW);
2207: IF V_FUNCTION IS NULL THEN
2208: IF V_DATATYPE = 2 THEN
2209: V_NAME := 'qltdate.number_canon_to_user(' || X_NAME || ')';

Line 2345: QLTSTORB.ADD_ROW_TO_REC_GROUP(PREC.CHAR_ID

2341: BEGIN
2342: FOR prec IN PCURSOR LOOP
2343: V_OPERATOR := DECODE_OPERATOR(PREC.OPERATOR
2344: ,PREC.DATATYPE);
2345: QLTSTORB.ADD_ROW_TO_REC_GROUP(PREC.CHAR_ID
2346: ,PREC.HARDCODED_COLUMN
2347: ,PREC.RESULT_COLUMN_NAME
2348: ,PREC.DATATYPE
2349: ,V_OPERATOR