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.QA_PARENT_CHILD_PKG dependencies on QA_TXN_GRP

Line 267: elements qa_txn_grp.ElementsArray;

263: current_child_plan_id NUMBER;
264: p_plan_relationship_id NUMBER;
265: ret_value VARCHAR2(1);
266: childexist BOOLEAN;
267: elements qa_txn_grp.ElementsArray;
268: BEGIN
269: ret_value := 'F';
270: childexist := FALSE;
271: elements := qa_txn_grp.result_to_array(p_criteria_values);

Line 271: elements := qa_txn_grp.result_to_array(p_criteria_values);

267: elements qa_txn_grp.ElementsArray;
268: BEGIN
269: ret_value := 'F';
270: childexist := FALSE;
271: elements := qa_txn_grp.result_to_array(p_criteria_values);
272: OPEN c;
273: LOOP
274: FETCH c INTO p_plan_relationship_id,current_child_plan_id;
275: IF (c%NOTFOUND) THEN

Line 344: elements qa_txn_grp.ElementsArray;

340: current_child_plan_id NUMBER;
341: p_plan_relationship_id NUMBER;
342: ret_value VARCHAR2(1);
343: childexist BOOLEAN;
344: elements qa_txn_grp.ElementsArray;
345: BEGIN
346: ret_value := 'F';
347: childexist := FALSE;
348: elements := qa_txn_grp.result_to_array(p_criteria_values);

Line 348: elements := qa_txn_grp.result_to_array(p_criteria_values);

344: elements qa_txn_grp.ElementsArray;
345: BEGIN
346: ret_value := 'F';
347: childexist := FALSE;
348: elements := qa_txn_grp.result_to_array(p_criteria_values);
349: OPEN c;
350: LOOP
351: FETCH c INTO p_plan_relationship_id,current_child_plan_id;
352: IF (c%NOTFOUND) THEN

Line 382: p_criteria_array qa_txn_grp.ElementsArray)

378: END eval_updateview_lov_criteria;
379:
380: -----------------------------------------------------------------------------------------------------
381: FUNCTION criteria_matched(p_plan_relationship_id IN NUMBER,
382: p_criteria_array qa_txn_grp.ElementsArray)
383: RETURN VARCHAR2 IS
384:
385: ---
386: --- This function first finds out all the criteria for the parent-child

Line 505: elements qa_txn_grp.ElementsArray;

501: ret_value VARCHAR2(1);
502: childexist BOOLEAN;
503: separator CONSTANT VARCHAR2(1) := ',';
504:
505: elements qa_txn_grp.ElementsArray;
506:
507: -- Bug 2355817. kabalakr
508: l_child_pl_id NUMBER;
509:

Line 513: elements := qa_txn_grp.result_to_array(p_criteria_values);

509:
510: BEGIN
511: ret_value := 'F';
512: childexist := FALSE;
513: elements := qa_txn_grp.result_to_array(p_criteria_values);
514: OPEN c;
515: -- Get all the child plan id for the parent plan to find out any matching
516: -- childplan is exist or not.
517: LOOP

Line 627: parent_values_array qa_txn_grp.ElementsArray;

623: p_spec_id IN NUMBER,
624: x_status OUT NOCOPY VARCHAR2,
625: p_txn_header_id IN NUMBER) IS
626:
627: parent_values_array qa_txn_grp.ElementsArray;
628: l_child_id_array ChildPlanArray;
629: l_sysdate DATE;
630: l_length INTEGER;
631: l_row_count INTEGER;

Line 742: parent_values_array := qa_txn_grp.result_to_array(p_criteria_values);

738: l_count := 1;
739: l_sysdate := sysdate;
740:
741: -- flatten the p_criteria_values string into an array
742: parent_values_array := qa_txn_grp.result_to_array(p_criteria_values);
743:
744: --parse p_child_plan_ids to get child plan ids in an array
745: IF p_child_plan_ids IS NOT NULL THEN
746: l_p := 0;

Line 2102: l_bind_var qa_txn_grp.ElementsArray;

2098: -- skolluku Sun Oct 14 03:26:31 PDT 2007
2099: --
2100: -- TYPE bindTab IS TABLE OF l_value%TYPE INDEX BY BINARY_INTEGER;
2101: -- l_bind_var bindTab;
2102: l_bind_var qa_txn_grp.ElementsArray;
2103:
2104: --
2105: -- bug 6266439
2106: -- New variable to hold the name of the column

Line 2268: l_bind_var := qa_txn_grp.result_to_array(l_value);

2264: EXCEPTION
2265: WHEN OTHERS THEN RETURN 'F';
2266: END;
2267:
2268: l_bind_var := qa_txn_grp.result_to_array(l_value);
2269:
2270: l_update_clause := 'UPDATE qa_results SET ' || l_update_clause
2271: || ' WHERE plan_id= :p_child_plan_id'
2272: || ' AND collection_id= :p_child_collection_id'

Line 2286: -- an object of qa_txn_grp.ElementsArray which

2282: WHILE (l_var IS NOT NULL) LOOP
2283: --
2284: -- bug 6266477
2285: -- Replaced bind statement since, l_bind_val is
2286: -- an object of qa_txn_grp.ElementsArray which
2287: -- will have 2 fields and we are interested
2288: -- only in the value field.
2289: -- skolluku Sun Oct 14 03:26:31 PDT 2007
2290: --

Line 3111: l_elements qa_txn_grp.ElementsArray;

3107: l_data_entry_mode NUMBER;
3108: l_plan_relationship_id NUMBER;
3109: l_childexist BOOLEAN;
3110: l_return_string VARCHAR2(4000);
3111: l_elements qa_txn_grp.ElementsArray;
3112: BEGIN
3113: l_childexist := FALSE;
3114:
3115: l_elements := qa_txn_grp.result_to_array(p_criteria_values);

Line 3115: l_elements := qa_txn_grp.result_to_array(p_criteria_values);

3111: l_elements qa_txn_grp.ElementsArray;
3112: BEGIN
3113: l_childexist := FALSE;
3114:
3115: l_elements := qa_txn_grp.result_to_array(p_criteria_values);
3116: OPEN c;
3117: LOOP
3118: FETCH c INTO l_plan_relationship_id, l_child_plan_id, l_data_entry_mode;
3119: IF (c%NOTFOUND) THEN

Line 4286: plans qa_txn_grp.ElementsArray;

4282: res_col_tab res_col_tab_typ;
4283: str varchar2(32767);
4284: result_string varchar2(32767);
4285:
4286: plans qa_txn_grp.ElementsArray;
4287:
4288: cntr NUMBER;
4289: BEGIN
4290: -- Getting the list of the result_column_names from the

Line 4321: plans := qa_txn_grp.result_to_array(

4317: -- Pass the result string to the applicable_child_plans
4318: -- to get a list of applicable Child plans for the entered data
4319: -- and convert the list of plans returned as a string
4320: -- into an array
4321: plans := qa_txn_grp.result_to_array(
4322: qa_parent_child_pkg.applicable_child_plans(p_plan_id,
4323: result_string));
4324:
4325: cntr := plans.first;