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 827: 'FROM QA_RESULTS_INTERFACE QRI ' ||

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

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

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

Line 921: 'FROM QA_RESULTS_INTERFACE QRI ' ||

917: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
918: ':ERROR_MANDATORY, SYSDATE, ' ||
919: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
920: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
921: 'FROM QA_RESULTS_INTERFACE QRI ' ||
922: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
923: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
924: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
925: ' AND NOT EXISTS

Line 959: 'FROM QA_RESULTS_INTERFACE QRI ' ||

955: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
956: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
957: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
958: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
959: 'FROM QA_RESULTS_INTERFACE QRI ' ||
960: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
961: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
962: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
963: ' AND NOT EXISTS

Line 997: 'FROM QA_RESULTS_INTERFACE QRI ' ||

993: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
994: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
995: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
996: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
997: 'FROM QA_RESULTS_INTERFACE QRI ' ||
998: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
999: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1000: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1001: ' AND NOT EXISTS

Line 1080: 'FROM QA_RESULTS_INTERFACE QRI ' ||

1076: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
1077: ':ERROR_MANDATORY, SYSDATE, ' ||
1078: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
1079: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
1080: 'FROM QA_RESULTS_INTERFACE QRI ' ||
1081: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1082: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1083: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1084: ' AND NOT EXISTS

Line 1118: 'FROM QA_RESULTS_INTERFACE QRI ' ||

1114: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
1115: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
1116: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
1117: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
1118: 'FROM QA_RESULTS_INTERFACE QRI ' ||
1119: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1120: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1121: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1122: ' AND NOT EXISTS

Line 1171: 'FROM QA_RESULTS_INTERFACE QRI ' ||

1167: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
1168: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
1169: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
1170: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
1171: 'FROM QA_RESULTS_INTERFACE QRI ' ||
1172: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1173: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1174: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1175: ' AND NOT EXISTS

Line 1245: ' FROM QA_RESULTS_INTERFACE QRI ' ||

1241: -- Replaced :ERR_COL introduced in the version 115.63 by :ERROR_COL_NAME
1242:
1243: SQL_STATEMENT :=
1244: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
1245: ' FROM QA_RESULTS_INTERFACE QRI ' ||
1246: ' WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1247: ' AND QRI.PROCESS_STATUS = 2 ' ||
1248: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1249: ' AND NOT EXISTS

Line 1352: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1348: -- SQL Bind project. Code modified to use bind variables instead of literals
1349: -- Same as the fix done for Bug 3079312.suramasw.
1350:
1351: SQL_STATEMENT :=
1352: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1353: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1354: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1355: ', REQUEST_ID = :REQUEST_ID ' ||
1356: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 1487: 'FROM QA_RESULTS_INTERFACE QRI, ' ||

1483: 'QRI.' || COMP_TEXT || 'SUBINVENTORY, ' ||
1484: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1485: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1486: 'QRI.' || COMP_TEXT || 'ITEM_ID ' ||
1487: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1488: ' MTL_PARAMETERS MP ' ||
1489: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1490: ' AND QRI.PROCESS_STATUS = 2 ' ||
1491: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 1577: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1573:
1574: -- update interface table with gen loc ctrl value
1575:
1576: SQL_STATEMENT :=
1577: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1578: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1579: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1580: ', REQUEST_ID = :REQUEST_ID ' ||
1581: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

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

1653: -- (CID) generated above will be -1 because the combination will not be
1654: -- available in the system.So after import the user opens UQR or VQR an
1655: -- error is thrown saying the combination doesn't exist and the locator
1656: -- field is blank. After this fix,if CID is valid(>0) then only imported
1657: -- records will be validated as successful and moved to qa_results table
1658: -- else it will error out in the interface table as 'Invalid Value'.
1659: -- Bug 2649257.suramasw.
1660:
1661: IF CID > 0 THEN

Line 1672: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1668: -- SQL Bind project. Code modified to use bind variables instead of literals
1669: -- Same as the fix done for Bug 3079312.suramasw.
1670:
1671: SQL_STATEMENT :=
1672: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1673: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1674: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1675: ', REQUEST_ID = :REQUEST_ID ' ||
1676: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 1812: 'FROM QA_RESULTS_INTERFACE QRI, ' ||

1808: 'QRI.TO_SUBINVENTORY, ' ||
1809: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1810: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1811: 'QRI.ITEM_ID ' ||
1812: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1813: ' MTL_PARAMETERS MP ' ||
1814: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1815: ' AND QRI.PROCESS_STATUS = 2 ' ||
1816: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 1900: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1896: END IF;
1897: -- update interface table with gen loc ctrl value
1898:
1899: SQL_STATEMENT :=
1900: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
1901: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
1902: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
1903: ', REQUEST_ID = :REQUEST_ID ' ||
1904: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

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

1968: -- (CID) generated above will be -1 because the combination will not be
1969: -- available in the system.So after import the user opens UQR or VQR an
1970: -- error is thrown saying the combination doesn't exist and the to_locator
1971: -- field is blank. After this fix,if CID is valid(>0) then only imported
1972: -- records will be validated as successful and moved to qa_results table
1973: -- else it will error out in the interface table as 'Invalid Value'.
1974: -- Bug 2649257.suramasw.
1975:
1976: IF CID > 0 THEN

Line 1987: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

1983: -- SQL Bind project. Code modified to use bind variables instead of literals
1984: -- Same as the fix done for Bug 3079312.suramasw.
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 2154: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2150:
2151: SQL_STATEMENT :=
2152: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
2153: ', ORGANIZATION_ID, LINE_ID ' ||
2154: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2155: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2156: ' AND QRI.PROCESS_STATUS = 2 ' ||
2157: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2158: ' AND NOT EXISTS

Line 2286: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2282: -- srhariha. Fri Apr 15 05:05:29 PDT 2005.
2283:
2284:
2285: SQL_STATEMENT :=
2286: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2287: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2288: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2289: ', REQUEST_ID = :REQUEST_ID ' ||
2290: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2363: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2359: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
2360: ':ERROR_MANDATORY, SYSDATE, ' ||
2361: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
2362: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
2363: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2364: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2365: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
2366: ' AND NOT EXISTS ' ||
2367: '(SELECT ''X'' ' ||

Line 2472: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2468:
2469: SQL_STATEMENT :=
2470: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
2471: ', ORGANIZATION_ID ' ||
2472: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2473: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2474: ' AND QRI.PROCESS_STATUS = 2 ' ||
2475: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2476: ' AND NOT EXISTS

Line 2550: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2546: CID := FND_FLEX_KEYVAL.COMBINATION_ID;
2547: X_ORG_ID := ORG_ID_TABLE(I);
2548:
2549: SQL_STATEMENT :=
2550: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2551: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2552: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2553: ', REQUEST_ID = :REQUEST_ID ' ||
2554: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2651: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2647:
2648: SQL_STATEMENT :=
2649: 'SELECT TRANSACTION_INTERFACE_ID, ' || COL_NAME ||
2650: ', ORGANIZATION_ID, LINE_ID ' ||
2651: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2652: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2653: ' AND QRI.PROCESS_STATUS = 2 ' ||
2654: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2655: ' AND NOT EXISTS

Line 2733: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2729: -- SQL Bind project. Code modified to use bind variables instead of literals
2730: -- Same as the fix done for Bug 3079312.suramasw.
2731:
2732: SQL_STATEMENT :=
2733: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2734: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2735: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2736: ', REQUEST_ID = :REQUEST_ID ' ||
2737: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 2814: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2810: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
2811: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
2812: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
2813: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
2814: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2815: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2816: ' AND QRI.PROCESS_STATUS = 2 ' ||
2817: 'AND NOT EXISTS
2818: (SELECT ''X'' ' ||

Line 2890: 'FROM QA_RESULTS_INTERFACE QRI ' ||

2886: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
2887: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
2888: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
2889: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
2890: 'FROM QA_RESULTS_INTERFACE QRI ' ||
2891: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2892: ' AND QRI.PROCESS_STATUS = 2 ' ||
2893: 'AND NOT EXISTS
2894: (SELECT ''X'' ' ||

Line 2940: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

2936: -- SQL Bind project. Code modified to use bind variables instead of literals
2937: -- Same as the fix done for Bug 3079312.suramasw.
2938:
2939: SQL_STATEMENT :=
2940: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2941: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
2942: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
2943: ', REQUEST_ID = :REQUEST_ID ' ||
2944: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 3015: 'FROM QA_RESULTS_INTERFACE QRI ' ||

3011: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
3012: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
3013: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
3014: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
3015: 'FROM QA_RESULTS_INTERFACE QRI ' ||
3016: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3017: ' AND QRI.PROCESS_STATUS = 2 ' ||
3018: 'AND NOT EXISTS
3019: (SELECT ''X'' ' ||

Line 3064: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

3060: -- SQL Bind project. Code modified to use bind variables instead of literals
3061: -- Same as the fix done for Bug 3079312.suramasw.
3062:
3063: SQL_STATEMENT :=
3064: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
3065: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3066: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3067: ', REQUEST_ID = :REQUEST_ID ' ||
3068: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

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

3099: p_col_name IN VARCHAR2) RETURN VARCHAR2 IS
3100:
3101: CURSOR c IS
3102: SELECT name
3103: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri
3104: WHERE qc.char_id = qpc.char_id
3105: AND qpc.plan_id = qri.plan_id
3106: AND qpc.result_column_name = p_col_name
3107: AND qri.group_id = p_group_id;

Line 3162: 'FROM QA_RESULTS_INTERFACE QRI ' ||

3158: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
3159: ':ERROR_INVALID_VALUE, SYSDATE, ' ||
3160: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, :REQUEST_ID, ' ||
3161: ':PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
3162: 'FROM QA_RESULTS_INTERFACE QRI ' ||
3163: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3164: ' AND QRI.PROCESS_STATUS = 2 ' ||
3165: 'AND NOT EXISTS
3166: (SELECT ''X'' ' ||

Line 3239: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

3235: -- SQL Bind project. Code modified to use bind variables instead of literals
3236: -- Same as the fix done for Bug 3079312.suramasw.
3237:
3238: SQL_STATEMENT :=
3239: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
3240: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3241: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3242: ', REQUEST_ID = :REQUEST_ID ' ||
3243: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 3297: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||

3293: -- SQL Bind project. Code modified to use bind variables instead of literals
3294: -- Same as the fix done for Bug 3079312.suramasw.
3295:
3296: SQL_STATEMENT :=
3297: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
3298: 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3299: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3300: ', REQUEST_ID = :REQUEST_ID ' ||
3301: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||

Line 3354: UPDATE QA_RESULTS_INTERFACE qri

3350: X_PROGRAM_ID NUMBER, X_LAST_UPDATE_LOGIN NUMBER,
3351: X_COLUMN_NAME VARCHAR2 DEFAULT NULL) IS
3352: BEGIN
3353: IF (X_COLUMN_NAME IS NULL) THEN
3354: UPDATE QA_RESULTS_INTERFACE qri
3355: SET PROCESS_STATUS = 3,
3356: LAST_UPDATE_DATE = SYSDATE,
3357: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
3358: REQUEST_ID = X_REQUEST_ID,

Line 3372: UPDATE QA_RESULTS_INTERFACE QRI

3368: -- AND TRANSACTION_INTERFACE_ID IN
3369: -- (SELECT TRANSACTION_INTERFACE_ID
3370: -- FROM QA_INTERFACE_ERRORS);
3371: ELSE
3372: UPDATE QA_RESULTS_INTERFACE QRI
3373: SET PROCESS_STATUS = 3,
3374: LAST_UPDATE_DATE = SYSDATE,
3375: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
3376: REQUEST_ID = X_REQUEST_ID,

Line 3440: 'FROM QA_RESULTS_INTERFACE QRI ' ||

3436: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||
3437: ':ERROR_OUTSIDE_LIMITS, SYSDATE, ' ||
3438: ':USER_ID, SYSDATE, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
3439: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, SYSDATE ' ||
3440: 'FROM QA_RESULTS_INTERFACE QRI ' ||
3441: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3442: ' AND QRI.PROCESS_STATUS = 2 ' ||
3443: 'AND NOT EXISTS
3444: (SELECT ''X'' ' ||

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

3930: BEGIN
3931: -- This procedure is rewritten for bug 2548710.
3932: -- Get the count of transaction records. We need to derive sequence
3933: -- for all the records and populate into G_SEQ_TABxx variables
3934: -- We'll update this into QA_RESULTS_INTERFACE
3935: -- in TRANSFER_VALID_ROWS() and UPDATE_VALID_ROWS(). See bug 2548710 for
3936: -- more details. kabalakr.
3937:
3938: -- Optimized the code for bug 2548710. rponnusa Mon Nov 18 03:49:15 PST 2002

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

3952: -- SQL Bind project. Code modified to use bind variables instead of literals
3953: -- Same as the fix done for Bug 3079312.suramasw.
3954:
3955: SQL_STATEMENT :=
3956: 'UPDATE QA_RESULTS_INTERFACE QRI ' || 'SET LAST_UPDATE_DATE = SYSDATE, ' ||
3957: 'LAST_UPDATE_LOGIN = :LAST_UPDATE_LOGIN ' ||
3958: ', REQUEST_ID = :REQUEST_ID ' ||
3959: ', PROGRAM_APPLICATION_ID = :PROGRAM_APPLICATION_ID ' ||
3960: ', PROGRAM_ID = :PROGRAM_ID ' ||

Line 4012: --FROM QA_RESULTS_INTERFACE

4008: MUST_BE_NULL := TRUE;
4009: ELSE -- this is update, the element must be null unless it is a matching element
4010: --SELECT MATCHING_ELEMENTS
4011: --INTO L_MATCHING_ELEMENTS
4012: --FROM QA_RESULTS_INTERFACE
4013: --WHERE GROUP_ID = P_GROUP_ID;
4014:
4015: --L_MATCHING_ELEMENTS := UPPER(L_MATCHING_ELEMENTS);
4016:

Line 4045: -- QA_RESULTS that will be updated.

4041:
4042:
4043: -- Adding update capabilites. (1) Parse matching elements list. (2) Validate
4044: -- all matching elements are elements of the plan. (3) Get rowids for rows in
4045: -- QA_RESULTS that will be updated.
4046:
4047: --
4048: -- Bug 4254876. Added param hardcoded_column_table
4049: -- bso

Line 4093: FROM QA_RESULTS_INTERFACE

4089: BEGIN
4090:
4091: SELECT MATCHING_ELEMENTS, TRANSACTION_INTERFACE_ID
4092: INTO X_MATCHING_ELEMENTS, X_TRANSACTION_INTERFACE_ID
4093: FROM QA_RESULTS_INTERFACE
4094: WHERE GROUP_ID = X_GROUP_ID;
4095:
4096: X_MATCHING_ELEMENTS := UPPER(X_MATCHING_ELEMENTS);
4097:

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

4205: INTO l_viewname
4206: FROM QA_PLANS
4207: WHERE PLAN_ID = X_PLAN_ID;
4208:
4209: -- Now select the QA_RESULTS rowids that needs to be updated.
4210:
4211: -- Changed the SELECT_STMT as below so that the import_view_name
4212: -- and view_name which are queried up from qa_plans are used rather
4213: -- than simply using the plan_name.Commented out the existing code.

Line 4398: FROM QA_RESULTS_INTERFACE QRI

4394: SYSDATE, X_USER_ID,
4395: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4396: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4397: SYSDATE
4398: FROM QA_RESULTS_INTERFACE QRI
4399: WHERE QRI.GROUP_ID = X_GROUP_ID
4400: AND QRI.PROCESS_STATUS = 2;
4401: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4402: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

Line 4419: FROM QA_RESULTS_INTERFACE QRI

4415: SYSDATE, X_USER_ID,
4416: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4417: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4418: SYSDATE
4419: FROM QA_RESULTS_INTERFACE QRI
4420: WHERE QRI.GROUP_ID = X_GROUP_ID
4421: AND QRI.PROCESS_STATUS = 2;
4422: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4423: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

Line 4440: FROM QA_RESULTS_INTERFACE QRI

4436: SYSDATE, X_USER_ID,
4437: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4438: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4439: SYSDATE
4440: FROM QA_RESULTS_INTERFACE QRI
4441: WHERE QRI.GROUP_ID = X_GROUP_ID
4442: AND QRI.PROCESS_STATUS = 2;
4443: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4444: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

Line 4461: FROM QA_RESULTS_INTERFACE QRI

4457: SYSDATE, X_USER_ID,
4458: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4459: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4460: SYSDATE
4461: FROM QA_RESULTS_INTERFACE QRI
4462: WHERE QRI.GROUP_ID = X_GROUP_ID
4463: AND QRI.PROCESS_STATUS = 2;
4464: SET_ERROR_STATUS(X_GROUP_ID, X_USER_ID, X_REQUEST_ID,
4465: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,

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

4514: WHERE PLAN_ID = X_PLAN_ID;
4515:
4516:
4517: -- now that the record is stored in the PL/SQL table, populate all columns
4518: -- that are null with values from the corresponding QA_RESULTS record.
4519: -- This is so that we can use the VALIDATE_STEPS function as it was designed
4520: -- for insert-type records (e.g. if just the item revision column is
4521: -- populated in the interface record, we don't want it to error out when
4522: -- VALIDATE_STEPS sees that that column's parent column, item, is not

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

4527:
4528: -- Included ELSIF condition to consider Comment columns.
4529: -- suramasw.Bug 2917335.Thu Apr 24 21:24:56 PDT 2003.
4530:
4531: UPDATE_STMT := 'UPDATE QA_RESULTS_INTERFACE QRI ' || 'SET (';
4532: FOR I IN 1..NUM_ELEMS LOOP
4533: IF RESULT_COLUMN_NAME(I) LIKE 'CHARACTER%' THEN
4534: UPDATE_STMT := UPDATE_STMT || RESULT_COLUMN_NAME(I);
4535: ELSIF RESULT_COLUMN_NAME(I) LIKE 'SEQUENCE%' THEN

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

4558:
4559: -- Bug 3759926.Update transaction was failing if plan has read only or disabled elements.
4560: -- Retrieve update records was not considering this scenario.
4561: -- We check for whether element is either read only or disabled,if evaluates true
4562: -- dont retrieve data from QA_RESULTS (Value_String is null) ,else fetch the value.
4563: -- srhariha. Wed Jul 14 02:15:41 PDT 2004.
4564:
4565: IF (READ_ONLY_FLAG_TABLE(I) = 1) OR
4566: (ENABLED_FLAG_TABLE(I) = 2) THEN

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

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

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

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

Line 4714: FROM qa_results_interface qri

4710:
4711: -- MOAC: define a new cursor for getting gruop organization_id
4712: CURSOR inv_org_id(p_group_id NUMBER) IS
4713: SELECT organization_id
4714: FROM qa_results_interface qri
4715: WHERE qri.group_id = p_group_id
4716: AND qri.process_status = 2;
4717:
4718:

Line 4745: UPDATE QA_RESULTS_INTERFACE

4741: WHERE USER_ID = X_USER_ID;
4742:
4743: -- set qa_created_by_name and _id to the current user if they are null
4744:
4745: UPDATE QA_RESULTS_INTERFACE
4746: SET QA_CREATED_BY = X_USER_ID,
4747: QA_CREATED_BY_NAME = X_USER_NAME,
4748: QA_LAST_UPDATED_BY = X_USER_ID,
4749: QA_LAST_UPDATED_BY_NAME = X_USER_NAME,

Line 4785: FROM QA_RESULTS_INTERFACE QRI

4781: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
4782: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4783: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4784: SYSDATE
4785: FROM QA_RESULTS_INTERFACE QRI
4786: WHERE QRI.GROUP_ID = X_GROUP_ID
4787: AND QRI.PROCESS_STATUS = 2
4788: AND QRI.INSERT_TYPE <> 2 -- added for 3663648
4789: AND NOT EXISTS

Line 4813: UPDATE QA_RESULTS_INTERFACE QRI

4809: -- inserted for QA_LAST_UPDATED_BY also during insert transaction, so included
4810: -- the code to insert value for QA_LAST_UPDATED_BY.
4811: -- Bug 3663648.suramasw.
4812:
4813: UPDATE QA_RESULTS_INTERFACE QRI
4814: SET LAST_UPDATE_DATE = SYSDATE,
4815: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
4816: REQUEST_ID = X_REQUEST_ID,
4817: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 4845: UPDATE QA_RESULTS_INTERFACE

4841: -- when the user doesnot provide the value for qa_last_updated_by_name when
4842: -- updating the record.Hence uncommented the code.
4843: -- Bug 3663648.suramasw.
4844:
4845: UPDATE QA_RESULTS_INTERFACE
4846: SET QA_LAST_UPDATED_BY = X_USER_ID,
4847: QA_LAST_UPDATED_BY_NAME = X_USER_NAME
4848: WHERE GROUP_ID = X_GROUP_ID
4849: AND PROCESS_STATUS = 2

Line 4868: FROM QA_RESULTS_INTERFACE QRI

4864: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
4865: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4866: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4867: SYSDATE
4868: FROM QA_RESULTS_INTERFACE QRI
4869: WHERE QRI.GROUP_ID = X_GROUP_ID
4870: AND QRI.PROCESS_STATUS = 2
4871: AND QRI.INSERT_TYPE = 2 -- added for 3663648
4872: AND NOT EXISTS

Line 4896: UPDATE QA_RESULTS_INTERFACE QRI

4892: -- QA_CREATED_BY to QA_LAST_UPDATED_BY as we need to update only
4893: -- QA_LAST_UPDATED_BY during update transaction.
4894: -- Bug 3663648.suramasw.
4895:
4896: UPDATE QA_RESULTS_INTERFACE QRI
4897: SET LAST_UPDATE_DATE = SYSDATE,
4898: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
4899: REQUEST_ID = X_REQUEST_ID,
4900: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 4930: FROM QA_RESULTS_INTERFACE QRI

4926: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
4927: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4928: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4929: SYSDATE
4930: FROM QA_RESULTS_INTERFACE QRI
4931: WHERE QRI.GROUP_ID = X_GROUP_ID
4932: AND QRI.PROCESS_STATUS = 2
4933: AND NOT EXISTS
4934: (SELECT 'X'

Line 4948: UPDATE QA_RESULTS_INTERFACE QRI

4944:
4945: -- group derivation for organization_id
4946: -- Bug 4958776. SQL Repository Fix SQL ID: 15009164
4947: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
4948: UPDATE QA_RESULTS_INTERFACE QRI
4949: SET LAST_UPDATE_DATE = SYSDATE,
4950: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
4951: REQUEST_ID = X_REQUEST_ID,
4952: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5016: UPDATE qa_results_interface qri

5012: -- referenced entity only once and should be more efficient
5013: -- assuming normally there is only a few errors.
5014: -- bso Sun Oct 2 16:29:30 PDT 2005
5015:
5016: UPDATE qa_results_interface qri
5017: SET last_update_date = sysdate,
5018: last_update_login = x_last_update_login,
5019: request_id = x_request_id,
5020: program_application_id = x_program_application_id,

Line 5059: FROM qa_results_interface qri

5055: x_request_id,
5056: x_program_application_id,
5057: x_program_id,
5058: sysdate
5059: FROM qa_results_interface qri
5060: WHERE qri.group_id = x_group_id AND
5061: qri.process_status = 2 AND
5062: qri.operating_unit IS NOT NULL AND
5063: qri.operating_unit_id IS NULL;

Line 5083: FROM QA_RESULTS_INTERFACE QRI

5079: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
5080: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
5081: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
5082: SYSDATE
5083: FROM QA_RESULTS_INTERFACE QRI
5084: WHERE QRI.GROUP_ID = X_GROUP_ID
5085: AND QRI.PROCESS_STATUS = 2
5086: AND NOT EXISTS
5087: (SELECT 'X'

Line 5100: UPDATE QA_RESULTS_INTERFACE QRI

5096: AND QRI.ORGANIZATION_ID = QPVV.ORGANIZATION_ID);
5097:
5098: -- group derivation for plan_id
5099:
5100: UPDATE QA_RESULTS_INTERFACE QRI
5101: SET LAST_UPDATE_DATE = SYSDATE,
5102: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5103: REQUEST_ID = X_REQUEST_ID,
5104: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5138: FROM QA_RESULTS_INTERFACE QRI

5134: ERROR_INVALID_VALUE, SYSDATE, X_USER_ID,
5135: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
5136: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
5137: SYSDATE
5138: FROM QA_RESULTS_INTERFACE QRI
5139: WHERE QRI.GROUP_ID = X_GROUP_ID
5140: AND QRI.PROCESS_STATUS = 2
5141: AND NOT EXISTS
5142: (SELECT 'X'

Line 5165: UPDATE QA_RESULTS_INTERFACE QRI

5161: -- subquery. It uses too much shared memory. Replaced with
5162: -- QA_SPECS and appended the effective date validation.
5163: -- bso Mon Nov 25 18:15:12 PST 2002
5164: --
5165: UPDATE QA_RESULTS_INTERFACE QRI
5166: SET LAST_UPDATE_DATE = SYSDATE,
5167: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5168: REQUEST_ID = X_REQUEST_ID,
5169: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 5205: FROM QA_RESULTS_INTERFACE QRI

5201: -- failed.
5202:
5203: SELECT MAX(PLAN_ID)
5204: INTO X_PLAN_ID
5205: FROM QA_RESULTS_INTERFACE QRI
5206: WHERE QRI.GROUP_ID = X_GROUP_ID
5207: AND NOT EXISTS
5208: (SELECT 'X'
5209: FROM QA_INTERFACE_ERRORS QIE

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

7257: RETURN TRUE;
7258: END VALIDATE;
7259:
7260:
7261: -- Adding update capabilities. For each column of QA_RESULTS that will be
7262: -- updated, a record is inserted into QA_RESULTS_UPDATE_HISTORY. Provides an
7263: -- audit trail.
7264: PROCEDURE POPULATE_HISTORY_TABLE(X_GROUP_ID NUMBER,
7265: X_TXN_HEADER_ID NUMBER,

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

7258: END VALIDATE;
7259:
7260:
7261: -- Adding update capabilities. For each column of QA_RESULTS that will be
7262: -- updated, a record is inserted into QA_RESULTS_UPDATE_HISTORY. Provides an
7263: -- audit trail.
7264: PROCEDURE POPULATE_HISTORY_TABLE(X_GROUP_ID NUMBER,
7265: X_TXN_HEADER_ID NUMBER,
7266: STMT_OF_ROWIDS VARCHAR2,

Line 7293: FROM QA_RESULTS_INTERFACE QRI

7289:
7290: BEGIN
7291: SELECT MAX(PLAN_ID)
7292: INTO X_PLAN_ID
7293: FROM QA_RESULTS_INTERFACE QRI
7294: WHERE QRI.GROUP_ID = X_GROUP_ID
7295: AND PROCESS_STATUS = 2;
7296:
7297: -- if no rows were successfully validated, no need to continue....

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

7322: -- Same as the fix done for Bug 3079312.suramasw.
7323:
7324: -- Added the NVL condition for QR.RESULT_COLUMN_NAME_TABLE.
7325: -- Comparing NULL values should have NVL else the query fails to insert record
7326: -- into qa_results_update_history.This happens when you enter a record through
7327: -- EQR and then update the record through collection import.
7328: -- Bug 3273447. suramasw
7329:
7330: -- Bug 3765730.Updating functionality was not working if the plan has hardcoded date element.

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

7345: L_ROWID := substr(stmt_of_rowids,3,length(stmt_of_rowids)-4);
7346:
7347:
7348: FOR J IN 1..NUM_COLS LOOP
7349: SQL_STATEMENT := 'INSERT INTO QA_RESULTS_UPDATE_HISTORY ' ||
7350: '(OCCURRENCE,UPDATE_ID,CREATION_DATE,CREATED_BY,' ||
7351: ' LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,' ||
7352: ' TXN_HEADER_ID,CHAR_ID,OLD_VALUE,REQUEST_ID,' ||
7353: ' PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE) ' ||

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

7350: '(OCCURRENCE,UPDATE_ID,CREATION_DATE,CREATED_BY,' ||
7351: ' LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,' ||
7352: ' TXN_HEADER_ID,CHAR_ID,OLD_VALUE,REQUEST_ID,' ||
7353: ' PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE) ' ||
7354: 'SELECT QR.OCCURRENCE, QA_RESULTS_UPDATE_HISTORY_S.nextval, ' ||
7355: 'sysdate, :USER_ID, sysdate, :USER_ID2, :LAST_UPDATE_LOGIN, ' ||
7356: ':TXN_HEADER_ID, :RESULT_COLUMN_ID' ||
7357: ', QR.' || RESULT_COLUMN_NAME_TABLE(J) || ', ' ||
7358: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, ' ||

Line 7360: 'FROM QA_RESULTS QR, ' ||

7356: ':TXN_HEADER_ID, :RESULT_COLUMN_ID' ||
7357: ', QR.' || RESULT_COLUMN_NAME_TABLE(J) || ', ' ||
7358: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, ' ||
7359: ':PROGRAM_ID, sysdate ' ||
7360: 'FROM QA_RESULTS QR, ' ||
7361: 'QA_RESULTS_INTERFACE QRI ' ||
7362: 'WHERE QR.ROWID = :BIND_ROWID ' ||
7363: ' AND QRI.GROUP_ID = :GROUP_ID ' ||
7364: ' AND (QR.' || RESULT_COLUMN_NAME_TABLE(J) || ' <> QRI.' || RESULT_COLUMN_NAME_TABLE(J)||

Line 7361: 'QA_RESULTS_INTERFACE QRI ' ||

7357: ', QR.' || RESULT_COLUMN_NAME_TABLE(J) || ', ' ||
7358: ':REQUEST_ID, :PROGRAM_APPLICATION_ID, ' ||
7359: ':PROGRAM_ID, sysdate ' ||
7360: 'FROM QA_RESULTS QR, ' ||
7361: 'QA_RESULTS_INTERFACE QRI ' ||
7362: 'WHERE QR.ROWID = :BIND_ROWID ' ||
7363: ' AND QRI.GROUP_ID = :GROUP_ID ' ||
7364: ' AND (QR.' || RESULT_COLUMN_NAME_TABLE(J) || ' <> QRI.' || RESULT_COLUMN_NAME_TABLE(J)||
7365: ' OR (QR.' || RESULT_COLUMN_NAME_TABLE(J)|| ' IS NOT NULL AND ' ||

Line 7392: -- QA_RESULTS.

7388: END POPULATE_HISTORY_TABLE;
7389:
7390:
7391: -- Adding update capabilities. This procedure does the actual updates to
7392: -- QA_RESULTS.
7393: PROCEDURE UPDATE_VALID_ROWS(X_GROUP_ID NUMBER,
7394: X_USER_ID NUMBER,
7395: X_LAST_UPDATE_LOGIN NUMBER,
7396: X_TXN_HEADER_ID NUMBER,

Line 7429: FROM QA_RESULTS_INTERFACE QRI

7425: I := 0;
7426:
7427: SELECT MAX(TRANSACTION_INTERFACE_ID)
7428: INTO X_TRANSACTION_INTERFACE_ID
7429: FROM QA_RESULTS_INTERFACE QRI
7430: WHERE QRI.GROUP_ID = X_GROUP_ID
7431: AND PROCESS_STATUS = 2;
7432:
7433: SELECT MAX(PLAN_ID)

Line 7435: FROM QA_RESULTS_INTERFACE QRI

7431: AND PROCESS_STATUS = 2;
7432:
7433: SELECT MAX(PLAN_ID)
7434: INTO X_PLAN_ID
7435: FROM QA_RESULTS_INTERFACE QRI
7436: WHERE QRI.TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
7437: AND PROCESS_STATUS = 2;
7438:
7439: -- if no rows were successfully validated, no need to continue....

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

7442: END IF;
7443:
7444: -- Get all the interface_ids for this group_id onto a struct.
7445: -- We need to update the SEQUENCExx columns before we update to
7446: -- QA_RESULTS. For more info see Bug 2548710.
7447:
7448: -- Bug 3136107.
7449: -- SQL Bind project. Code modified to use bind variables instead of literals
7450: -- Same as the fix done for Bug 3079312.suramasw.

Line 7454: 'FROM QA_RESULTS_INTERFACE QRI ' ||

7450: -- Same as the fix done for Bug 3079312.suramasw.
7451:
7452: SQL_STATEMENT :=
7453: 'SELECT TRANSACTION_INTERFACE_ID ' ||
7454: 'FROM QA_RESULTS_INTERFACE QRI ' ||
7455: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
7456: ' AND QRI.PROCESS_STATUS = 2 ' ||
7457: ' AND NOT EXISTS
7458: (SELECT ''X'' ' ||

Line 7497: UPDATE QA_RESULTS_INTERFACE QRI

7493: -- together. Fetch the values for all sequence columns from the
7494: -- global variables. For more info see bug 2548710.
7495:
7496: FORALL J IN 1..NUM_ROWS
7497: UPDATE QA_RESULTS_INTERFACE QRI
7498: SET SEQUENCE1 = G_SEQ_TAB1(J),
7499: SEQUENCE2 = G_SEQ_TAB2(J),
7500: SEQUENCE3 = G_SEQ_TAB3(J),
7501: SEQUENCE4 = G_SEQ_TAB4(J),

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

7580: VALUE_LIST := VALUE_LIST || ', NVL(QRI.'|| COLUMNS_TABLE(I) ||
7581: ', QR.' || COLUMNS_TABLE(I) || ') ';
7582: END LOOP;
7583:
7584: -- build the SQL statement that updates records into QA_RESULTS
7585:
7586:
7587: -- Bug 4270911. CU2 SQL Literal fix. TD #29
7588: -- Using bind variable for STMT_OF_ROWIDS, under the assumption

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

7588: -- Using bind variable for STMT_OF_ROWIDS, under the assumption
7589: -- that QA open interface only supports update of single row.
7590: -- srhariha. Fri Apr 15 02:42:07 PDT 2005.
7591:
7592: SQL_STATEMENT := 'UPDATE QA_RESULTS QR SET (' || COLUMN_LIST || ') = ' ||
7593: '(SELECT ' || VALUE_LIST ||
7594: ' FROM QA_RESULTS_INTERFACE QRI ' ||
7595: 'WHERE QRI.TRANSACTION_INTERFACE_ID = :TRANSACTION_INTERFACE_ID ' ||
7596: ') WHERE ROWID = :BIND_ROWID';

Line 7594: ' FROM QA_RESULTS_INTERFACE QRI ' ||

7590: -- srhariha. Fri Apr 15 02:42:07 PDT 2005.
7591:
7592: SQL_STATEMENT := 'UPDATE QA_RESULTS QR SET (' || COLUMN_LIST || ') = ' ||
7593: '(SELECT ' || VALUE_LIST ||
7594: ' FROM QA_RESULTS_INTERFACE QRI ' ||
7595: 'WHERE QRI.TRANSACTION_INTERFACE_ID = :TRANSACTION_INTERFACE_ID ' ||
7596: ') WHERE ROWID = :BIND_ROWID';
7597:
7598:

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

7598:
7599: -- Lock the record and update. bso
7600:
7601: -- Modified the select statement as below for locking the record before
7602: -- update as the original sql was resulting in full table scan on qa_results.
7603: -- The value of stmt_of_rowids will be for eg - ('AAAJv4AAmAAAph+AAD').
7604: -- Usage of rowid as '('''||rowid||''')' in the select stmt is masking the
7605: -- CBO path on rowid and results in full table scan.So trimmed the prefix ('
7606: -- and suffix ') and stored the remaining in a local variable(l_rowid).Then

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

7611:
7612: l_rowid := substr(stmt_of_rowids,3,length(stmt_of_rowids)-4);
7613:
7614:
7615: SELECT 1 INTO DUMMY FROM qa_results where rowid = l_rowid FOR UPDATE NOWAIT;
7616:
7617: -- End of inclusion for bug 3788305.suramasw.
7618:
7619: /*

Line 7620: SELECT 1 INTO DUMMY FROM qa_results

7616:
7617: -- End of inclusion for bug 3788305.suramasw.
7618:
7619: /*
7620: SELECT 1 INTO DUMMY FROM qa_results
7621: WHERE '('''||rowid||''')' = stmt_of_rowids
7622: FOR UPDATE NOWAIT;
7623: */
7624:

Line 7660: FROM QA_RESULTS_INTERFACE

7656: SYSDATE, X_USER_ID,
7657: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
7658: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
7659: SYSDATE
7660: FROM QA_RESULTS_INTERFACE
7661: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
7662:
7663: UPDATE QA_RESULTS_INTERFACE
7664: SET PROCESS_STATUS = 3

Line 7663: UPDATE QA_RESULTS_INTERFACE

7659: SYSDATE
7660: FROM QA_RESULTS_INTERFACE
7661: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
7662:
7663: UPDATE QA_RESULTS_INTERFACE
7664: SET PROCESS_STATUS = 3
7665: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
7666:
7667: COMMIT;

Line 7718: UPDATE QA_RESULTS_INTERFACE QRI

7714: FROM FND_USER_VIEW
7715: WHERE USER_ID = X_USER_ID;
7716:
7717: -- update who columns and org_id
7718: UPDATE QA_RESULTS_INTERFACE QRI
7719: SET QA_CREATED_BY = X_USER_ID,
7720: QA_CREATED_BY_NAME = X_USER_NAME,
7721: QA_LAST_UPDATED_BY = X_USER_ID,
7722: QA_LAST_UPDATED_BY_NAME = X_USER_NAME,

Line 7738: UPDATE QA_RESULTS_INTERFACE QRI

7734: WHERE GROUP_ID = X_GROUP_ID
7735: AND PROCESS_STATUS = 2;
7736:
7737: -- update plan_id and spec_id
7738: UPDATE QA_RESULTS_INTERFACE QRI
7739: SET -- plan_id
7740: PLAN_ID =
7741: (SELECT MIN(QP.PLAN_ID)
7742: FROM QA_PLANS QP

Line 7760: FROM QA_RESULTS_INTERFACE QRI

7756:
7757: IF TYPE_OF_TXN = 2 THEN
7758: SELECT MAX(PLAN_ID)
7759: INTO X_PLAN_ID
7760: FROM QA_RESULTS_INTERFACE QRI
7761: WHERE QRI.GROUP_ID = X_GROUP_ID;
7762:
7763: SELECT
7764: qpc.char_id,

Line 7860: FROM QA_RESULTS_INTERFACE QRI

7856:
7857: BEGIN
7858: SELECT MAX(PLAN_ID)
7859: INTO X_PLAN_ID
7860: FROM QA_RESULTS_INTERFACE QRI
7861: WHERE QRI.GROUP_ID = X_GROUP_ID
7862: AND PROCESS_STATUS = 2;
7863:
7864: -- if no rows were successfully validated, no need to continue

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

7872: /*
7873:
7874: -- Get all the interface_ids for this group_id onto a struct.
7875: -- We need to update the SEQUENCExx columns before we insert into
7876: -- QA_RESULTS. For more info see Bug 2548710.
7877:
7878: -- Bug 3136107.
7879: -- SQL Bind project. Code modified to use bind variables instead of literals
7880: -- Same as the fix done for Bug 3079312.suramasw.

Line 7884: 'FROM QA_RESULTS_INTERFACE QRI ' ||

7880: -- Same as the fix done for Bug 3079312.suramasw.
7881:
7882: SQL_STATEMENT :=
7883: 'SELECT TRANSACTION_INTERFACE_ID ' ||
7884: 'FROM QA_RESULTS_INTERFACE QRI ' ||
7885: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
7886: ' AND QRI.PROCESS_STATUS = 2 ' ||
7887: ' AND NOT EXISTS
7888: (SELECT ''X'' ' ||

Line 7928: UPDATE QA_RESULTS_INTERFACE QRI

7924: -- together. Fetch the values for all sequence columns from the
7925: -- global variables. For more info see bug 2548710.
7926:
7927: FORALL J IN 1..NUM_ROWS
7928: UPDATE QA_RESULTS_INTERFACE QRI
7929: SET SEQUENCE1 = G_SEQ_TAB1(J),
7930: SEQUENCE2 = G_SEQ_TAB2(J),
7931: SEQUENCE3 = G_SEQ_TAB3(J),
7932: SEQUENCE4 = G_SEQ_TAB4(J),

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

8005: COLUMN_LIST := COLUMN_LIST || ', ' || RESULT_COLUMN_NAME_TABLE(I);
8006: VALUE_LIST := VALUE_LIST || ', ' || RESULT_COLUMN_NAME_TABLE(I);
8007: END LOOP;
8008:
8009: -- build the sql statement that transfers records into qa_results
8010:
8011: SQL_STATEMENT := 'INSERT INTO QA_RESULTS (' || COLUMN_LIST ||
8012: ') SELECT ' || VALUE_LIST || ' FROM QA_RESULTS_INTERFACE ' ||
8013: 'WHERE GROUP_ID = :GROUP_ID ' ||

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

8007: END LOOP;
8008:
8009: -- build the sql statement that transfers records into qa_results
8010:
8011: SQL_STATEMENT := 'INSERT INTO QA_RESULTS (' || COLUMN_LIST ||
8012: ') SELECT ' || VALUE_LIST || ' FROM QA_RESULTS_INTERFACE ' ||
8013: 'WHERE GROUP_ID = :GROUP_ID ' ||
8014: ' AND PROCESS_STATUS = 2';
8015:

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

8008:
8009: -- build the sql statement that transfers records into qa_results
8010:
8011: SQL_STATEMENT := 'INSERT INTO QA_RESULTS (' || COLUMN_LIST ||
8012: ') SELECT ' || VALUE_LIST || ' FROM QA_RESULTS_INTERFACE ' ||
8013: 'WHERE GROUP_ID = :GROUP_ID ' ||
8014: ' AND PROCESS_STATUS = 2';
8015:
8016: -- Bug 3136107.

Line 8070: CURSOR C IS SELECT MARKER FROM QA_RESULTS_INTERFACE

8066:
8067: STMT_OF_ROWIDS VARCHAR2(10000); -- For update capabilities.
8068: l_error_message VARCHAR2(240);
8069:
8070: CURSOR C IS SELECT MARKER FROM QA_RESULTS_INTERFACE
8071: WHERE GROUP_ID = X_GROUP_ID
8072: AND PROCESS_STATUS = 2
8073: AND MARKER IS NOT NULL;
8074:

Line 8084: UPDATE QA_RESULTS_INTERFACE

8080: X_LAST_UPDATE_LOGIN := who_last_update_login;
8081:
8082: -- update process status to 2 (running) for rows in this group
8083:
8084: UPDATE QA_RESULTS_INTERFACE
8085: SET PROCESS_STATUS = 2,
8086: REQUEST_ID = X_REQUEST_ID,
8087: LAST_UPDATE_DATE = SYSDATE,
8088: LAST_UPDATED_BY = X_USER_ID,

Line 8107: FROM QA_RESULTS_INTERFACE

8103:
8104: DELETE FROM QA_INTERFACE_ERRORS
8105: WHERE TRANSACTION_INTERFACE_ID IN
8106: (SELECT TRANSACTION_INTERFACE_ID
8107: FROM QA_RESULTS_INTERFACE
8108: WHERE GROUP_ID = X_GROUP_ID);
8109:
8110: COMMIT;
8111:

Line 8135: UPDATE QA_RESULTS_INTERFACE

8131: -- update qa_created_by and qa_last_updated_by if they are null for updates
8132:
8133: IF TYPE_OF_TXN <> 2
8134: THEN SELECT QA_COLLECTION_ID_S.NEXTVAL INTO X_COLLECTION_ID FROM DUAL;
8135: UPDATE QA_RESULTS_INTERFACE
8136: SET COLLECTION_ID = NVL(COLLECTION_ID, X_COLLECTION_ID),
8137: QA_CREATED_BY = NVL(QA_CREATED_BY, X_USER_ID),
8138: QA_LAST_UPDATED_BY = NVL(QA_LAST_UPDATED_BY, X_USER_ID)
8139: WHERE GROUP_ID = X_GROUP_ID

Line 8141: ELSE UPDATE QA_RESULTS_INTERFACE

8137: QA_CREATED_BY = NVL(QA_CREATED_BY, X_USER_ID),
8138: QA_LAST_UPDATED_BY = NVL(QA_LAST_UPDATED_BY, X_USER_ID)
8139: WHERE GROUP_ID = X_GROUP_ID
8140: AND PROCESS_STATUS = 2;
8141: ELSE UPDATE QA_RESULTS_INTERFACE
8142: SET QA_CREATED_BY = NVL(QA_CREATED_BY, X_USER_ID),
8143: QA_LAST_UPDATED_BY = NVL(QA_LAST_UPDATED_BY, X_USER_ID)
8144: WHERE GROUP_ID = X_GROUP_ID
8145: AND PROCESS_STATUS = 2;

Line 8202: UPDATE QA_RESULTS_INTERFACE

8198: END IF;
8199:
8200: -- update process status to 4 for successful rows
8201:
8202: UPDATE QA_RESULTS_INTERFACE
8203: SET PROCESS_STATUS = 4,
8204: REQUEST_ID = X_REQUEST_ID,
8205: LAST_UPDATE_DATE = SYSDATE,
8206: LAST_UPDATED_BY = X_USER_ID,

Line 8219: FROM QA_RESULTS_INTERFACE

8215:
8216: DELETE FROM QA_INTERFACE_ERRORS
8217: WHERE TRANSACTION_INTERFACE_ID IN
8218: (SELECT TRANSACTION_INTERFACE_ID
8219: FROM QA_RESULTS_INTERFACE
8220: WHERE PROCESS_STATUS = 4);
8221:
8222: -- delete all status 4 rows, not just the ones associated with the
8223: -- current group id. we delete all so that if the user changed a

Line 8228: DELETE FROM QA_RESULTS_INTERFACE WHERE PROCESS_STATUS = 4;

8224: -- record's status to 4 in the update form, it won't stay around forever.
8225: -- only delete the rows if the MRP_DEBUG profile is not set to Y.
8226:
8227: IF (NVL(X_DEBUG, 'N') <> 'Y') THEN
8228: DELETE FROM QA_RESULTS_INTERFACE WHERE PROCESS_STATUS = 4;
8229: END IF;
8230:
8231: COMMIT;
8232:

Line 8257: FROM qa_results_interface

8253: SELECT transaction_interface_id, substr(l_error_message,1, 240),
8254: g_col_name, sysdate, x_user_id, sysdate, x_user_id,
8255: x_last_update_login, x_request_id, x_program_application_id,
8256: x_program_id, sysdate
8257: FROM qa_results_interface
8258: WHERE group_id = x_group_id;
8259:
8260: UPDATE qa_results_interface
8261: SET process_status = 3

Line 8260: UPDATE qa_results_interface

8256: x_program_id, sysdate
8257: FROM qa_results_interface
8258: WHERE group_id = x_group_id;
8259:
8260: UPDATE qa_results_interface
8261: SET process_status = 3
8262: WHERE group_id = x_group_id;
8263:
8264: COMMIT;

Line 8279: FROM QA_RESULTS_INTERFACE

8275: SYSDATE, X_USER_ID,
8276: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
8277: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
8278: SYSDATE
8279: FROM QA_RESULTS_INTERFACE
8280: WHERE GROUP_ID = X_GROUP_ID;
8281:
8282: UPDATE QA_RESULTS_INTERFACE
8283: SET PROCESS_STATUS = 3

Line 8282: UPDATE QA_RESULTS_INTERFACE

8278: SYSDATE
8279: FROM QA_RESULTS_INTERFACE
8280: WHERE GROUP_ID = X_GROUP_ID;
8281:
8282: UPDATE QA_RESULTS_INTERFACE
8283: SET PROCESS_STATUS = 3
8284: WHERE GROUP_ID = X_GROUP_ID;
8285:
8286: COMMIT;

Line 8306: FROM QA_RESULTS_INTERFACE

8302:
8303: NEW_GROUP_ID NUMBER;
8304: RESULT BOOLEAN;
8305: CURSOR c1 IS SELECT rowid
8306: FROM QA_RESULTS_INTERFACE
8307: WHERE GROUP_ID = G_ID;
8308:
8309: BEGIN
8310: -- Loop through the group of update records

Line 8316: UPDATE QA_RESULTS_INTERFACE

8312: FOR rec IN c1 LOOP
8313: -- Get a new group ID to be used for the update records.
8314: SELECT QA_GROUP_S.NEXTVAL INTO NEW_GROUP_ID FROM DUAL;
8315:
8316: UPDATE QA_RESULTS_INTERFACE
8317: SET GROUP_ID = NEW_GROUP_ID
8318: WHERE rowid = rec.rowid;
8319:
8320: -- Call the old transaction worker to do the job.