DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_PKG dependencies on QA_PC_PLAN_RELATIONSHIP

Line 252: qa_pc_plan_relationship qpr

248: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
249:
250: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
251: FROM qa_plans qp,
252: qa_pc_plan_relationship qpr
253: WHERE qpr.parent_plan_id = p_plan_id
254: AND qpr.child_plan_id = qp.plan_id
255: AND qpr.plan_relationship_type = 1
256: AND qpr.data_entry_mode in (1,2,3)

Line 329: qa_pc_plan_relationship qpr

325: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
326:
327: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
328: FROM qa_plans qp,
329: qa_pc_plan_relationship qpr
330: WHERE qpr.parent_plan_id = p_plan_id
331: AND qpr.child_plan_id = qp.plan_id
332: AND qpr.plan_relationship_type = 1
333: AND qpr.data_entry_mode in (1,2,3,4)

Line 479: FROM qa_pc_plan_relationship

475: -- In case of no match simply returns FALSE
476: --
477:
478: CURSOR c IS SELECT plan_relationship_id,child_plan_id
479: FROM qa_pc_plan_relationship
480: WHERE parent_plan_id = p_plan_id
481: AND plan_relationship_type = p_relationship_type
482: AND data_entry_mode = p_data_entry_mode;
483:

Line 646: FROM qa_pc_plan_relationship

642:
643:
644: CURSOR row_num_cur(c_child_plan_id NUMBER) IS
645: SELECT auto_row_count
646: FROM qa_pc_plan_relationship
647: WHERE parent_plan_id = p_plan_id
648: AND child_plan_id = c_child_plan_id;
649:
650:

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

1186: RETURN VARCHAR2 IS
1187:
1188: --
1189: -- This function intelligently finding out parent plan record when child plan record information
1190: -- is passed. First find out parent_plan_id from qa_pc_plan_relationship. Then findout all
1191: -- element ids with which parent and child plans are related. Take only those elements which have
1192: -- link_flag = 1 in qa_pc_element_relationship table.
1193:
1194: -- Find the values of the elements from qa_results for the child plan. Then find the first record

Line 1216: FROM qa_pc_plan_relationship

1212: res_cur resCurTyp; --define cursor variable
1213:
1214: CURSOR plan_cursor(p_child_plan_id NUMBER) IS
1215: SELECT plan_relationship_id,parent_plan_id
1216: FROM qa_pc_plan_relationship
1217: WHERE child_plan_id = p_child_plan_id
1218: AND rownum = 1;
1219:
1220: -- Bug 2357067. Modified the element_cursor so that all parent,child columns

Line 1229: qa_pc_plan_relationship pr,

1225: qpc1.result_column_name parent_database_column,
1226: pe.child_char_id,
1227: qpc2.result_column_name child_database_column
1228: from
1229: qa_pc_plan_relationship pr,
1230: qa_pc_element_relationship pe,
1231: qa_plan_chars qpc1,
1232: qa_plan_chars qpc2
1233: where

Line 1601: FROM qa_pc_plan_relationship

1597: l_default_parent NUMBER := -99;
1598:
1599: CURSOR default_cursor IS
1600: SELECT default_parent_spec
1601: FROM qa_pc_plan_relationship
1602: WHERE parent_plan_id = p_parent_plan_id
1603: AND child_plan_id = p_child_plan_id;
1604:
1605:

Line 1609: -- default_parent_spec column in table qa_pc_plan_relationship.

1605:
1606: BEGIN
1607:
1608: -- As of now just return true. To implement this function we should have a new field
1609: -- default_parent_spec column in table qa_pc_plan_relationship.
1610: -- Hence i am commenting out the actual implementation of this function.
1611:
1612: -- RETURN 'T';
1613:

Line 1636: FROM qa_pc_plan_relationship

1632: l_is_parent_plan VARCHAR2(1);
1633:
1634: CURSOR plan_cursor(p_plan_id NUMBER) IS
1635: SELECT 'T'
1636: FROM qa_pc_plan_relationship
1637: WHERE parent_plan_id = p_plan_id
1638: OR child_plan_id = p_plan_id
1639: AND rownum = 1;
1640: BEGIN

Line 2378: qa_pc_plan_relationship qppr

2374: WHERE qpc.plan_id = p_child_plan_id
2375: AND qpc.char_id NOT IN
2376: (SELECT child_char_id
2377: FROM qa_pc_element_relationship qper,
2378: qa_pc_plan_relationship qppr
2379: WHERE qper.plan_relationship_id = qppr.plan_relationship_id
2380: AND qppr.parent_plan_id = p_parent_plan_id
2381: AND qppr.child_plan_id = p_child_plan_id
2382: AND qppr.data_entry_mode = 2)

Line 2883: FROM qa_pc_plan_relationship

2879: p_data_entry_mode IN NUMBER) IS
2880:
2881: CURSOR plan_cur IS
2882: SELECT 1
2883: FROM qa_pc_plan_relationship
2884: WHERE parent_plan_id = p_parent_plan_id
2885: AND plan_relationship_type = p_relationship_type
2886: AND data_entry_mode = p_data_entry_mode;
2887:

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

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

Line 3027: qa_pc_plan_relationship qpr

3023: select qprr.child_plan_id,
3024: qprr.child_collection_id,
3025: qprr.child_occurrence
3026: from qa_pc_results_relationship qprr,
3027: qa_pc_plan_relationship qpr
3028: where qprr.parent_occurrence = p_parent_occurrence
3029: and qprr.parent_plan_id = p_parent_plan_id
3030: and qprr.parent_collection_id = p_parent_collection_id
3031: and qpr.parent_plan_id = qprr.parent_plan_id

Line 3095: qa_pc_plan_relationship qpr

3091: SELECT qpr.plan_relationship_id,
3092: qpr.child_plan_id,
3093: qpr.data_entry_mode
3094: FROM qa_plans qp,
3095: qa_pc_plan_relationship qpr
3096: WHERE qpr.parent_plan_id = p_plan_id
3097: AND qpr.child_plan_id = qp.plan_id
3098: AND qpr.plan_relationship_type = 1
3099: AND ((qp.effective_to IS NULL AND TRUNC(SYSDATE) >= qp.effective_from)

Line 3216: FROM qa_pc_plan_relationship

3212: p_child_plan_id IN NUMBER)
3213: RETURN NUMBER IS
3214: CURSOR c is
3215: SELECT layout_mode
3216: FROM qa_pc_plan_relationship
3217: WHERE parent_plan_id = p_parent_plan_id
3218: AND child_plan_id = p_child_plan_id;
3219:
3220: l_layout_mode NUMBER := 0;

Line 3541: FROM qa_pc_plan_relationship

3537: x_status OUT NOCOPY VARCHAR2) IS
3538:
3539: CURSOR child_check_cur(c_plan_id NUMBER) IS
3540: SELECT 'T'
3541: FROM qa_pc_plan_relationship
3542: WHERE parent_plan_id = c_plan_id
3543: AND plan_relationship_type = p_relationship_type
3544: AND data_entry_mode = p_data_entry_mode;
3545:

Line 3975: FROM qa_pc_plan_relationship

3971:
3972:
3973: CURSOR c(x_plan_id NUMBER) IS
3974: SELECT child_plan_id
3975: FROM qa_pc_plan_relationship
3976: WHERE parent_plan_id = x_plan_id
3977: AND data_entry_mode = 4;
3978:
3979: l_src_string VARCHAR2(32000);

Line 4354: qa_pc_plan_relationship qpr

4350: CURSOR cur is
4351: select 'UPDATE_CHILD_Y'
4352: from qa_pc_results_relationship qpc,
4353: qa_results qr,
4354: qa_pc_plan_relationship qpr
4355: where qpc.parent_plan_id = p_plan_id and
4356: qpc.parent_collection_id = p_collection_id and
4357: qpc.parent_occurrence = p_occurrence and
4358: qpc.child_plan_id = qr.plan_id and

Line 4423: FROM qa_pc_plan_relationship

4419:
4420: childCount NUMBER;
4421: BEGIN
4422: SELECT count(*) INTO childCount
4423: FROM qa_pc_plan_relationship
4424: WHERE parent_plan_id=p_plan_id;
4425: IF childCount > 0 THEN
4426: RETURN 1;
4427: ELSE

Line 4448: qa_pc_plan_relationship qpr

4444: select qprr.child_plan_id,
4445: qprr.child_collection_id,
4446: qprr.child_occurrence
4447: from qa_pc_results_relationship qprr,
4448: qa_pc_plan_relationship qpr
4449: where qprr.parent_occurrence = p_parent_occurrence
4450: and qprr.parent_plan_id = p_parent_plan_id
4451: and qprr.parent_collection_id = p_parent_collection_id
4452: and qpr.parent_plan_id = qprr.parent_plan_id

Line 4484: FROM qa_pc_plan_relationship qppr,

4480: BEGIN
4481: SELECT REPLACE(DECODE(QC.HARDCODED_COLUMN, NULL ,QAPC.RESULT_COLUMN_NAME,QC.DEVELOPER_NAME),
4482: 'CHARACTER','DISPLAY') FORM_FIELD
4483: BULK COLLECT INTO result_column_name_tab
4484: FROM qa_pc_plan_relationship qppr,
4485: qa_pc_criteria qpc,
4486: qa_results qr,
4487: qa_plan_chars qapc,
4488: qa_chars qc