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_PC_PLAN_RELATIONSHIP

Line 261: qa_pc_plan_relationship qpr

257: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
258:
259: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
260: FROM qa_plans qp,
261: qa_pc_plan_relationship qpr
262: WHERE qpr.parent_plan_id = p_plan_id
263: AND qpr.child_plan_id = qp.plan_id
264: AND qpr.plan_relationship_type = 1
265: AND qpr.data_entry_mode in (1,2,3)

Line 338: qa_pc_plan_relationship qpr

334: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
335:
336: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
337: FROM qa_plans qp,
338: qa_pc_plan_relationship qpr
339: WHERE qpr.parent_plan_id = p_plan_id
340: AND qpr.child_plan_id = qp.plan_id
341: AND qpr.plan_relationship_type = 1
342: AND qpr.data_entry_mode in (1,2,3,4)

Line 488: FROM qa_pc_plan_relationship

484: -- In case of no match simply returns FALSE
485: --
486:
487: CURSOR c IS SELECT plan_relationship_id,child_plan_id
488: FROM qa_pc_plan_relationship
489: WHERE parent_plan_id = p_plan_id
490: AND plan_relationship_type = p_relationship_type
491: AND data_entry_mode = p_data_entry_mode;
492:

Line 675: FROM qa_pc_plan_relationship

671: AND qp.plan_id = c_child_plan_id;
672:
673: CURSOR row_num_cur(c_child_plan_id NUMBER) IS
674: SELECT auto_row_count
675: FROM qa_pc_plan_relationship
676: WHERE parent_plan_id = p_plan_id
677: AND child_plan_id = c_child_plan_id;
678:
679:

Line 1263: -- is passed. First find out parent_plan_id from qa_pc_plan_relationship. Then findout all

1259: RETURN VARCHAR2 IS
1260:
1261: --
1262: -- This function intelligently finding out parent plan record when child plan record information
1263: -- is passed. First find out parent_plan_id from qa_pc_plan_relationship. Then findout all
1264: -- element ids with which parent and child plans are related. Take only those elements which have
1265: -- link_flag = 1 in qa_pc_element_relationship table.
1266:
1267: -- Find the values of the elements from qa_results for the child plan. Then find the first record

Line 1289: FROM qa_pc_plan_relationship

1285: res_cur resCurTyp; --define cursor variable
1286:
1287: CURSOR plan_cursor(p_child_plan_id NUMBER) IS
1288: SELECT plan_relationship_id,parent_plan_id
1289: FROM qa_pc_plan_relationship
1290: WHERE child_plan_id = p_child_plan_id
1291: AND rownum = 1;
1292:
1293: -- Bug 2357067. Modified the element_cursor so that all parent,child columns

Line 1302: qa_pc_plan_relationship pr,

1298: qpc1.result_column_name parent_database_column,
1299: pe.child_char_id,
1300: qpc2.result_column_name child_database_column
1301: from
1302: qa_pc_plan_relationship pr,
1303: qa_pc_element_relationship pe,
1304: qa_plan_chars qpc1,
1305: qa_plan_chars qpc2
1306: where

Line 1686: FROM qa_pc_plan_relationship

1682: l_default_parent NUMBER := -99;
1683:
1684: CURSOR default_cursor IS
1685: SELECT default_parent_spec
1686: FROM qa_pc_plan_relationship
1687: WHERE parent_plan_id = p_parent_plan_id
1688: AND child_plan_id = p_child_plan_id;
1689:
1690:

Line 1694: -- default_parent_spec column in table qa_pc_plan_relationship.

1690:
1691: BEGIN
1692:
1693: -- As of now just return true. To implement this function we should have a new field
1694: -- default_parent_spec column in table qa_pc_plan_relationship.
1695: -- Hence i am commenting out the actual implementation of this function.
1696:
1697: -- RETURN 'T';
1698:

Line 1721: FROM qa_pc_plan_relationship

1717: l_is_parent_plan VARCHAR2(1);
1718:
1719: CURSOR plan_cursor(p_plan_id NUMBER) IS
1720: SELECT 'T'
1721: FROM qa_pc_plan_relationship
1722: WHERE parent_plan_id = p_plan_id
1723: OR child_plan_id = p_plan_id
1724: AND rownum = 1;
1725: BEGIN

Line 2695: qa_pc_plan_relationship qppr

2691: WHERE qpc.plan_id = p_child_plan_id
2692: AND qpc.char_id NOT IN
2693: (SELECT child_char_id
2694: FROM qa_pc_element_relationship qper,
2695: qa_pc_plan_relationship qppr
2696: WHERE qper.plan_relationship_id = qppr.plan_relationship_id
2697: AND qppr.parent_plan_id = p_parent_plan_id
2698: AND qppr.child_plan_id = p_child_plan_id
2699: AND qppr.data_entry_mode = 2)

Line 3200: FROM qa_pc_plan_relationship

3196: p_data_entry_mode IN NUMBER) IS
3197:
3198: CURSOR plan_cur IS
3199: SELECT 1
3200: FROM qa_pc_plan_relationship
3201: WHERE parent_plan_id = p_parent_plan_id
3202: AND plan_relationship_type = p_relationship_type
3203: AND data_entry_mode = p_data_entry_mode;
3204:

Line 3335: -- I've added a new join with qa_pc_plan_relationship to ensure this does

3331: -- history records. this is incorrect as instead of just inserting a new
3332: -- record for history, all previour records are updated with new data.
3333: -- This in turn causes the audit trail to be lost thereby defeating the
3334: -- whole purpose of having history plans!
3335: -- I've added a new join with qa_pc_plan_relationship to ensure this does
3336: -- NOT happen for history plans.
3337: -- IT IS EXTREMELY IMPORTANT TO ENSURE THAT A SINGLE PAIR OF PARENT CHILD
3338: -- PLANS FORM A SINGLE RELATIONSHIP. IF NOT THAT THIS JOIN WILL FAIL !
3339: CURSOR children_cur IS

Line 3344: qa_pc_plan_relationship qpr

3340: select qprr.child_plan_id,
3341: qprr.child_collection_id,
3342: qprr.child_occurrence
3343: from qa_pc_results_relationship qprr,
3344: qa_pc_plan_relationship qpr
3345: where qprr.parent_occurrence = p_parent_occurrence
3346: and qprr.parent_plan_id = p_parent_plan_id
3347: and qprr.parent_collection_id = p_parent_collection_id
3348: and qpr.parent_plan_id = qprr.parent_plan_id

Line 3423: qa_pc_plan_relationship qpr

3419: SELECT qpr.plan_relationship_id,
3420: qpr.child_plan_id,
3421: qpr.data_entry_mode
3422: FROM qa_plans qp,
3423: qa_pc_plan_relationship qpr
3424: WHERE qpr.parent_plan_id = p_plan_id
3425: AND qpr.child_plan_id = qp.plan_id
3426: AND qpr.plan_relationship_type = 1
3427: AND ((qp.effective_to IS NULL AND TRUNC(SYSDATE) >= qp.effective_from)

Line 3580: FROM qa_pc_plan_relationship

3576: p_child_plan_id IN NUMBER)
3577: RETURN NUMBER IS
3578: CURSOR c is
3579: SELECT layout_mode
3580: FROM qa_pc_plan_relationship
3581: WHERE parent_plan_id = p_parent_plan_id
3582: AND child_plan_id = p_child_plan_id;
3583:
3584: l_layout_mode NUMBER := 0;

Line 3905: FROM qa_pc_plan_relationship

3901: x_status OUT NOCOPY VARCHAR2) IS
3902:
3903: CURSOR child_check_cur(c_plan_id NUMBER) IS
3904: SELECT 'T'
3905: FROM qa_pc_plan_relationship
3906: WHERE parent_plan_id = c_plan_id
3907: AND plan_relationship_type = p_relationship_type
3908: AND data_entry_mode = p_data_entry_mode;
3909:

Line 4339: FROM qa_pc_plan_relationship

4335:
4336:
4337: CURSOR c(x_plan_id NUMBER) IS
4338: SELECT child_plan_id
4339: FROM qa_pc_plan_relationship
4340: WHERE parent_plan_id = x_plan_id
4341: AND data_entry_mode = 4;
4342:
4343: l_src_string VARCHAR2(32000);

Line 4765: qa_pc_plan_relationship qpr

4761: CURSOR cur is
4762: select 'UPDATE_CHILD_Y'
4763: from qa_pc_results_relationship qpc,
4764: qa_results qr,
4765: qa_pc_plan_relationship qpr
4766: where qpc.parent_plan_id = p_plan_id and
4767: qpc.parent_collection_id = p_collection_id and
4768: qpc.parent_occurrence = p_occurrence and
4769: qpc.child_plan_id = qr.plan_id and

Line 4834: FROM qa_pc_plan_relationship

4830:
4831: childCount NUMBER;
4832: BEGIN
4833: SELECT count(*) INTO childCount
4834: FROM qa_pc_plan_relationship
4835: WHERE parent_plan_id=p_plan_id;
4836: IF childCount > 0 THEN
4837: RETURN 1;
4838: ELSE

Line 4859: qa_pc_plan_relationship qpr

4855: select qprr.child_plan_id,
4856: qprr.child_collection_id,
4857: qprr.child_occurrence
4858: from qa_pc_results_relationship qprr,
4859: qa_pc_plan_relationship qpr
4860: where qprr.parent_occurrence = p_parent_occurrence
4861: and qprr.parent_plan_id = p_parent_plan_id
4862: and qprr.parent_collection_id = p_parent_collection_id
4863: and qpr.parent_plan_id = qprr.parent_plan_id

Line 4895: FROM qa_pc_plan_relationship qppr,

4891: BEGIN
4892: SELECT REPLACE(DECODE(QC.HARDCODED_COLUMN, NULL ,QAPC.RESULT_COLUMN_NAME,QC.DEVELOPER_NAME),
4893: 'CHARACTER','DISPLAY') FORM_FIELD
4894: BULK COLLECT INTO result_column_name_tab
4895: FROM qa_pc_plan_relationship qppr,
4896: qa_pc_criteria qpc,
4897: qa_results qr,
4898: qa_plan_chars qapc,
4899: qa_chars qc