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.IEU_PVT dependencies on IEU_UWQ_RTNODE_BIND_VALS

Line 5: IEU_UWQ_RTNODE_BIND_VALS_LIST IEU_UWQ_RTNODE_BIND_VALS_TAB;

1: PACKAGE BODY IEU_PVT AS
2: /* $Header: IEU_VB.pls 120.4.12010000.4 2008/10/24 09:57:47 majha ship $ */
3:
4: IEU_UWQ_SEL_RT_NODES_LIST IEU_UWQ_SEL_RT_NODES_TAB;
5: IEU_UWQ_RTNODE_BIND_VALS_LIST IEU_UWQ_RTNODE_BIND_VALS_TAB;
6:
7: SEL_RT_NODE_ID_LIST NUMBER_TAB;
8: CREATED_BY_LIST NUMBER_TAB;
9: CREATION_DATE_LIST DATE_TAB;

Line 717: UPDATE IEU_UWQ_RTNODE_BIND_VALS

713: UPDATE IEU_UWQ_SEL_RT_NODES
714: SET not_valid = 'Y'
715: WHERE resource_id = P_RESOURCE_ID;
716:
717: UPDATE IEU_UWQ_RTNODE_BIND_VALS
718: SET not_valid_flag = 'Y'
719: WHERE resource_id = P_RESOURCE_ID;
720:
721: --

Line 986: ieu_uwq_rtnode_bind_vals rt_nodes_bind_val

982: rt_nodes_bind_val.node_id,
983: rt_nodes_bind_val.BIND_VAR_NAME,
984: rt_nodes_bind_val.bind_var_value
985: FROM
986: ieu_uwq_rtnode_bind_vals rt_nodes_bind_val
987: WHERE
988: (rt_nodes_bind_val.resource_id = p_resource_id) AND
989: (rt_nodes_bind_val.node_id > 0) AND
990: (rt_nodes_bind_val.not_valid_flag = 'N');

Line 2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET

2443: END IF;
2444:
2445: IF IEU_PVT.BIND_VAR_NAME_LIST.FIRST IS NOT NULL THEN
2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS
2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET
2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),

Line 2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN

2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;

Line 2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS

2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2477: END IF;

Line 2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);

2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2477: END IF;
2478: -- COMMIT;

Line 2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;

2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2477: END IF;
2478: -- COMMIT;
2479:
2480: EXCEPTION

Line 2518: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;

2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2517:
2518: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2519:
2520: RAISE;
2521: END;
2522:

Line 2562: l_bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE;

2558:
2559: l_curr_node_id PLS_INTEGER;
2560: i PLS_INTEGER;
2561: l_sel_rt_node_id ieu_uwq_sel_rt_nodes.sel_rt_node_id%type;
2562: l_bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE;
2563: L_BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE;
2564: L_BIND_VAR_DATA_TYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE;
2565: tempString varchar2(2000);
2566: l_counter number;

Line 2563: L_BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE;

2559: l_curr_node_id PLS_INTEGER;
2560: i PLS_INTEGER;
2561: l_sel_rt_node_id ieu_uwq_sel_rt_nodes.sel_rt_node_id%type;
2562: l_bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE;
2563: L_BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE;
2564: L_BIND_VAR_DATA_TYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE;
2565: tempString varchar2(2000);
2566: l_counter number;
2567: j NUMBER;

Line 2564: L_BIND_VAR_DATA_TYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE;

2560: i PLS_INTEGER;
2561: l_sel_rt_node_id ieu_uwq_sel_rt_nodes.sel_rt_node_id%type;
2562: l_bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE;
2563: L_BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE;
2564: L_BIND_VAR_DATA_TYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE;
2565: tempString varchar2(2000);
2566: l_counter number;
2567: j NUMBER;
2568: k NUMBER;

Line 2586: -- insert or update IEU_UWQ_RTNODE_BIND_VALS

2582: l_curr_node_id := p_curr_node_id;
2583:
2584: loop
2585: /*
2586: -- insert or update IEU_UWQ_RTNODE_BIND_VALS
2587: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (
2588: X_RESOURCE_ID => p_resource_id,
2589: X_SEL_ENUM_ID => p_s_enum_id,
2590: X_NODE_ID => l_curr_node_id,

Line 2679: -- Bind Variables are inserted into IEU_UWQ_RTNODE_BIND_VALS

2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;
2676: IEU_PVT.L_RT_NODES_ITR := IEU_PVT.L_RT_NODES_ITR + 1;
2677: END IF;
2678:
2679: -- Bind Variables are inserted into IEU_UWQ_RTNODE_BIND_VALS
2680: -- based on sel_rt_node_id. So select sel_node_id from
2681: -- ieu_uwq_sel_rt_nodes based on resource_id and node_id.
2682: /*
2683: select

Line 2695: -- into IEU_UWQ_RTNODE_BIND_VALS

2691: NODE_ID = l_curr_node_id;
2692: */
2693:
2694: -- Parse the bind_var list and insert the bind names, values and types
2695: -- into IEU_UWQ_RTNODE_BIND_VALS
2696: -- Bind_var list is passed as
2697:
2698: j:= 1;
2699: l_counter := 1;

Line 2741: -- insert or update IEU_UWQ_RTNODE_BIND_VALS

2737: l_counter := instr(P_ENUM_REC_LIST(i).BIND_VARS, '>',1,j);
2738: j := j+1;
2739:
2740: /*
2741: -- insert or update IEU_UWQ_RTNODE_BIND_VALS
2742: IEU_UWQ_RTNODE_BIND_VAL_PKG.LOAD_ROW (
2743: P_RESOURCE_ID => P_RESOURCE_ID,
2744: P_NODE_ID => L_CURR_NODE_ID,
2745: P_SEL_RT_NODE_ID => L_SEL_RT_NODE_ID,

Line 2757: from ieu_uwq_rtnode_bind_vals

2753: L_RTNODE_BIND_VAR_ID := '';
2754: BEGIN
2755: select rtnode_bind_var_id
2756: into l_rtnode_bind_var_id
2757: from ieu_uwq_rtnode_bind_vals
2758: where RESOURCE_ID = P_RESOURCE_ID
2759: and NODE_ID = l_curr_node_id
2760: and BIND_VAR_NAME = L_BIND_VAR_NAME;
2761:

Line 2765: SELECT IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL INTO L_RTNODE_BIND_VAR_ID FROM DUAL;

2761:
2762: L_BINDVALS_INSERT_FLAG := 'N';
2763: EXCEPTION
2764: WHEN NO_DATA_FOUND THEN
2765: SELECT IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL INTO L_RTNODE_BIND_VAR_ID FROM DUAL;
2766: L_BINDVALS_INSERT_FLAG := 'Y';
2767: END;
2768: IF NVL(L_BINDVALS_INSERT_FLAG, 'X') = 'N' THEN
2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;

Line 2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;

2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;

2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;

Line 2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;

2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;

2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;

Line 2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;

Line 2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;

2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;

Line 2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;

Line 2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;

2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;

Line 2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;

2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;

Line 2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;

2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;

Line 2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;

2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;

Line 2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;

2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;

Line 2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;

2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;
2797: END IF;

Line 2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;

2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;
2797: END IF;
2798: END LOOP;

Line 2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;

2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;
2797: END IF;
2798: END LOOP;
2799: END IF;

Line 3076: ieu_uwq_rtnode_bind_vals rt_nodes_bind_val

3072: rt_nodes_bind_val.node_id,
3073: rt_nodes_bind_val.BIND_VAR_NAME,
3074: rt_nodes_bind_val.bind_var_value
3075: FROM
3076: ieu_uwq_rtnode_bind_vals rt_nodes_bind_val
3077: WHERE
3078: (rt_nodes_bind_val.resource_id = p_resource_id) AND
3079: (rt_nodes_bind_val.node_id > 0) AND
3080: (rt_nodes_bind_val.not_valid_flag = 'N');