DBA Data[Home] [Help]

APPS.QA_QLTRSLTR_XMLP_PKG dependencies on QA_QLTRSLTR_XMLP_PKG

Line 1: PACKAGE BODY QA_QLTRSLTR_XMLP_PKG AS

1: PACKAGE BODY QA_QLTRSLTR_XMLP_PKG AS
2: /* $Header: QLTRSLTRB.pls 120.0 2007/12/24 10:38:28 krreddy noship $ */
3: FUNCTION AFTERPFORM RETURN BOOLEAN IS
4: BEGIN
5: DECLARE

Line 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) ;

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) ;
1879: ELSE
1880: V_SELECT := V_SELECT || ', 999 num_' || TO_CHAR(V_COUNTER);
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:

Line 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) ;

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) ;
1879: ELSE
1880: V_SELECT := V_SELECT || ', 999 num_' || TO_CHAR(V_COUNTER);
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'

Line 1955: QA_QLTRSLTR_XMLP_PKG.V_SELECT := V_SELECT ||' '|| ' ' || V_FROM;

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;
1959: QA_QLTRSLTR_XMLP_PKG.V_SUM := V_SUMS;

Line 1956: QA_QLTRSLTR_XMLP_PKG.V_WHERE := V_WHERE || ' ' || V_ORDER_BY || ' ' || V_GROUP_BY;

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;
1959: QA_QLTRSLTR_XMLP_PKG.V_SUM := V_SUMS;
1960: END LAUNCH_PRODUCT;

Line 1957: QA_QLTRSLTR_XMLP_PKG.V_PROMPTS := V_PROMPTS;

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;
1959: QA_QLTRSLTR_XMLP_PKG.V_SUM := V_SUMS;
1960: END LAUNCH_PRODUCT;
1961:

Line 1958: QA_QLTRSLTR_XMLP_PKG.V_LENGTH := V_LENGTHS;

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;
1959: QA_QLTRSLTR_XMLP_PKG.V_SUM := V_SUMS;
1960: END LAUNCH_PRODUCT;
1961:
1962: PROCEDURE CREATE_WHERE(X_ROW IN NUMBER) IS

Line 1959: QA_QLTRSLTR_XMLP_PKG.V_SUM := V_SUMS;

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;
1959: QA_QLTRSLTR_XMLP_PKG.V_SUM := V_SUMS;
1960: END LAUNCH_PRODUCT;
1961:
1962: PROCEDURE CREATE_WHERE(X_ROW IN NUMBER) IS
1963: V_NAME VARCHAR2(100);

Line 2378: END QA_QLTRSLTR_XMLP_PKG;

2374: ,PREC.LIST_ID);
2375: END LOOP;
2376: END LOOP_THROUGH_RECORDS;
2377:
2378: END QA_QLTRSLTR_XMLP_PKG;
2379:
2380: