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.QLTTRAWB dependencies on QA_RESULTS

Line 415: qa_core_pkg.dsql_add_text(' UPDATE QA_RESULTS_INTERFACE QRI ' ||

411:
412: parse_error_columns(ERROR_COL_LIST, l_col1, l_col2, l_col3, l_col4, l_col5);
413:
414: qa_core_pkg.dsql_init;
415: qa_core_pkg.dsql_add_text(' UPDATE QA_RESULTS_INTERFACE QRI ' ||
416: 'SET LAST_UPDATE_DATE = SYSDATE' ||
417: ', LAST_UPDATE_LOGIN = ');
418: qa_core_pkg.dsql_add_bind(X_LAST_UPDATE_LOGIN);
419: qa_core_pkg.dsql_add_text(' , REQUEST_ID = ');

Line 538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||

534: qa_core_pkg.dsql_add_bind(X_PROGRAM_ID);
535: qa_core_pkg.dsql_add_text(' , SYSDATE ');
536:
537:
538: qa_core_pkg.dsql_add_text(' FROM QA_RESULTS_INTERFACE QRI ' ||
539: 'WHERE QRI.GROUP_ID = ' );
540:
541: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
542: qa_core_pkg.dsql_add_text(' ');

Line 648: UPDATE QA_RESULTS_INTERFACE QRI

644: NUM_ACTIONS := I;
645:
646:
647: IF (NUM_ACTIONS > 0) THEN
648: UPDATE QA_RESULTS_INTERFACE QRI
649: SET LAST_UPDATE_DATE = SYSDATE,
650: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
651: REQUEST_ID = X_REQUEST_ID,
652: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 779: 'FROM QA_RESULTS_INTERFACE QRI ' ||

775: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
776: ':ERROR_NEED_REV, SYSDATE, ' ||
777: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
778: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
779: 'FROM QA_RESULTS_INTERFACE QRI ' ||
780: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
781: ' AND QRI.PROCESS_STATUS = 2 ' ||
782: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
783: ' AND NOT EXISTS

Line 790: '(SELECT ''X'' FROM QA_RESULTS_INTERFACE ' ||

786: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
787: 'QRI.TRANSACTION_INTERFACE_ID ' ||
788: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
789: ' AND EXISTS ' ||
790: '(SELECT ''X'' FROM QA_RESULTS_INTERFACE ' ||
791: 'WHERE QRI.' || COL_NAME || ' IS NULL ' ||
792: ' AND QRI.' || REV_COLUMN || ' = 2)';
793:
794: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

Line 831: 'FROM QA_RESULTS_INTERFACE QRI ' ||

827: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
828: ':ERROR_CANT_HAVE_REV, SYSDATE, ' ||
829: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
830: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
831: 'FROM QA_RESULTS_INTERFACE QRI ' ||
832: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
833: ' AND QRI.PROCESS_STATUS = 2 ' ||
834: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
835: ' AND NOT EXISTS

Line 842: '(SELECT ''X'' FROM QA_RESULTS_INTERFACE ' ||

838: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
839: 'QRI.TRANSACTION_INTERFACE_ID ' ||
840: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
841: ' AND EXISTS ' ||
842: '(SELECT ''X'' FROM QA_RESULTS_INTERFACE ' ||
843: 'WHERE QRI.' || COL_NAME || ' IS NOT NULL ' ||
844: ' AND QRI.' || REV_COLUMN || ' = 1)';
845:
846: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

Line 927: 'FROM QA_RESULTS_INTERFACE QRI ' ||

923: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
924: ':ERROR_MANDATORY, SYSDATE, ' ||
925: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
926: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
927: 'FROM QA_RESULTS_INTERFACE QRI ' ||
928: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
929: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
930: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
931: ' AND NOT EXISTS

Line 969: 'FROM QA_RESULTS_INTERFACE QRI ' ||

965: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
966: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
967: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
968: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
969: 'FROM QA_RESULTS_INTERFACE QRI ' ||
970: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
971: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
972: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
973: ' AND NOT EXISTS

Line 1009: 'FROM QA_RESULTS_INTERFACE QRI ' ||

1005: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
1006: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
1007: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
1008: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
1009: 'FROM QA_RESULTS_INTERFACE QRI ' ||
1010: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1011: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1012: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1013: ' AND NOT EXISTS

Line 1095: 'FROM QA_RESULTS_INTERFACE QRI ' ||

1091: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
1092: ':ERROR_MANDATORY, SYSDATE, ' ||
1093: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
1094: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
1095: 'FROM QA_RESULTS_INTERFACE QRI ' ||
1096: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1097: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1098: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1099: ' AND NOT EXISTS

Line 1137: 'FROM QA_RESULTS_INTERFACE QRI ' ||

1133: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
1134: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
1135: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
1136: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
1137: 'FROM QA_RESULTS_INTERFACE QRI ' ||
1138: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1139: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1140: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1141: ' AND NOT EXISTS

Line 1194: 'FROM QA_RESULTS_INTERFACE QRI ' ||

1190: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
1191: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
1192: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
1193: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
1194: 'FROM QA_RESULTS_INTERFACE QRI ' ||
1195: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1196: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1197: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1198: ' AND NOT EXISTS

Line 1284: ' FROM QA_RESULTS_INTERFACE QRI ' ||

1280: -- Added to_char() around the variable thats being validated
1281: --
1282: SQL_STATEMENT :=
1283: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
1284: ' FROM QA_RESULTS_INTERFACE QRI ' ||
1285: ' WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1286: ' AND QRI.PROCESS_STATUS = 2 ' ||
1287: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1288: ' AND NOT EXISTS

Line 1416: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1412: -- SQL Bind project. Code modified to use bind variables instead of literals
1413: -- Same as the fix done for Bug 3079312.suramasw.
1414:
1415: SQL_STATEMENT :=
1416: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1417: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1418: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1419: ', REQUEST_ID = :REQUEST_ID ' ||
1420: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 1560: 'FROM QA_RESULTS_INTERFACE QRI, ' ||

1556: 'QRI.' || COMP_TEXT || 'SUBINVENTORY, ' ||
1557: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1558: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1559: 'QRI.' || COMP_TEXT || 'ITEM_ID ' ||
1560: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1561: ' MTL_PARAMETERS MP ' ||
1562: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1563: ' AND QRI.PROCESS_STATUS = 2 ' ||
1564: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 1654: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1650:
1651: -- update interface table with gen loc ctrl value
1652:
1653: SQL_STATEMENT :=
1654: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1655: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1656: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1657: ', REQUEST_ID = :REQUEST_ID ' ||
1658: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 1734: -- records will be validated as successful and moved to qa_results table

1730: -- (CID) generated above will be -1 because the combination will not be
1731: -- available in the system.So after import the user opens UQR or VQR an
1732: -- error is thrown saying the combination doesn't exist and the locator
1733: -- field is blank. After this fix,if CID is valid(>0) then only imported
1734: -- records will be validated as successful and moved to qa_results table
1735: -- else it will error out in the interface table as 'Invalid Value'.
1736: -- Bug 2649257.suramasw.
1737:
1738: IF CID > 0 THEN

Line 1749: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1745: -- SQL Bind project. Code modified to use bind variables instead of literals
1746: -- Same as the fix done for Bug 3079312.suramasw.
1747:
1748: SQL_STATEMENT :=
1749: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1750: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1751: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1752: ', REQUEST_ID = :REQUEST_ID ' ||
1753: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 1895: 'FROM QA_RESULTS_INTERFACE QRI, ' ||

1891: 'QRI.TO_SUBINVENTORY, ' ||
1892: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1893: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1894: 'QRI.ITEM_ID ' ||
1895: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1896: ' MTL_PARAMETERS MP ' ||
1897: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1898: ' AND QRI.PROCESS_STATUS = 2 ' ||
1899: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 1987: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1983: END IF;
1984: -- update interface table with gen loc ctrl value
1985:
1986: SQL_STATEMENT :=
1987: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1988: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1989: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1990: ', REQUEST_ID = :REQUEST_ID ' ||
1991: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2059: -- records will be validated as successful and moved to qa_results table

2055: -- (CID) generated above will be -1 because the combination will not be
2056: -- available in the system.So after import the user opens UQR or VQR an
2057: -- error is thrown saying the combination doesn't exist and the to_locator
2058: -- field is blank. After this fix,if CID is valid(>0) then only imported
2059: -- records will be validated as successful and moved to qa_results table
2060: -- else it will error out in the interface table as 'Invalid Value'.
2061: -- Bug 2649257.suramasw.
2062:
2063: IF CID > 0 THEN

Line 2074: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2070: -- SQL Bind project. Code modified to use bind variables instead of literals
2071: -- Same as the fix done for Bug 3079312.suramasw.
2072:
2073: SQL_STATEMENT :=
2074: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2075: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2076: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2077: ', REQUEST_ID = :REQUEST_ID ' ||
2078: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2247: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2243:
2244: SQL_STATEMENT :=
2245: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
2246: ', ORGANIZATION_ID, LINE_ID ' ||
2247: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2248: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2249: ' AND QRI.PROCESS_STATUS = 2 ' ||
2250: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2251: ' AND NOT EXISTS

Line 2379: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2375: -- srhariha. Fri Apr 15 05:05:29 PDT 2005.
2376:
2377:
2378: SQL_STATEMENT :=
2379: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2380: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2381: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2382: ', REQUEST_ID = :REQUEST_ID ' ||
2383: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2460: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2456: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
2457: ':ERROR_MANDATORY, SYSDATE, ' ||
2458: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
2459: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
2460: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2461: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2462: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
2463: ' AND NOT EXISTS ' ||
2464: '(SELECT ''X'' ' ||

Line 2572: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2568:
2569: SQL_STATEMENT :=
2570: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
2571: ', ORGANIZATION_ID ' ||
2572: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2573: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2574: ' AND QRI.PROCESS_STATUS = 2 ' ||
2575: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2576: ' AND NOT EXISTS

Line 2650: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2646: CID := FND_FLEX_KEYVAL.COMBINATION_ID;
2647: X_ORG_ID := ORG_ID_TABLE(I);
2648:
2649: SQL_STATEMENT :=
2650: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2651: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2652: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2653: ', REQUEST_ID = :REQUEST_ID ' ||
2654: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2755: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2751:
2752: SQL_STATEMENT :=
2753: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
2754: ', ORGANIZATION_ID, LINE_ID ' ||
2755: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2756: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2757: ' AND QRI.PROCESS_STATUS = 2 ' ||
2758: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2759: ' AND NOT EXISTS

Line 2837: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2833: -- SQL Bind project. Code modified to use bind variables instead of literals
2834: -- Same as the fix done for Bug 3079312.suramasw.
2835:
2836: SQL_STATEMENT :=
2837: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2838: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2839: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2840: ', REQUEST_ID = :REQUEST_ID ' ||
2841: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2922: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2918: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
2919: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
2920: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
2921: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
2922: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2923: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2924: ' AND QRI.PROCESS_STATUS = 2 ' ||
2925: 'AND NOT EXISTS
2926: (SELECT ''X'' ' ||

Line 3005: 'FROM QA_RESULTS_INTERFACE QRI ' ||

3001: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
3002: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
3003: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
3004: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
3005: 'FROM QA_RESULTS_INTERFACE QRI ' ||
3006: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3007: ' AND QRI.PROCESS_STATUS = 2 ' ||
3008: 'AND NOT EXISTS
3009: (SELECT ''X'' ' ||

Line 3058: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

3054: -- SQL Bind project. Code modified to use bind variables instead of literals
3055: -- Same as the fix done for Bug 3079312.suramasw.
3056:
3057: SQL_STATEMENT :=
3058: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
3059: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3060: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3061: ', REQUEST_ID = :REQUEST_ID ' ||
3062: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 3133: 'FROM QA_RESULTS_INTERFACE QRI ' ||

3129: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
3130: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
3131: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
3132: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
3133: 'FROM QA_RESULTS_INTERFACE QRI ' ||
3134: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3135: ' AND QRI.PROCESS_STATUS = 2 ' ||
3136: 'AND NOT EXISTS
3137: (SELECT ''X'' ' ||

Line 3186: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

3182: -- SQL Bind project. Code modified to use bind variables instead of literals
3183: -- Same as the fix done for Bug 3079312.suramasw.
3184:
3185: SQL_STATEMENT :=
3186: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
3187: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3188: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3189: ', REQUEST_ID = :REQUEST_ID ' ||
3190: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 3225: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri

3221: p_col_name IN VARCHAR2) RETURN VARCHAR2 IS
3222:
3223: CURSOR c IS
3224: SELECT name
3225: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri
3226: WHERE qc.char_id = qpc.char_id
3227: AND qpc.plan_id = qri.plan_id
3228: AND qpc.result_column_name = p_col_name
3229: AND qri.group_id = p_group_id;

Line 3292: 'FROM QA_RESULTS_INTERFACE QRI ' ||

3288: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
3289: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
3290: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
3291: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
3292: 'FROM QA_RESULTS_INTERFACE QRI ' ||
3293: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3294: ' AND QRI.PROCESS_STATUS = 2 ' ||
3295: 'AND NOT EXISTS
3296: (SELECT ''X'' ' ||

Line 3375: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

3371: -- SQL Bind project. Code modified to use bind variables instead of literals
3372: -- Same as the fix done for Bug 3079312.suramasw.
3373:
3374: SQL_STATEMENT :=
3375: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
3376: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3377: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3378: ', REQUEST_ID = :REQUEST_ID ' ||
3379: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 3433: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

3429: -- SQL Bind project. Code modified to use bind variables instead of literals
3430: -- Same as the fix done for Bug 3079312.suramasw.
3431:
3432: SQL_STATEMENT :=
3433: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
3434: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3435: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3436: ', REQUEST_ID = :REQUEST_ID ' ||
3437: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 3493: UPDATE QA_RESULTS_INTERFACE qri

3489: QLTTRAMB.qa_import_log('Procedure SET_ERROR_STATUS');
3490: QLTTRAMB.qa_import_log('Setting error status for error caused on column X_COLUMN_NAME='||X_COLUMN_NAME);
3491:
3492: IF (X_COLUMN_NAME IS NULL) THEN
3493: UPDATE QA_RESULTS_INTERFACE qri
3494: SET PROCESS_STATUS = 3,
3495: LAST_UPDATE_DATE = SYSDATE,
3496: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
3497: REQUEST_ID = X_REQUEST_ID,

Line 3515: UPDATE QA_RESULTS_INTERFACE QRI

3511: -- AND TRANSACTION_INTERFACE_ID IN
3512: -- (SELECT TRANSACTION_INTERFACE_ID
3513: -- FROM QA_INTERFACE_ERRORS);
3514: ELSE
3515: UPDATE QA_RESULTS_INTERFACE QRI
3516: SET PROCESS_STATUS = 3,
3517: LAST_UPDATE_DATE = SYSDATE,
3518: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
3519: REQUEST_ID = X_REQUEST_ID,

Line 3588: 'FROM QA_RESULTS_INTERFACE QRI ' ||

3584: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
3585: ':ERROR_OUTSIDE_LIMITS, SYSDATE, ' ||
3586: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
3587: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
3588: 'FROM QA_RESULTS_INTERFACE QRI ' ||
3589: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3590: ' AND QRI.PROCESS_STATUS = 2 ' ||
3591: 'AND NOT EXISTS
3592: (SELECT ''X'' ' ||

Line 4215: -- We'll update this into QA_RESULTS_INTERFACE

4211: BEGIN
4212: -- This procedure is rewritten for bug 2548710.
4213: -- Get the count of transaction records. We need to derive sequence
4214: -- for all the records and populate into G_SEQ_TABxx variables
4215: -- We'll update this into QA_RESULTS_INTERFACE
4216: -- in TRANSFER_VALID_ROWS() and UPDATE_VALID_ROWS(). See bug 2548710 for
4217: -- more details. kabalakr.
4218:
4219: -- Optimized the code for bug 2548710. rponnusa Mon Nov 18 03:49:15 PST 2002

Line 4237: 'UPDATE QA_RESULTS_INTERFACE QRI ' || 'SET LAST_UPDATE_DATE = SYSDATE, ' ||

4233: -- SQL Bind project. Code modified to use bind variables instead of literals
4234: -- Same as the fix done for Bug 3079312.suramasw.
4235:
4236: SQL_STATEMENT :=
4237: 'UPDATE QA_RESULTS_INTERFACE QRI ' || 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
4238: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
4239: ', REQUEST_ID = :REQUEST_ID ' ||
4240: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||
4241: ', PROGRAM_ID = :PROGRAM_ID ' ||

Line 4293: --FROM QA_RESULTS_INTERFACE

4289: MUST_BE_NULL := TRUE;
4290: ELSE -- this is update, the element must be null unless it is a matching element
4291: --SELECT MATCHING_ELEMENTS
4292: --INTO L_MATCHING_ELEMENTS
4293: --FROM QA_RESULTS_INTERFACE
4294: --WHERE GROUP_ID = P_GROUP_ID;
4295:
4296: --L_MATCHING_ELEMENTS := UPPER(L_MATCHING_ELEMENTS);
4297:

Line 4326: -- QA_RESULTS that will be updated.

4322:
4323:
4324: -- Adding update capabilites. (1) Parse matching elements list. (2) Validate
4325: -- all matching elements are elements of the plan. (3) Get rowids for rows in
4326: -- QA_RESULTS that will be updated.
4327:
4328: --
4329: -- Bug 4254876. Added param hardcoded_column_table
4330: -- bso

Line 4376: FROM QA_RESULTS_INTERFACE

4372: QLTTRAMB.qa_import_log('Start of Procedure VALIDATE_UPDATE_TYPE_RECORDS');
4373:
4374: SELECT MATCHING_ELEMENTS, TRANSACTION_INTERFACE_ID
4375: INTO X_MATCHING_ELEMENTS, X_TRANSACTION_INTERFACE_ID
4376: FROM QA_RESULTS_INTERFACE
4377: WHERE GROUP_ID = X_GROUP_ID;
4378:
4379: X_MATCHING_ELEMENTS := UPPER(X_MATCHING_ELEMENTS);
4380:

Line 4499: -- Now select the QA_RESULTS rowids that needs to be updated.

4495: exception when no_data_found then
4496: QLTTRAMB.qa_import_log('Error - The plan name or view name or import view name is not found for plan_id ='||X_PLAN_ID);
4497: end;
4498:
4499: -- Now select the QA_RESULTS rowids that needs to be updated.
4500:
4501: -- Changed the SELECT_STMT as below so that the import_view_name
4502: -- and view_name which are queried up from qa_plans are used rather
4503: -- than simply using the plan_name.Commented out the existing code.

Line 4691: FROM QA_RESULTS_INTERFACE QRI

4687: SYSDATE, X_USER_ID,
4688: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4689: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4690: SYSDATE
4691: FROM QA_RESULTS_INTERFACE QRI
4692: WHERE QRI.GROUP_ID = X_GROUP_ID
4693: AND QRI.PROCESS_STATUS = 2;
4694: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4695: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

Line 4717: FROM QA_RESULTS_INTERFACE QRI

4713: SYSDATE, X_USER_ID,
4714: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4715: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4716: SYSDATE
4717: FROM QA_RESULTS_INTERFACE QRI
4718: WHERE QRI.GROUP_ID = X_GROUP_ID
4719: AND QRI.PROCESS_STATUS = 2;
4720: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4721: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

Line 4742: FROM QA_RESULTS_INTERFACE QRI

4738: SYSDATE, X_USER_ID,
4739: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4740: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4741: SYSDATE
4742: FROM QA_RESULTS_INTERFACE QRI
4743: WHERE QRI.GROUP_ID = X_GROUP_ID
4744: AND QRI.PROCESS_STATUS = 2;
4745: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4746: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

Line 4768: FROM QA_RESULTS_INTERFACE QRI

4764: SYSDATE, X_USER_ID,
4765: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4766: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4767: SYSDATE
4768: FROM QA_RESULTS_INTERFACE QRI
4769: WHERE QRI.GROUP_ID = X_GROUP_ID
4770: AND QRI.PROCESS_STATUS = 2;
4771: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4772: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

Line 4832: -- that are null with values from the corresponding QA_RESULTS record.

4828: WHERE PLAN_ID = X_PLAN_ID;
4829:
4830:
4831: -- now that the record is stored in the PL/SQL table, populate all columns
4832: -- that are null with values from the corresponding QA_RESULTS record.
4833: -- This is so that we can use the VALIDATE_STEPS function as it was designed
4834: -- for insert-type records (e.g. if just the item revision column is
4835: -- populated in the interface record, we don't want it to error out when
4836: -- VALIDATE_STEPS sees that that column's parent column, item, is not

Line 4845: UPDATE_STMT := 'UPDATE QA_RESULTS_INTERFACE QRI ' || 'SET (';

4841:
4842: -- Included ELSIF condition to consider Comment columns.
4843: -- suramasw.Bug 2917335.Thu Apr 24 21:24:56 PDT 2003.
4844:
4845: UPDATE_STMT := 'UPDATE QA_RESULTS_INTERFACE QRI ' || 'SET (';
4846: FOR I IN 1..NUM_ELEMS LOOP
4847: IF RESULT_COLUMN_NAME(I) LIKE 'CHARACTER%' THEN
4848: UPDATE_STMT := UPDATE_STMT || RESULT_COLUMN_NAME(I);
4849: ELSIF RESULT_COLUMN_NAME(I) LIKE 'SEQUENCE%' THEN

Line 4878: -- dont retrieve data from QA_RESULTS (Value_String is null) ,else fetch the value.

4874:
4875: -- Bug 3759926.Update transaction was failing if plan has read only or disabled elements.
4876: -- Retrieve update records was not considering this scenario.
4877: -- We check for whether element is either read only or disabled,if evaluates true
4878: -- dont retrieve data from QA_RESULTS (Value_String is null) ,else fetch the value.
4879: -- srhariha. Wed Jul 14 02:15:41 PDT 2004.
4880:
4881: IF (READ_ONLY_FLAG_TABLE(I) = 1) OR
4882: (ENABLED_FLAG_TABLE(I) = 2) THEN

Line 4908: -- We were updating QA_RESULTS_INTERFACE wih values from QA_RESULTS for corresponding

4904: ',qltdate.date_to_canon_dt(' || VALUE_STRING || ')';
4905: END IF;
4906:
4907: -- Bug 3755745.Update of result was erroring out if the plan has sequence elements.
4908: -- We were updating QA_RESULTS_INTERFACE wih values from QA_RESULTS for corresponding
4909: -- rows.But VALIDATE_SEQUENCE issues errror if a value exist for SEQUENCEXX.
4910: -- Hence we shouldnt retrieve value of sequence from QA_RESULTS if sequence col
4911: -- has null value.SEQUENCEXX can have other values than NULL.(1)User tries to
4912: -- update it manually or(2) it is a matching element.Both these cases are handled

Line 4910: -- Hence we shouldnt retrieve value of sequence from QA_RESULTS if sequence col

4906:
4907: -- Bug 3755745.Update of result was erroring out if the plan has sequence elements.
4908: -- We were updating QA_RESULTS_INTERFACE wih values from QA_RESULTS for corresponding
4909: -- rows.But VALIDATE_SEQUENCE issues errror if a value exist for SEQUENCEXX.
4910: -- Hence we shouldnt retrieve value of sequence from QA_RESULTS if sequence col
4911: -- has null value.SEQUENCEXX can have other values than NULL.(1)User tries to
4912: -- update it manually or(2) it is a matching element.Both these cases are handled
4913: -- in VALIDATE_SEQUENCE procedures.
4914: -- srhariha. Fri Jul 9 05:33:30 PDT 2004.

Line 5042: FROM qa_results_interface qri

5038:
5039: -- MOAC: define a new cursor for getting gruop organization_id
5040: CURSOR inv_org_id(p_group_id NUMBER) IS
5041: SELECT organization_id
5042: FROM qa_results_interface qri
5043: WHERE qri.group_id = p_group_id
5044: AND qri.process_status = 2;
5045:
5046:

Line 5076: UPDATE QA_RESULTS_INTERFACE

5072: WHERE USER_ID = X_USER_ID;
5073:
5074: -- set qa_created_by_name and _id to the current user if they are null
5075:
5076: UPDATE QA_RESULTS_INTERFACE
5077: SET QA_CREATED_BY = X_USER_ID,
5078: QA_CREATED_BY_NAME = X_USER_NAME,
5079: QA_LAST_UPDATED_BY = X_USER_ID,
5080: QA_LAST_UPDATED_BY_NAME = X_USER_NAME,

Line 5116: FROM QA_RESULTS_INTERFACE QRI

5112: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
5113: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
5114: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
5115: SYSDATE
5116: FROM QA_RESULTS_INTERFACE QRI
5117: WHERE QRI.GROUP_ID = X_GROUP_ID
5118: AND QRI.PROCESS_STATUS = 2
5119: AND QRI.INSERT_TYPE <> 2 -- added for 3663648
5120: AND NOT EXISTS

Line 5148: UPDATE QA_RESULTS_INTERFACE QRI

5144: -- inserted for QA_LAST_UPDATED_BY also during insert transaction, so included
5145: -- the code to insert value for QA_LAST_UPDATED_BY.
5146: -- Bug 3663648.suramasw.
5147:
5148: UPDATE QA_RESULTS_INTERFACE QRI
5149: SET LAST_UPDATE_DATE = SYSDATE,
5150: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5151: REQUEST_ID = X_REQUEST_ID,
5152: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5180: UPDATE QA_RESULTS_INTERFACE

5176: -- when the user doesnot provide the value for qa_last_updated_by_name when
5177: -- updating the record.Hence uncommented the code.
5178: -- Bug 3663648.suramasw.
5179:
5180: UPDATE QA_RESULTS_INTERFACE
5181: SET QA_LAST_UPDATED_BY = X_USER_ID,
5182: QA_LAST_UPDATED_BY_NAME = X_USER_NAME
5183: WHERE GROUP_ID = X_GROUP_ID
5184: AND PROCESS_STATUS = 2

Line 5203: FROM QA_RESULTS_INTERFACE QRI

5199: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
5200: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
5201: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
5202: SYSDATE
5203: FROM QA_RESULTS_INTERFACE QRI
5204: WHERE QRI.GROUP_ID = X_GROUP_ID
5205: AND QRI.PROCESS_STATUS = 2
5206: AND QRI.INSERT_TYPE = 2 -- added for 3663648
5207: AND NOT EXISTS

Line 5235: UPDATE QA_RESULTS_INTERFACE QRI

5231: -- QA_CREATED_BY to QA_LAST_UPDATED_BY as we need to update only
5232: -- QA_LAST_UPDATED_BY during update transaction.
5233: -- Bug 3663648.suramasw.
5234:
5235: UPDATE QA_RESULTS_INTERFACE QRI
5236: SET LAST_UPDATE_DATE = SYSDATE,
5237: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5238: REQUEST_ID = X_REQUEST_ID,
5239: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5269: FROM QA_RESULTS_INTERFACE QRI

5265: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
5266: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
5267: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
5268: SYSDATE
5269: FROM QA_RESULTS_INTERFACE QRI
5270: WHERE QRI.GROUP_ID = X_GROUP_ID
5271: AND QRI.PROCESS_STATUS = 2
5272: AND NOT EXISTS
5273: (SELECT 'X'

Line 5291: UPDATE QA_RESULTS_INTERFACE QRI

5287:
5288: -- group derivation for organization_id
5289: -- Bug 4958776. SQL Repository Fix SQL ID: 15009164
5290: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
5291: UPDATE QA_RESULTS_INTERFACE QRI
5292: SET LAST_UPDATE_DATE = SYSDATE,
5293: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5294: REQUEST_ID = X_REQUEST_ID,
5295: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5361: UPDATE qa_results_interface qri

5357: -- referenced entity only once and should be more efficient
5358: -- assuming normally there is only a few errors.
5359: -- bso Sun Oct 2 16:29:30 PDT 2005
5360:
5361: UPDATE qa_results_interface qri
5362: SET last_update_date = sysdate,
5363: last_update_login = x_last_update_login,
5364: request_id = x_request_id,
5365: program_application_id = x_program_application_id,

Line 5404: FROM qa_results_interface qri

5400: x_request_id,
5401: x_program_application_id,
5402: x_program_id,
5403: sysdate
5404: FROM qa_results_interface qri
5405: WHERE qri.group_id = x_group_id AND
5406: qri.process_status = 2 AND
5407: qri.operating_unit IS NOT NULL AND
5408: qri.operating_unit_id IS NULL;

Line 5431: FROM QA_RESULTS_INTERFACE QRI

5427: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
5428: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
5429: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
5430: SYSDATE
5431: FROM QA_RESULTS_INTERFACE QRI
5432: WHERE QRI.GROUP_ID = X_GROUP_ID
5433: AND QRI.PROCESS_STATUS = 2
5434: AND NOT EXISTS
5435: (SELECT 'X'

Line 5452: UPDATE QA_RESULTS_INTERFACE QRI

5448: END IF;
5449:
5450: -- group derivation for plan_id
5451:
5452: UPDATE QA_RESULTS_INTERFACE QRI
5453: SET LAST_UPDATE_DATE = SYSDATE,
5454: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5455: REQUEST_ID = X_REQUEST_ID,
5456: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5490: FROM QA_RESULTS_INTERFACE QRI

5486: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
5487: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
5488: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
5489: SYSDATE
5490: FROM QA_RESULTS_INTERFACE QRI
5491: WHERE QRI.GROUP_ID = X_GROUP_ID
5492: AND QRI.PROCESS_STATUS = 2
5493: AND NOT EXISTS
5494: (SELECT 'X'

Line 5520: UPDATE QA_RESULTS_INTERFACE QRI

5516: -- subquery. It uses too much shared memory. Replaced with
5517: -- QA_SPECS and appended the effective date validation.
5518: -- bso Mon Nov 25 18:15:12 PST 2002
5519: --
5520: UPDATE QA_RESULTS_INTERFACE QRI
5521: SET LAST_UPDATE_DATE = SYSDATE,
5522: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5523: REQUEST_ID = X_REQUEST_ID,
5524: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5561: FROM QA_RESULTS_INTERFACE QRI

5557:
5558: BEGIN
5559: SELECT MAX(PLAN_ID)
5560: INTO X_PLAN_ID
5561: FROM QA_RESULTS_INTERFACE QRI
5562: WHERE QRI.GROUP_ID = X_GROUP_ID
5563: AND NOT EXISTS
5564: (SELECT 'X'
5565: FROM QA_INTERFACE_ERRORS QIE

Line 7711: -- Adding update capabilities. For each column of QA_RESULTS that will be

7707: RETURN TRUE;
7708: END VALIDATE;
7709:
7710:
7711: -- Adding update capabilities. For each column of QA_RESULTS that will be
7712: -- updated, a record is inserted into QA_RESULTS_UPDATE_HISTORY. Provides an
7713: -- audit trail.
7714: PROCEDURE POPULATE_HISTORY_TABLE(X_GROUP_ID NUMBER,
7715: X_TXN_HEADER_ID NUMBER,

Line 7712: -- updated, a record is inserted into QA_RESULTS_UPDATE_HISTORY. Provides an

7708: END VALIDATE;
7709:
7710:
7711: -- Adding update capabilities. For each column of QA_RESULTS that will be
7712: -- updated, a record is inserted into QA_RESULTS_UPDATE_HISTORY. Provides an
7713: -- audit trail.
7714: PROCEDURE POPULATE_HISTORY_TABLE(X_GROUP_ID NUMBER,
7715: X_TXN_HEADER_ID NUMBER,
7716: STMT_OF_ROWIDS VARCHAR2,

Line 7743: FROM QA_RESULTS_INTERFACE QRI

7739:
7740: BEGIN
7741: SELECT MAX(PLAN_ID)
7742: INTO X_PLAN_ID
7743: FROM QA_RESULTS_INTERFACE QRI
7744: WHERE QRI.GROUP_ID = X_GROUP_ID
7745: AND PROCESS_STATUS = 2;
7746:
7747: -- if no rows were successfully validated, no need to continue....

Line 7776: -- into qa_results_update_history.This happens when you enter a record through

7772: -- Same as the fix done for Bug 3079312.suramasw.
7773:
7774: -- Added the NVL condition for QR.RESULT_COLUMN_NAME_TABLE.
7775: -- Comparing NULL values should have NVL else the query fails to insert record
7776: -- into qa_results_update_history.This happens when you enter a record through
7777: -- EQR and then update the record through collection import.
7778: -- Bug 3273447. suramasw
7779:
7780: -- Bug 3765730.Updating functionality was not working if the plan has hardcoded date element.

Line 7799: SQL_STATEMENT := 'INSERT INTO QA_RESULTS_UPDATE_HISTORY ' ||

7795: L_ROWID := substr(stmt_of_rowids,3,length(stmt_of_rowids)-4);
7796:
7797:
7798: FOR J IN 1..NUM_COLS LOOP
7799: SQL_STATEMENT := 'INSERT INTO QA_RESULTS_UPDATE_HISTORY ' ||
7800: '(OCCURRENCE,UPDATE_ID,CREATION_DATE,CREATED_BY,' ||
7801: ' LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,' ||
7802: ' TXN_HEADER_ID,CHAR_ID,OLD_VALUE,REQUEST_ID,' ||
7803: ' PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE) ' ||

Line 7804: 'SELECT QR.OCCURRENCE, QA_RESULTS_UPDATE_HISTORY_S.nextval, ' ||

7800: '(OCCURRENCE,UPDATE_ID,CREATION_DATE,CREATED_BY,' ||
7801: ' LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,' ||
7802: ' TXN_HEADER_ID,CHAR_ID,OLD_VALUE,REQUEST_ID,' ||
7803: ' PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE) ' ||
7804: 'SELECT QR.OCCURRENCE, QA_RESULTS_UPDATE_HISTORY_S.nextval, ' ||
7805: 'sysdate, :USER_ID, sysdate, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
7806: ':TXN_HEADER_ID, :RESULT_COLUMN_ID' ||
7807: ', QR.' || RESULT_COLUMN_NAME_TABLE(J) || ', ' ||
7808: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, ' ||

Line 7810: 'FROM QA_RESULTS QR, ' ||

7806: ':TXN_HEADER_ID, :RESULT_COLUMN_ID' ||
7807: ', QR.' || RESULT_COLUMN_NAME_TABLE(J) || ', ' ||
7808: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, ' ||
7809: ':PROGRAM_ID, sysdate ' ||
7810: 'FROM QA_RESULTS QR, ' ||
7811: 'QA_RESULTS_INTERFACE QRI ' ||
7812: 'WHERE QR.ROWID = :BIND_ROWID ' ||
7813: ' AND QRI.GROUP_ID = :GROUP_ID ' ||
7814: ' AND (QR.' || RESULT_COLUMN_NAME_TABLE(J) || ' <> QRI.' || RESULT_COLUMN_NAME_TABLE(J)||

Line 7811: 'QA_RESULTS_INTERFACE QRI ' ||

7807: ', QR.' || RESULT_COLUMN_NAME_TABLE(J) || ', ' ||
7808: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, ' ||
7809: ':PROGRAM_ID, sysdate ' ||
7810: 'FROM QA_RESULTS QR, ' ||
7811: 'QA_RESULTS_INTERFACE QRI ' ||
7812: 'WHERE QR.ROWID = :BIND_ROWID ' ||
7813: ' AND QRI.GROUP_ID = :GROUP_ID ' ||
7814: ' AND (QR.' || RESULT_COLUMN_NAME_TABLE(J) || ' <> QRI.' || RESULT_COLUMN_NAME_TABLE(J)||
7815: ' OR (QR.' || RESULT_COLUMN_NAME_TABLE(J)|| ' IS NOT NULL AND ' ||

Line 7842: -- QA_RESULTS.

7838: END POPULATE_HISTORY_TABLE;
7839:
7840:
7841: -- Adding update capabilities. This procedure does the actual updates to
7842: -- QA_RESULTS.
7843: PROCEDURE UPDATE_VALID_ROWS(X_GROUP_ID NUMBER,
7844: X_USER_ID NUMBER,
7845: X_LAST_UPDATE_LOGIN NUMBER,
7846: X_TXN_HEADER_ID NUMBER,

Line 7880: WHERE plan_id = (SELECT plan_id from qa_results_interface

7876: --
7877: CURSOR sc_elements_cur IS
7878: SELECT result_column_name
7879: FROM qa_plan_chars
7880: WHERE plan_id = (SELECT plan_id from qa_results_interface
7881: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID)
7882: AND (result_column_name like 'CHARACTER%' OR
7883: result_column_name like 'COMMENT%');
7884:

Line 7901: FROM QA_RESULTS_INTERFACE QRI

7897: I := 0;
7898:
7899: SELECT MAX(TRANSACTION_INTERFACE_ID)
7900: INTO X_TRANSACTION_INTERFACE_ID
7901: FROM QA_RESULTS_INTERFACE QRI
7902: WHERE QRI.GROUP_ID = X_GROUP_ID
7903: AND PROCESS_STATUS = 2;
7904:
7905: SELECT MAX(PLAN_ID)

Line 7907: FROM QA_RESULTS_INTERFACE QRI

7903: AND PROCESS_STATUS = 2;
7904:
7905: SELECT MAX(PLAN_ID)
7906: INTO X_PLAN_ID
7907: FROM QA_RESULTS_INTERFACE QRI
7908: WHERE QRI.TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
7909: AND PROCESS_STATUS = 2;
7910:
7911: -- if no rows were successfully validated, no need to continue....

Line 7918: -- QA_RESULTS. For more info see Bug 2548710.

7914: END IF;
7915:
7916: -- Get all the interface_ids for this group_id onto a struct.
7917: -- We need to update the SEQUENCExx columns before we update to
7918: -- QA_RESULTS. For more info see Bug 2548710.
7919:
7920: -- Bug 3136107.
7921: -- SQL Bind project. Code modified to use bind variables instead of literals
7922: -- Same as the fix done for Bug 3079312.suramasw.

Line 7926: 'FROM QA_RESULTS_INTERFACE QRI ' ||

7922: -- Same as the fix done for Bug 3079312.suramasw.
7923:
7924: SQL_STATEMENT :=
7925: 'SELECT TRANSACTION_INTERFACE_ID ' ||
7926: 'FROM QA_RESULTS_INTERFACE QRI ' ||
7927: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
7928: ' AND QRI.PROCESS_STATUS = 2 ' ||
7929: ' AND NOT EXISTS
7930: (SELECT ''X'' ' ||

Line 7969: UPDATE QA_RESULTS_INTERFACE QRI

7965: -- together. Fetch the values for all sequence columns from the
7966: -- global variables. For more info see bug 2548710.
7967:
7968: FORALL J IN 1..NUM_ROWS
7969: UPDATE QA_RESULTS_INTERFACE QRI
7970: SET SEQUENCE1 = G_SEQ_TAB1(J),
7971: SEQUENCE2 = G_SEQ_TAB2(J),
7972: SEQUENCE3 = G_SEQ_TAB3(J),
7973: SEQUENCE4 = G_SEQ_TAB4(J),

Line 8056: -- build the SQL statement that updates records into QA_RESULTS

8052: VALUE_LIST := VALUE_LIST || ', NVL(QRI.'|| COLUMNS_TABLE(I) ||
8053: ', QR.' || COLUMNS_TABLE(I) || ') ';
8054: END LOOP;
8055:
8056: -- build the SQL statement that updates records into QA_RESULTS
8057:
8058:
8059: -- Bug 4270911. CU2 SQL Literal fix. TD #29
8060: -- Using bind variable for STMT_OF_ROWIDS, under the assumption

Line 8064: SQL_STATEMENT := 'UPDATE QA_RESULTS QR SET (' || COLUMN_LIST || ') = ' ||

8060: -- Using bind variable for STMT_OF_ROWIDS, under the assumption
8061: -- that QA open interface only supports update of single row.
8062: -- srhariha. Fri Apr 15 02:42:07 PDT 2005.
8063:
8064: SQL_STATEMENT := 'UPDATE QA_RESULTS QR SET (' || COLUMN_LIST || ') = ' ||
8065: '(SELECT ' || VALUE_LIST ||
8066: ' FROM QA_RESULTS_INTERFACE QRI ' ||
8067: 'WHERE QRI.TRANSACTION_INTERFACE_ID = :TRANSACTION_INTERFACE_ID ' ||
8068: ') WHERE ROWID = :BIND_ROWID';

Line 8066: ' FROM QA_RESULTS_INTERFACE QRI ' ||

8062: -- srhariha. Fri Apr 15 02:42:07 PDT 2005.
8063:
8064: SQL_STATEMENT := 'UPDATE QA_RESULTS QR SET (' || COLUMN_LIST || ') = ' ||
8065: '(SELECT ' || VALUE_LIST ||
8066: ' FROM QA_RESULTS_INTERFACE QRI ' ||
8067: 'WHERE QRI.TRANSACTION_INTERFACE_ID = :TRANSACTION_INTERFACE_ID ' ||
8068: ') WHERE ROWID = :BIND_ROWID';
8069:
8070:

Line 8074: -- update as the original sql was resulting in full table scan on qa_results.

8070:
8071: -- Lock the record and update. bso
8072:
8073: -- Modified the select statement as below for locking the record before
8074: -- update as the original sql was resulting in full table scan on qa_results.
8075: -- The value of stmt_of_rowids will be for eg - ('AAAJv4AAmAAAph+AAD').
8076: -- Usage of rowid as '('''||rowid||''')' in the select stmt is masking the
8077: -- CBO path on rowid and results in full table scan.So trimmed the prefix ('
8078: -- and suffix ') and stored the remaining in a local variable(l_rowid).Then

Line 8087: SELECT 1 INTO DUMMY FROM qa_results where rowid = l_rowid FOR UPDATE NOWAIT;

8083:
8084: l_rowid := substr(stmt_of_rowids,3,length(stmt_of_rowids)-4);
8085:
8086:
8087: SELECT 1 INTO DUMMY FROM qa_results where rowid = l_rowid FOR UPDATE NOWAIT;
8088:
8089: -- End of inclusion for bug 3788305.suramasw.
8090:
8091: /*

Line 8092: SELECT 1 INTO DUMMY FROM qa_results

8088:
8089: -- End of inclusion for bug 3788305.suramasw.
8090:
8091: /*
8092: SELECT 1 INTO DUMMY FROM qa_results
8093: WHERE '('''||rowid||''')' = stmt_of_rowids
8094: FOR UPDATE NOWAIT;
8095: */
8096:

Line 8117: qri_update_str_tab(1) := 'UPDATE qa_results SET ';

8113: FETCH sc_elements_cur BULK COLLECT INTO sc_elements_tab;
8114: CLOSE sc_elements_cur;
8115:
8116: IF sc_elements_tab.COUNT <> 0 THEN
8117: qri_update_str_tab(1) := 'UPDATE qa_results SET ';
8118:
8119: FOR cntr IN 1..sc_elements_tab.COUNT
8120: LOOP
8121: IF (cntr = 1) THEN

Line 8172: FROM QA_RESULTS_INTERFACE

8168: SYSDATE, X_USER_ID,
8169: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
8170: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
8171: SYSDATE
8172: FROM QA_RESULTS_INTERFACE
8173: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
8174:
8175: If (sql%rowcount >0) THEN
8176: QLTTRAMB.qa_import_log('Exception in update valid rows. Resource busy Error count :' ||sql%rowcount);

Line 8179: UPDATE QA_RESULTS_INTERFACE

8175: If (sql%rowcount >0) THEN
8176: QLTTRAMB.qa_import_log('Exception in update valid rows. Resource busy Error count :' ||sql%rowcount);
8177: END IF;
8178:
8179: UPDATE QA_RESULTS_INTERFACE
8180: SET PROCESS_STATUS = 3
8181: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
8182:
8183: COMMIT;

Line 8234: UPDATE QA_RESULTS_INTERFACE QRI

8230: FROM FND_USER_VIEW
8231: WHERE USER_ID = X_USER_ID;
8232:
8233: -- update who columns and org_id
8234: UPDATE QA_RESULTS_INTERFACE QRI
8235: SET QA_CREATED_BY = X_USER_ID,
8236: QA_CREATED_BY_NAME = X_USER_NAME,
8237: QA_LAST_UPDATED_BY = X_USER_ID,
8238: QA_LAST_UPDATED_BY_NAME = X_USER_NAME,

Line 8254: UPDATE QA_RESULTS_INTERFACE QRI

8250: WHERE GROUP_ID = X_GROUP_ID
8251: AND PROCESS_STATUS = 2;
8252:
8253: -- update plan_id and spec_id
8254: UPDATE QA_RESULTS_INTERFACE QRI
8255: SET -- plan_id
8256: PLAN_ID =
8257: (SELECT MIN(QP.PLAN_ID)
8258: FROM QA_PLANS QP

Line 8276: FROM QA_RESULTS_INTERFACE QRI

8272:
8273: IF TYPE_OF_TXN = 2 THEN
8274: SELECT MAX(PLAN_ID)
8275: INTO X_PLAN_ID
8276: FROM QA_RESULTS_INTERFACE QRI
8277: WHERE QRI.GROUP_ID = X_GROUP_ID;
8278:
8279: SELECT
8280: qpc.char_id,

Line 8378: FROM QA_RESULTS_INTERFACE QRI

8374: QLTTRAMB.qa_import_log('Inside TRANSFER_VALID_ROWS X_GROUP_ID :'||X_GROUP_ID);
8375:
8376: SELECT MAX(PLAN_ID)
8377: INTO X_PLAN_ID
8378: FROM QA_RESULTS_INTERFACE QRI
8379: WHERE QRI.GROUP_ID = X_GROUP_ID
8380: AND PROCESS_STATUS = 2;
8381:
8382: -- if no rows were successfully validated, no need to continue

Line 8395: -- QA_RESULTS. For more info see Bug 2548710.

8391: /*
8392:
8393: -- Get all the interface_ids for this group_id onto a struct.
8394: -- We need to update the SEQUENCExx columns before we insert into
8395: -- QA_RESULTS. For more info see Bug 2548710.
8396:
8397: -- Bug 3136107.
8398: -- SQL Bind project. Code modified to use bind variables instead of literals
8399: -- Same as the fix done for Bug 3079312.suramasw.

Line 8403: 'FROM QA_RESULTS_INTERFACE QRI ' ||

8399: -- Same as the fix done for Bug 3079312.suramasw.
8400:
8401: SQL_STATEMENT :=
8402: 'SELECT TRANSACTION_INTERFACE_ID ' ||
8403: 'FROM QA_RESULTS_INTERFACE QRI ' ||
8404: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
8405: ' AND QRI.PROCESS_STATUS = 2 ' ||
8406: ' AND NOT EXISTS
8407: (SELECT ''X'' ' ||

Line 8447: UPDATE QA_RESULTS_INTERFACE QRI

8443: -- together. Fetch the values for all sequence columns from the
8444: -- global variables. For more info see bug 2548710.
8445:
8446: FORALL J IN 1..NUM_ROWS
8447: UPDATE QA_RESULTS_INTERFACE QRI
8448: SET SEQUENCE1 = G_SEQ_TAB1(J),
8449: SEQUENCE2 = G_SEQ_TAB2(J),
8450: SEQUENCE3 = G_SEQ_TAB3(J),
8451: SEQUENCE4 = G_SEQ_TAB4(J),

Line 8528: -- build the sql statement that transfers records into qa_results

8524: COLUMN_LIST := COLUMN_LIST || ', ' || RESULT_COLUMN_NAME_TABLE(I);
8525: VALUE_LIST := VALUE_LIST || ', ' || RESULT_COLUMN_NAME_TABLE(I);
8526: END LOOP;
8527:
8528: -- build the sql statement that transfers records into qa_results
8529:
8530: SQL_STATEMENT := 'INSERT INTO QA_RESULTS (' || COLUMN_LIST ||
8531: ') SELECT ' || VALUE_LIST || ' FROM QA_RESULTS_INTERFACE ' ||
8532: 'WHERE GROUP_ID = :GROUP_ID ' ||

Line 8530: SQL_STATEMENT := 'INSERT INTO QA_RESULTS (' || COLUMN_LIST ||

8526: END LOOP;
8527:
8528: -- build the sql statement that transfers records into qa_results
8529:
8530: SQL_STATEMENT := 'INSERT INTO QA_RESULTS (' || COLUMN_LIST ||
8531: ') SELECT ' || VALUE_LIST || ' FROM QA_RESULTS_INTERFACE ' ||
8532: 'WHERE GROUP_ID = :GROUP_ID ' ||
8533: ' AND PROCESS_STATUS = 2';
8534:

Line 8531: ') SELECT ' || VALUE_LIST || ' FROM QA_RESULTS_INTERFACE ' ||

8527:
8528: -- build the sql statement that transfers records into qa_results
8529:
8530: SQL_STATEMENT := 'INSERT INTO QA_RESULTS (' || COLUMN_LIST ||
8531: ') SELECT ' || VALUE_LIST || ' FROM QA_RESULTS_INTERFACE ' ||
8532: 'WHERE GROUP_ID = :GROUP_ID ' ||
8533: ' AND PROCESS_STATUS = 2';
8534:
8535: -- Bug 3136107.

Line 8602: CURSOR C IS SELECT MARKER FROM QA_RESULTS_INTERFACE

8598:
8599: STMT_OF_ROWIDS VARCHAR2(10000); -- For update capabilities.
8600: l_error_message VARCHAR2(240);
8601:
8602: CURSOR C IS SELECT MARKER FROM QA_RESULTS_INTERFACE
8603: WHERE GROUP_ID = X_GROUP_ID
8604: AND PROCESS_STATUS = 2
8605: AND MARKER IS NOT NULL;
8606:

Line 8637: UPDATE QA_RESULTS_INTERFACE

8633: QLTTRAMB.qa_import_log('X_REQUEST_ID = '||X_REQUEST_ID);
8634:
8635: -- update process status to 2 (running) for rows in this group
8636:
8637: UPDATE QA_RESULTS_INTERFACE
8638: SET PROCESS_STATUS = 2,
8639: REQUEST_ID = X_REQUEST_ID,
8640: LAST_UPDATE_DATE = SYSDATE,
8641: LAST_UPDATED_BY = X_USER_ID,

Line 8664: FROM QA_RESULTS_INTERFACE

8660:
8661: DELETE FROM QA_INTERFACE_ERRORS
8662: WHERE TRANSACTION_INTERFACE_ID IN
8663: (SELECT TRANSACTION_INTERFACE_ID
8664: FROM QA_RESULTS_INTERFACE
8665: WHERE GROUP_ID = X_GROUP_ID);
8666:
8667: COMMIT;
8668:

Line 8699: UPDATE QA_RESULTS_INTERFACE

8695: QLTTRAMB.qa_import_log('type of transaction = insert, setting who columns');
8696:
8697: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO X_COLLECTION_ID FROM DUAL;
8698:
8699: UPDATE QA_RESULTS_INTERFACE
8700: SET COLLECTION_ID = NVL(COLLECTION_ID, X_COLLECTION_ID),
8701: QA_CREATED_BY = NVL(QA_CREATED_BY, X_USER_ID),
8702: QA_LAST_UPDATED_BY = NVL(QA_LAST_UPDATED_BY, X_USER_ID)
8703: WHERE GROUP_ID = X_GROUP_ID

Line 8708: UPDATE QA_RESULTS_INTERFACE

8704: AND PROCESS_STATUS = 2;
8705: ELSE
8706: QLTTRAMB.qa_import_log('type of transaction = update, setting who columns');
8707:
8708: UPDATE QA_RESULTS_INTERFACE
8709: SET QA_CREATED_BY = NVL(QA_CREATED_BY, X_USER_ID),
8710: QA_LAST_UPDATED_BY = NVL(QA_LAST_UPDATED_BY, X_USER_ID)
8711: WHERE GROUP_ID = X_GROUP_ID
8712: AND PROCESS_STATUS = 2;

Line 8782: FROM qa_results_interface qri

8778: and ppr.data_entry_mode in (2,4)
8779: and qpct.char_id = pca.assigned_char_id
8780: and pca.plan_char_action_trigger_id = qpcat.plan_char_action_trigger_id
8781: and qpcat.plan_id in (SELECT DISTINCT plan_id
8782: FROM qa_results_interface qri
8783: WHERE qri.group_id = x_group_id
8784: AND qri.process_status = 2)
8785: and pca.action_id = 24
8786: and ROWNUM =1;

Line 8817: FROM QA_RESULTS_INTERFACE QRI

8813:
8814: -- Bug 8586750.Fp for 8321226.Getting plan_ids to be passed to called procedure.
8815: SELECT DISTINCT PLAN_ID
8816: BULK COLLECT INTO PLAN_ID_TABLE
8817: FROM QA_RESULTS_INTERFACE QRI
8818: WHERE QRI.GROUP_ID = X_GROUP_ID
8819: AND PROCESS_STATUS = 2;
8820:
8821: -- Bug 8586750.Fp for 8321226.Calling these procedures to update/delete records from QRI

Line 8849: FROM QA_RESULTS_INTERFACE QRI

8845:
8846: -- Bug 8586750.Fp for 8321226.Getting plan_ids to be passed to called procedure.
8847: SELECT DISTINCT PLAN_ID
8848: BULK COLLECT INTO PLAN_ID_TABLE
8849: FROM QA_RESULTS_INTERFACE QRI
8850: WHERE QRI.GROUP_ID = X_GROUP_ID
8851: AND PROCESS_STATUS = 2;
8852:
8853: -- Bug 8586750.Fp for 8321226.Getting the txn_header_id for corresponding

Line 8909: FROM qa_results_interface

8905: SELECT transaction_interface_id, substr(l_error_message,1, 240),
8906: g_col_name, sysdate, x_user_id, sysdate, x_user_id,
8907: x_last_update_login, x_request_id, x_program_application_id,
8908: x_program_id, sysdate
8909: FROM qa_results_interface
8910: WHERE group_id = x_group_id;
8911:
8912: If (sql%rowcount >0) THEN
8913: QLTTRAMB.qa_import_log('Error in transaction worker due to user_sql_error Column : '||g_col_name || ' Error count :' || sql%rowcount);

Line 8916: UPDATE qa_results_interface

8912: If (sql%rowcount >0) THEN
8913: QLTTRAMB.qa_import_log('Error in transaction worker due to user_sql_error Column : '||g_col_name || ' Error count :' || sql%rowcount);
8914: END IF;
8915:
8916: UPDATE qa_results_interface
8917: SET process_status = 3
8918: WHERE group_id = x_group_id;
8919:
8920: COMMIT;

Line 8936: FROM QA_RESULTS_INTERFACE

8932: SYSDATE, X_USER_ID,
8933: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
8934: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
8935: SYSDATE
8936: FROM QA_RESULTS_INTERFACE
8937: WHERE GROUP_ID = X_GROUP_ID;
8938:
8939: If (sql%rowcount >0) THEN
8940: QLTTRAMB.qa_import_log('Error in transaction exception when others Error count :' || sql%rowcount);

Line 8943: UPDATE QA_RESULTS_INTERFACE

8939: If (sql%rowcount >0) THEN
8940: QLTTRAMB.qa_import_log('Error in transaction exception when others Error count :' || sql%rowcount);
8941: END IF;
8942:
8943: UPDATE QA_RESULTS_INTERFACE
8944: SET PROCESS_STATUS = 3
8945: WHERE GROUP_ID = X_GROUP_ID;
8946:
8947: COMMIT;

Line 8967: FROM QA_RESULTS_INTERFACE

8963:
8964: NEW_GROUP_ID NUMBER;
8965: RESULT BOOLEAN;
8966: CURSOR c1 IS SELECT rowid
8967: FROM QA_RESULTS_INTERFACE
8968: WHERE GROUP_ID = G_ID;
8969:
8970: BEGIN
8971: -- Loop through the group of update records

Line 8977: UPDATE QA_RESULTS_INTERFACE

8973: FOR rec IN c1 LOOP
8974: -- Get a new group ID to be used for the update records.
8975: SELECT QA_GROUP_S.NEXTVAL INTO NEW_GROUP_ID FROM DUAL;
8976:
8977: UPDATE QA_RESULTS_INTERFACE
8978: SET GROUP_ID = NEW_GROUP_ID
8979: WHERE rowid = rec.rowid;
8980:
8981: -- Call the old transaction worker to do the job.

Line 9258: UPDATE QA_RESULTS_INTERFACE

9254: P_DEBUG IN VARCHAR2) IS
9255: BEGIN
9256: -- update process status to 4 for successful rows
9257:
9258: UPDATE QA_RESULTS_INTERFACE
9259: SET PROCESS_STATUS = 4,
9260: REQUEST_ID = P_REQUEST_ID,
9261: LAST_UPDATE_DATE = SYSDATE,
9262: LAST_UPDATED_BY = P_USER_ID,

Line 9275: FROM QA_RESULTS_INTERFACE

9271:
9272: DELETE FROM QA_INTERFACE_ERRORS
9273: WHERE TRANSACTION_INTERFACE_ID IN
9274: (SELECT TRANSACTION_INTERFACE_ID
9275: FROM QA_RESULTS_INTERFACE
9276: WHERE PROCESS_STATUS = 4);
9277:
9278: -- delete all status 4 rows, not just the ones associated with the
9279: -- current group id. we delete all so that if the user changed a

Line 9284: DELETE FROM QA_RESULTS_INTERFACE WHERE PROCESS_STATUS = 4;

9280: -- record's status to 4 in the update form, it won't stay around forever.
9281: -- only delete the rows if the MRP_DEBUG profile is not set to Y.
9282:
9283: IF (NVL(P_DEBUG, 'N') <> 'Y') THEN
9284: DELETE FROM QA_RESULTS_INTERFACE WHERE PROCESS_STATUS = 4;
9285: END IF;
9286:
9287: END UPDATE_DELETE_QRI;
9288:

Line 9301: FROM qa_results

9297: -- action firing
9298: --
9299: CURSOR res_cur IS
9300: SELECT collection_id,occurrence,organization_id
9301: FROM qa_results
9302: WHERE plan_id = P_PLAN_ID
9303: AND txn_header_id = P_TXN_HEADER_ID;
9304:
9305: l_ret_val VARCHAR2(10);