[Home] [Help]
32: --
33: -- bug 13990107
34: -- Setting the last update date as well
35: --
36: l_sql_string := 'UPDATE qa_results SET ' || l_res_col ||' = :1, LAST_UPDATE_DATE=SYSDATE, QA_LAST_UPDATE_DATE=SYSDATE '
37: ||' WHERE plan_id = :2'
38: ||' and collection_id = :3'
39: ||' and occurrence = :4';
40:
94: -- New cursor to get result occurrences based on txn_header_id
95: -- Modified the name of the old cursor to get_results_col
96: CURSOR get_results_txn( c_txn_header_id NUMBER, c_collection_id NUMBER , c_plan_id NUMBER ) IS
97: SELECT occurrence
98: FROM QA_RESULTS
99: WHERE collection_id = c_collection_id
100: AND txn_header_id = c_txn_header_id
101: AND plan_id = c_plan_id;
102:
101: AND plan_id = c_plan_id;
102:
103: CURSOR get_results_col( c_collection_id NUMBER , c_plan_id NUMBER ) IS
104: SELECT occurrence
105: FROM QA_RESULTS
106: WHERE collection_id = c_collection_id
107: AND plan_id = c_plan_id;
108:
109: l_occurrence NUMBER;
358: -- R12 ERES Support in Service Family. Bug 4345768
359: -- START
360:
361: -- Post Operation API for updating the Approval
362: -- status of the QA Results Occurrence.
363:
364: PROCEDURE qa_occurrence_approve
365: (p_plan_id IN NUMBER,
366: p_collection_id IN NUMBER,
388:
389: END qa_occurrence_approve;
390:
391: -- Post Operation API for updating the Approval
392: -- status of the QA Results Collection.
393:
394: PROCEDURE qa_collection_approve
395: (p_plan_id IN NUMBER,
396: p_collection_id IN NUMBER
425: -- R12 ERES Support in Service Family. Bug 4345768
426:
427: -- Bug 5508639. SHKALYAN 13-Sep-2006.
428: -- Overloaded Post Operation API for updating the Approval
429: -- status of the QA Results Collection for a given txn_header_id.
430: PROCEDURE qa_collection_approve
431: (p_plan_id IN NUMBER,
432: p_collection_id IN NUMBER,
433: p_txn_header_id IN NUMBER