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 FND_GLOBAL

Line 2233: /* Used to enumerate while setting FND_GLOBAL session variables */

2229:
2230: END IS_UWQ_SERVER_REQUIRED;
2231:
2232:
2233: /* Used to enumerate while setting FND_GLOBAL session variables */
2234: PROCEDURE ENUMERATE_WORK_NODES_FOR_SVR
2235: (P_RESOURCE_ID IN NUMBER
2236: ,P_USER_ID IN NUMBER
2237: ,P_RESP_ID IN NUMBER

Line 2268: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );

2264: substr(p_language, ( instr(p_language,'_',1,1) + 1 ), ( instr(p_language,'.',1,1) -
2265: instr(p_language,'_',1,1) - 1) ) || '''';
2266: execute immediate l_lang;
2267:
2268: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );
2269:
2270: ENUMERATE_WORK_NODES( P_RESOURCE_ID, '', '' );
2271:
2272: END ENUMERATE_WORK_NODES_FOR_SVR;

Line 2275: /* Used to refresh while setting FND_GLOBAL session variables */

2271:
2272: END ENUMERATE_WORK_NODES_FOR_SVR;
2273:
2274:
2275: /* Used to refresh while setting FND_GLOBAL session variables */
2276: PROCEDURE REFRESH_WORK_NODE_FOR_SVR
2277: (P_RESOURCE_ID IN NUMBER
2278: ,P_USER_ID IN NUMBER
2279: ,P_RESP_ID IN NUMBER

Line 2288: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );

2284:
2285:
2286: BEGIN
2287:
2288: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );
2289:
2290: REFRESH_WORK_NODE_COUNTS( P_RESOURCE_ID );
2291:
2292:

Line 2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;

2622: SELECT IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL INTO L_SEL_RT_NODE_ID FROM DUAL;
2623: L_RTNODE_INSERT_FLAG := 'Y';
2624: END;
2625: IF NVL(L_RTNODE_INSERT_FLAG, 'X') = 'N' THEN
2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;
2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;

Line 2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;

2624: END;
2625: IF NVL(L_RTNODE_INSERT_FLAG, 'X') = 'N' THEN
2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;
2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;

Line 2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;

2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;

Line 2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;

Line 2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;

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;
2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;

Line 2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;

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;
2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;

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 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 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 2976: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id);

2972: ,P_RESP_APPL_ID IN NUMBER
2973: ,p_node_id IN NUMBER
2974: ,x_node_id_list OUT NOCOPY varchar2) AS
2975: BEGIN
2976: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id);
2977: REFRESH_CUR_NODE_COUNTS(p_resource_id, p_node_id, x_node_id_list);
2978: END REFRESH_CUR_NODE_CNTS_FOR_SVR;
2979:
2980:

Line 3174: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);

3170: p_resource_id => p_resource_id,
3171: p_view_name => node.view_name,
3172: p_bindvallist => l_bindvallist,
3173: x_count => l_count);
3174: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);
3175:
3176: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;
3177: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;
3178:

Line 3205: x_node_id_list := x_node_id_list||l_node_id||fnd_global.local_chr(20);

3201: IEU_PVT.REF_COUNT_LIST.delete;
3202: END;
3203:
3204: i := i + 1;
3205: x_node_id_list := x_node_id_list||l_node_id||fnd_global.local_chr(20);
3206:
3207: l_count := '';
3208: IEU_PVT.REFRESH_NODE(p_node_id => l_node_id,
3209: p_node_pid => l_node_pid,

Line 3235: x_node_id_list := x_node_id_list||l_node_id||fnd_global.local_chr(20);

3231: NULL;
3232: END;
3233:
3234: elsif (l_node_id = 4000) then
3235: x_node_id_list := x_node_id_list||l_node_id||fnd_global.local_chr(20);
3236:
3237: for media_nodes in c_media_nodes
3238: loop
3239: for node in c_nodes(media_nodes.sel_enum_id, media_nodes.node_depth)

Line 3259: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);

3255: p_view_name => node.view_name,
3256: p_bindvallist => l_bindvallist,
3257: x_count => l_count);
3258:
3259: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);
3260:
3261: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;
3262: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;
3263:

Line 3351: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );

3347: ,p_node_id_string in varchar2
3348: ,x_node_id_list OUT NOCOPY varchar2)
3349: AS
3350: BEGIN
3351: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );
3352: REFRESH_SELECTIVE_NODE_COUNTS(p_resource_id, p_node_id_string, x_node_id_list);
3353: END REFRESH_SEL_NODE_CNTS_FOR_SVR;
3354:
3355:

Line 3370: temp := (instr(p_node_id_string, fnd_global.local_chr(20), 1, j));

3366: BEGIN
3367:
3368: if (length(p_node_id_string)) is not null then
3369:
3370: temp := (instr(p_node_id_string, fnd_global.local_chr(20), 1, j));
3371:
3372: if temp = 0 then
3373:
3374: current_node_id := to_number(p_node_id_string);

Line 3385: temp := (instr(p_node_id_string, fnd_global.local_chr(20), 1, j)) - l_counter;

3381: while (l_counter < length(p_node_id_string))
3382: loop
3383: i := i + 1;
3384:
3385: temp := (instr(p_node_id_string, fnd_global.local_chr(20), 1, j)) - l_counter;
3386:
3387: current_node_id := to_number(substr(p_node_id_string, l_counter, temp));
3388:
3389: IEU_PVT.REFRESH_CUR_NODE_COUNTS(p_resource_id, current_node_id, p_node_id_list);

Line 3393: l_counter := (instr(p_node_id_string, fnd_global.local_chr(20),1,j))+1;

3389: IEU_PVT.REFRESH_CUR_NODE_COUNTS(p_resource_id, current_node_id, p_node_id_list);
3390:
3391: x_node_id_list := x_node_id_list||p_node_id_list;
3392:
3393: l_counter := (instr(p_node_id_string, fnd_global.local_chr(20),1,j))+1;
3394:
3395: j := j +1;
3396: end loop;
3397: end if;

Line 3415: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );

3411: AS
3412: l_media_types EligibleMediaList;
3413: BEGIN
3414:
3415: FND_GLOBAL.APPS_INITIALIZE( p_user_id, p_resp_id, p_resp_appl_id );
3416:
3417: DETERMINE_ELIGIBLE_MEDIA_TYPES(
3418: P_RESOURCE_ID,
3419: l_media_types );