APPS.QLTTRAWB dependencies on QA_PLANS

Line 4361: X_PLAN_NAME QA_PLANS.NAME%TYPE;

4357: STMT_OF_ROWIDS VARCHAR2(10000);
4358: MATCH_ERROR BOOLEAN;
4359: CURSOR_HANDLE INTEGER := DBMS_SQL.OPEN_CURSOR;
4360: IGNORE NUMBER;
4361: X_PLAN_NAME QA_PLANS.NAME%TYPE;
4362: MATCHING_ERROR EXCEPTION;
4363: NO_ROWIDS_ERROR EXCEPTION;
4364: MORE_THAN_ONE_ROWID_ERROR EXCEPTION;
4365:

Line 4480: FROM QA_PLANS

4476: -- do this because we must compare against user_friendly columns, not
4477: -- "_id" columns (e.g. CUSTOMER column, not CUSTOMER_ID column)
4478: SELECT NAME
4479: INTO X_PLAN_NAME
4480: FROM QA_PLANS
4481: WHERE PLAN_ID = X_PLAN_ID;
4482:
4483: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4484:

Line 4487: FROM QA_PLANS

4483: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4484:
4485: SELECT import_view_name
4486: INTO l_importviewname
4487: FROM QA_PLANS
4488: WHERE PLAN_ID = X_PLAN_ID;
4489:
4490: SELECT view_name
4491: INTO l_viewname

Line 4492: FROM QA_PLANS

4488: WHERE PLAN_ID = X_PLAN_ID;
4489:
4490: SELECT view_name
4491: INTO l_viewname
4492: FROM QA_PLANS
4493: WHERE PLAN_ID = X_PLAN_ID;
4494:
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);

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

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

Line 4801: X_PLAN_NAME QA_PLANS.NAME%TYPE;

4797: X_PLAN_ID NUMBER,
4798: READ_ONLY_FLAG_TABLE NUMBER_TABLE,
4799: ENABLED_FLAG_TABLE NUMBER_TABLE) IS
4800: UPDATE_STMT VARCHAR2(10000);
4801: X_PLAN_NAME QA_PLANS.NAME%TYPE;
4802:
4803: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4804: l_viewname VARCHAR2(100);
4805:

Line 4820: FROM QA_PLANS

4816: QLTTRAMB.qa_import_log('----------------------------------');
4817: QLTTRAMB.qa_import_log('Start of procedure RETRIEVE_UPDATE_RECORDS');
4818:
4819: SELECT NAME INTO X_PLAN_NAME
4820: FROM QA_PLANS
4821: WHERE PLAN_ID = X_PLAN_ID;
4822:
4823: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4824:

Line 4827: FROM QA_PLANS

4823: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4824:
4825: SELECT view_name
4826: INTO l_viewname
4827: FROM QA_PLANS
4828: WHERE PLAN_ID = X_PLAN_ID;
4829:
4830:
4831: -- now that the record is stored in the PL/SQL table, populate all columns

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

4928: END IF;
4929: END LOOP;
4930:
4931: -- Changed the UPDATE_STMT as below so that the view_name which is
4932: -- queried up from qa_plans is used rather than simply using the
4933: -- plan_name.Commented out the existing code.
4934: -- Bug 2943732.suramasw.Tue May 27 07:56:48 PDT 2003.
4935:
4936: -- Bug 3136107.

Line 5442: FROM QA_PLANS_VAL_V QPVV

5438: QRI.TRANSACTION_INTERFACE_ID
5439: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL))
5440: AND NOT EXISTS
5441: (SELECT 'X'
5442: FROM QA_PLANS_VAL_V QPVV
5443: WHERE QRI.PLAN_NAME = QPVV.NAME
5444: AND QRI.ORGANIZATION_ID = QPVV.ORGANIZATION_ID);
5445:
5446: If (sql%rowcount >0) THEN

Line 5461: FROM QA_PLANS_VAL_V QPVV

5457: PROGRAM_ID = X_PROGRAM_ID,
5458: PROGRAM_UPDATE_DATE = SYSDATE,
5459: PLAN_ID =
5460: (SELECT MIN(QPVV.PLAN_ID)
5461: FROM QA_PLANS_VAL_V QPVV
5462: WHERE QPVV.NAME = QRI.PLAN_NAME
5463: AND QPVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID)
5464: WHERE QRI.GROUP_ID = X_GROUP_ID
5465: AND QRI.PROCESS_STATUS = 2

Line 8258: FROM QA_PLANS QP

8254: UPDATE QA_RESULTS_INTERFACE QRI
8255: SET -- plan_id
8256: PLAN_ID =
8257: (SELECT MIN(QP.PLAN_ID)
8258: FROM QA_PLANS QP
8259: WHERE QP.NAME = QRI.PLAN_NAME
8260: AND QP.ORGANIZATION_ID = QRI.ORGANIZATION_ID),
8261: -- spec_id
8262: SPEC_ID =