APPS.QLTTRAWB dependencies on QA_PLANS

Line 4080: X_PLAN_NAME QA_PLANS.NAME%TYPE;

4076: STMT_OF_ROWIDS VARCHAR2(10000);
4077: MATCH_ERROR BOOLEAN;
4078: CURSOR_HANDLE INTEGER := DBMS_SQL.OPEN_CURSOR;
4079: IGNORE NUMBER;
4080: X_PLAN_NAME QA_PLANS.NAME%TYPE;
4081: MATCHING_ERROR EXCEPTION;
4082: NO_ROWIDS_ERROR EXCEPTION;
4083: MORE_THAN_ONE_ROWID_ERROR EXCEPTION;
4084:

Line 4194: FROM QA_PLANS

4190: -- do this because we must compare against user_friendly columns, not
4191: -- "_id" columns (e.g. CUSTOMER column, not CUSTOMER_ID column)
4192: SELECT NAME
4193: INTO X_PLAN_NAME
4194: FROM QA_PLANS
4195: WHERE PLAN_ID = X_PLAN_ID;
4196:
4197: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4198:

Line 4201: FROM QA_PLANS

4197: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4198:
4199: SELECT import_view_name
4200: INTO l_importviewname
4201: FROM QA_PLANS
4202: WHERE PLAN_ID = X_PLAN_ID;
4203:
4204: SELECT view_name
4205: INTO l_viewname

Line 4206: FROM QA_PLANS

4202: WHERE PLAN_ID = X_PLAN_ID;
4203:
4204: SELECT view_name
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:

Line 4212: -- and view_name which are queried up from qa_plans are used rather

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.
4214: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4215:
4216: SELECT_STMT := 'SELECT V.ROW_ID ' ||

Line 4490: X_PLAN_NAME QA_PLANS.NAME%TYPE;

4486: X_PLAN_ID NUMBER,
4487: READ_ONLY_FLAG_TABLE NUMBER_TABLE,
4488: ENABLED_FLAG_TABLE NUMBER_TABLE) IS
4489: UPDATE_STMT VARCHAR2(10000);
4490: X_PLAN_NAME QA_PLANS.NAME%TYPE;
4491:
4492: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4493: l_viewname VARCHAR2(100);
4494:

Line 4506: FROM QA_PLANS

4502: L_ROWID ROWID;
4503:
4504: BEGIN
4505: SELECT NAME INTO X_PLAN_NAME
4506: FROM QA_PLANS
4507: WHERE PLAN_ID = X_PLAN_ID;
4508:
4509: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4510:

Line 4513: FROM QA_PLANS

4509: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4510:
4511: SELECT view_name
4512: INTO l_viewname
4513: FROM QA_PLANS
4514: WHERE PLAN_ID = X_PLAN_ID;
4515:
4516:
4517: -- now that the record is stored in the PL/SQL table, populate all columns

Line 4616: -- queried up from qa_plans is used rather than simply using the

4612: END IF;
4613: END LOOP;
4614:
4615: -- Changed the UPDATE_STMT as below so that the view_name which is
4616: -- queried up from qa_plans is used rather than simply using the
4617: -- plan_name.Commented out the existing code.
4618: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4619:
4620: -- Bug 3136107.

Line 5094: FROM QA_PLANS_VAL_V QPVV

5090: QRI.TRANSACTION_INTERFACE_ID
5091: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL))
5092: AND NOT EXISTS
5093: (SELECT 'X'
5094: FROM QA_PLANS_VAL_V QPVV
5095: WHERE QRI.PLAN_NAME = QPVV.NAME
5096: AND QRI.ORGANIZATION_ID = QPVV.ORGANIZATION_ID);
5097:
5098: -- group derivation for plan_id

Line 5109: FROM QA_PLANS_VAL_V QPVV

5105: PROGRAM_ID = X_PROGRAM_ID,
5106: PROGRAM_UPDATE_DATE = SYSDATE,
5107: PLAN_ID =
5108: (SELECT MIN(QPVV.PLAN_ID)
5109: FROM QA_PLANS_VAL_V QPVV
5110: WHERE QPVV.NAME = QRI.PLAN_NAME
5111: AND QPVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID)
5112: WHERE QRI.GROUP_ID = X_GROUP_ID
5113: AND QRI.PROCESS_STATUS = 2

Line 7742: FROM QA_PLANS QP

7738: UPDATE QA_RESULTS_INTERFACE QRI
7739: SET -- plan_id
7740: PLAN_ID =
7741: (SELECT MIN(QP.PLAN_ID)
7742: FROM QA_PLANS QP
7743: WHERE QP.NAME = QRI.PLAN_NAME
7744: AND QP.ORGANIZATION_ID = QRI.ORGANIZATION_ID),
7745: -- spec_id
7746: SPEC_ID =