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_PARENT_CHILD_PKG

Line 1: PACKAGE BODY QA_PARENT_CHILD_PKG as

1: PACKAGE BODY QA_PARENT_CHILD_PKG as
2: /* $Header: qapcb.pls 120.26.12010000.2 2008/09/26 13:43:11 pdube ship $ */
3:
4: -- Bug 4343758
5: -- R12 OAF Txn Integration Project

Line 8: g_pkg_name CONSTANT VARCHAR2(30) := 'QA_PARENT_CHILD_PKG';

4: -- Bug 4343758
5: -- R12 OAF Txn Integration Project
6: -- Standard Global variable
7: -- shkalyan 05/07/2005.
8: g_pkg_name CONSTANT VARCHAR2(30) := 'QA_PARENT_CHILD_PKG';
9:
10: --
11: -- Through out this package all the functions will return 'T' or 'F'
12: -- instead of 'TRUE' or 'FALSE'. The reason is, we may call this

Line 1471: l_ret_value := QA_PARENT_CHILD_PKG.update_parent(p_parent_plan_id ,

1467: -- In case of the OAF application, the COMMIT that is
1468: -- executed in the aggregate_parent must not be called
1469: -- ntungare
1470: --
1471: l_ret_value := QA_PARENT_CHILD_PKG.update_parent(p_parent_plan_id ,
1472: p_parent_collection_id ,
1473: p_parent_occurrence,
1474: p_child_plan_id,
1475: p_child_collection_id ,

Line 1486: l_ret_value:= QA_PARENT_CHILD_PKG.update_child(p_parent_plan_id ,

1482: --
1483: x_agg_elements := agg_elements;
1484: x_agg_val := agg_val;
1485:
1486: l_ret_value:= QA_PARENT_CHILD_PKG.update_child(p_parent_plan_id ,
1487: p_parent_collection_id ,
1488: p_parent_occurrence,
1489: p_child_plan_id,
1490: p_child_collection_id ,

Line 2072: FUNCTION perform_child_update(p_parentchild_element_tab IN QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type,

2068: -- it can be used in common by function
2069: -- update_sequence_Child
2070: -- nutngare Wed Mar 8 09:00:46 PST 2006
2071: --
2072: FUNCTION perform_child_update(p_parentchild_element_tab IN QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type,
2073: p_parent_plan_id IN NUMBER,
2074: p_parent_collection_id IN NUMBER,
2075: p_parent_occurrence IN NUMBER,
2076: p_child_plan_id IN NUMBER,

Line 2393: l_element_cursor_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;

2389:
2390:
2391: -- 5114865
2392: -- Collection to hold the PC relationship elements
2393: l_element_cursor_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;
2394:
2395: -- Counter for the PC elements
2396: l_element_cntr PLS_INTEGER := 1;
2397:

Line 2443: p_parent_elements_tab IN QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type,

2439: --
2440: FUNCTION get_seq_rel_elements (p_parent_plan_id IN NUMBER,
2441: p_child_plan_id IN NUMBER,
2442: p_topmostRel_flag IN BOOLEAN,
2443: p_parent_elements_tab IN QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type,
2444: p_elements_tab OUT NOCOPY QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type)
2445:
2446: RETURN BOOLEAN AS
2447:

Line 2444: p_elements_tab OUT NOCOPY QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type)

2440: FUNCTION get_seq_rel_elements (p_parent_plan_id IN NUMBER,
2441: p_child_plan_id IN NUMBER,
2442: p_topmostRel_flag IN BOOLEAN,
2443: p_parent_elements_tab IN QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type,
2444: p_elements_tab OUT NOCOPY QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type)
2445:
2446: RETURN BOOLEAN AS
2447:
2448: l_parent_datatype NUMBER;

Line 2533: PROCEDURE get_parent_elementscopied(p_parentchild_Tab IN QA_PARENT_CHILD_PKG.ParentChildTabTyp,

2529: -- The elements those have been copied at every level
2530: -- are stored in the Collection nested in p_parentchild_Tab
2531: -- ntungare Wed Mar 22 01:14:24 PST 2006
2532: --
2533: PROCEDURE get_parent_elementscopied(p_parentchild_Tab IN QA_PARENT_CHILD_PKG.ParentChildTabTyp,
2534: p_current_plan_id IN NUMBER,
2535: p_parent_elements_tab OUT NOCOPY QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type)
2536: AS
2537: BEGIN

Line 2535: p_parent_elements_tab OUT NOCOPY QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type)

2531: -- ntungare Wed Mar 22 01:14:24 PST 2006
2532: --
2533: PROCEDURE get_parent_elementscopied(p_parentchild_Tab IN QA_PARENT_CHILD_PKG.ParentChildTabTyp,
2534: p_current_plan_id IN NUMBER,
2535: p_parent_elements_tab OUT NOCOPY QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type)
2536: AS
2537: BEGIN
2538: -- Looping through all the P-C relations
2539: -- Till we reach a level where the Plan Id passed

Line 2564: FUNCTION update_sequence_child(p_ParentChild_Tab IN QA_PARENT_CHILD_PKG.ParentChildTabTyp)

2560: -- only when the source element in the Parent plan is of the
2561: -- Sequence Type and that in the child is of the Char Type
2562: -- ntungare Wed Mar 22 01:15:26 PST 2006
2563: --
2564: FUNCTION update_sequence_child(p_ParentChild_Tab IN QA_PARENT_CHILD_PKG.ParentChildTabTyp)
2565: RETURN VARCHAR2 IS
2566:
2567: Type Num_tab_Typ is table of NUMBER INDEX BY BINARY_INTEGER;
2568: parentCol_DataType_Tab Num_tab_Typ;

Line 2571: l_ParentChild_Tab QA_PARENT_CHILD_PKG.ParentChildTabTyp;

2567: Type Num_tab_Typ is table of NUMBER INDEX BY BINARY_INTEGER;
2568: parentCol_DataType_Tab Num_tab_Typ;
2569: parentwithSeq_flag BOOLEAN;
2570:
2571: l_ParentChild_Tab QA_PARENT_CHILD_PKG.ParentChildTabTyp;
2572: l_elements_toprocess_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;
2573: l_parent_elements_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;
2574:
2575: l_ret_val VARCHAR2(10);

Line 2572: l_elements_toprocess_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;

2568: parentCol_DataType_Tab Num_tab_Typ;
2569: parentwithSeq_flag BOOLEAN;
2570:
2571: l_ParentChild_Tab QA_PARENT_CHILD_PKG.ParentChildTabTyp;
2572: l_elements_toprocess_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;
2573: l_parent_elements_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;
2574:
2575: l_ret_val VARCHAR2(10);
2576:

Line 2573: l_parent_elements_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;

2569: parentwithSeq_flag BOOLEAN;
2570:
2571: l_ParentChild_Tab QA_PARENT_CHILD_PKG.ParentChildTabTyp;
2572: l_elements_toprocess_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;
2573: l_parent_elements_tab QA_PARENT_CHILD_PKG.g_parentchild_elementtab_type;
2574:
2575: l_ret_val VARCHAR2(10);
2576:
2577: l_element_cntr PLS_INTEGER := 1;

Line 2908: IF(QA_PARENT_CHILD_PKG.is_parent_child_plan(p_parent_plan_id ) = 'F') THEN

2904: l_child_txn_header_id NUMBER;
2905: l_fire_action BOOLEAN := FALSE;
2906:
2907: BEGIN
2908: IF(QA_PARENT_CHILD_PKG.is_parent_child_plan(p_parent_plan_id ) = 'F') THEN
2909: -- don't do anything
2910: RETURN;
2911: END IF;
2912: OPEN plan_cur;

Line 3123: IF (qa_parent_child_pkg.criteria_matched(l_plan_relationship_id,

3119: IF (c%NOTFOUND) THEN
3120: EXIT;
3121: END IF;
3122:
3123: IF (qa_parent_child_pkg.criteria_matched(l_plan_relationship_id,
3124: l_elements) = 'T') THEN
3125: IF (l_childexist) THEN
3126: l_return_string := l_return_string || l_separator
3127: || l_child_plan_id || l_subseparator

Line 4181: IF ( QA_PARENT_CHILD_PKG.get_ancestors(

4177:
4178: BEGIN
4179: -- Calling the function get_ancestors to get a
4180: -- List of the Ancestors if they exist
4181: IF ( QA_PARENT_CHILD_PKG.get_ancestors(
4182: p_parent_plan_id,
4183: p_parent_occurrence,
4184: p_parent_collection_id,
4185: l_parent_plan_id_tab,

Line 4205: IF(QA_PARENT_CHILD_PKG.update_parent

4201: l_current_parent_occrid := l_parent_occurrence_tab(ancestors_cntr);
4202:
4203: -- Calling the procedure to check for aggregate relationships
4204: -- and do the agrregation
4205: IF(QA_PARENT_CHILD_PKG.update_parent
4206: (l_current_parent_planid,
4207: l_current_parent_collid,
4208: l_current_parent_occrid,
4209: l_current_child_planid,

Line 4322: qa_parent_child_pkg.applicable_child_plans(p_plan_id,

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;
4326:

Line 4516: END QA_PARENT_CHILD_PKG;

4512: RAISE;
4513: RETURN result_column_name_tab;
4514: END IF_CHILD_RECORD_EXISTS;
4515:
4516: END QA_PARENT_CHILD_PKG;