[Home] [Help]
28: BEGIN
29:
30: l_res_col := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, g_esig_status_char_id);
31:
32: l_sql_string := 'UPDATE qa_results SET ' || l_res_col ||' = :1'
33: ||' WHERE plan_id = :2'
34: ||' and collection_id = :3'
35: ||' and occurrence = :4';
36:
90: -- New cursor to get result occurrences based on txn_header_id
91: -- Modified the name of the old cursor to get_results_col
92: CURSOR get_results_txn( c_txn_header_id NUMBER, c_collection_id NUMBER , c_plan_id NUMBER ) IS
93: SELECT occurrence
94: FROM QA_RESULTS
95: WHERE collection_id = c_collection_id
96: AND txn_header_id = c_txn_header_id
97: AND plan_id = c_plan_id;
98:
97: AND plan_id = c_plan_id;
98:
99: CURSOR get_results_col( c_collection_id NUMBER , c_plan_id NUMBER ) IS
100: SELECT occurrence
101: FROM QA_RESULTS
102: WHERE collection_id = c_collection_id
103: AND plan_id = c_plan_id;
104:
105: l_occurrence NUMBER;
354: -- R12 ERES Support in Service Family. Bug 4345768
355: -- START
356:
357: -- Post Operation API for updating the Approval
358: -- status of the QA Results Occurrence.
359:
360: PROCEDURE qa_occurrence_approve
361: (p_plan_id IN NUMBER,
362: p_collection_id IN NUMBER,
384:
385: END qa_occurrence_approve;
386:
387: -- Post Operation API for updating the Approval
388: -- status of the QA Results Collection.
389:
390: PROCEDURE qa_collection_approve
391: (p_plan_id IN NUMBER,
392: p_collection_id IN NUMBER
421: -- R12 ERES Support in Service Family. Bug 4345768
422:
423: -- Bug 5508639. SHKALYAN 13-Sep-2006.
424: -- Overloaded Post Operation API for updating the Approval
425: -- status of the QA Results Collection for a given txn_header_id.
426: PROCEDURE qa_collection_approve
427: (p_plan_id IN NUMBER,
428: p_collection_id IN NUMBER,
429: p_txn_header_id IN NUMBER