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.BSC_LOCKS_PVT dependencies on FND_GLOBAL

Line 1978: FND_GLOBAL.USER_ID,

1974: ) SELECT TO_CHAR(TAB_ID),
1975: l_object_type,
1976: 'W',
1977: SYSDATE,
1978: FND_GLOBAL.USER_ID,
1979: SYSDATE,
1980: FND_GLOBAL.USER_ID,
1981: SYSDATE,
1982: FND_GLOBAL.USER_ID,

Line 1980: FND_GLOBAL.USER_ID,

1976: 'W',
1977: SYSDATE,
1978: FND_GLOBAL.USER_ID,
1979: SYSDATE,
1980: FND_GLOBAL.USER_ID,
1981: SYSDATE,
1982: FND_GLOBAL.USER_ID,
1983: l_session_id
1984: FROM BSC_TABS_B;

Line 1982: FND_GLOBAL.USER_ID,

1978: FND_GLOBAL.USER_ID,
1979: SYSDATE,
1980: FND_GLOBAL.USER_ID,
1981: SYSDATE,
1982: FND_GLOBAL.USER_ID,
1983: l_session_id
1984: FROM BSC_TABS_B;
1985:
1986: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 2006: FND_GLOBAL.USER_ID,

2002: p_program_id,
2003: p_user_id,
2004: p_machine,
2005: p_terminal,
2006: FND_GLOBAL.USER_ID,
2007: SYSDATE,
2008: FND_GLOBAL.USER_ID,
2009: SYSDATE,
2010: FND_GLOBAL.USER_ID

Line 2008: FND_GLOBAL.USER_ID,

2004: p_machine,
2005: p_terminal,
2006: FND_GLOBAL.USER_ID,
2007: SYSDATE,
2008: FND_GLOBAL.USER_ID,
2009: SYSDATE,
2010: FND_GLOBAL.USER_ID
2011: FROM BSC_TABS_B;
2012:

Line 2010: FND_GLOBAL.USER_ID

2006: FND_GLOBAL.USER_ID,
2007: SYSDATE,
2008: FND_GLOBAL.USER_ID,
2009: SYSDATE,
2010: FND_GLOBAL.USER_ID
2011: FROM BSC_TABS_B;
2012:
2013: INSERT INTO BSC_OBJECT_LOCK_USERS (
2014: OBJECT_KEY,

Line 2033: FND_GLOBAL.USER_ID,

2029: p_program_id,
2030: p_user_id,
2031: p_machine,
2032: p_terminal,
2033: FND_GLOBAL.USER_ID,
2034: SYSDATE,
2035: FND_GLOBAL.USER_ID,
2036: SYSDATE,
2037: FND_GLOBAL.USER_ID

Line 2035: FND_GLOBAL.USER_ID,

2031: p_machine,
2032: p_terminal,
2033: FND_GLOBAL.USER_ID,
2034: SYSDATE,
2035: FND_GLOBAL.USER_ID,
2036: SYSDATE,
2037: FND_GLOBAL.USER_ID
2038: FROM BSC_TABS_B;
2039:

Line 2037: FND_GLOBAL.USER_ID

2033: FND_GLOBAL.USER_ID,
2034: SYSDATE,
2035: FND_GLOBAL.USER_ID,
2036: SYSDATE,
2037: FND_GLOBAL.USER_ID
2038: FROM BSC_TABS_B;
2039:
2040: EXCEPTION
2041: WHEN FND_API.G_EXC_ERROR THEN

Line 2142: FND_GLOBAL.USER_ID,

2138: ) SELECT TO_CHAR(INDICATOR),
2139: l_object_type,
2140: 'W',
2141: SYSDATE,
2142: FND_GLOBAL.USER_ID,
2143: SYSDATE,
2144: FND_GLOBAL.USER_ID,
2145: SYSDATE,
2146: FND_GLOBAL.USER_ID,

Line 2144: FND_GLOBAL.USER_ID,

2140: 'W',
2141: SYSDATE,
2142: FND_GLOBAL.USER_ID,
2143: SYSDATE,
2144: FND_GLOBAL.USER_ID,
2145: SYSDATE,
2146: FND_GLOBAL.USER_ID,
2147: l_session_id
2148: FROM BSC_KPIS_B;

Line 2146: FND_GLOBAL.USER_ID,

2142: FND_GLOBAL.USER_ID,
2143: SYSDATE,
2144: FND_GLOBAL.USER_ID,
2145: SYSDATE,
2146: FND_GLOBAL.USER_ID,
2147: l_session_id
2148: FROM BSC_KPIS_B;
2149:
2150: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 2170: FND_GLOBAL.USER_ID,

2166: p_program_id,
2167: p_user_id,
2168: p_machine,
2169: p_terminal,
2170: FND_GLOBAL.USER_ID,
2171: SYSDATE,
2172: FND_GLOBAL.USER_ID,
2173: SYSDATE,
2174: FND_GLOBAL.USER_ID

Line 2172: FND_GLOBAL.USER_ID,

2168: p_machine,
2169: p_terminal,
2170: FND_GLOBAL.USER_ID,
2171: SYSDATE,
2172: FND_GLOBAL.USER_ID,
2173: SYSDATE,
2174: FND_GLOBAL.USER_ID
2175: FROM BSC_KPIS_B;
2176:

Line 2174: FND_GLOBAL.USER_ID

2170: FND_GLOBAL.USER_ID,
2171: SYSDATE,
2172: FND_GLOBAL.USER_ID,
2173: SYSDATE,
2174: FND_GLOBAL.USER_ID
2175: FROM BSC_KPIS_B;
2176:
2177: INSERT INTO BSC_OBJECT_LOCK_USERS (
2178: OBJECT_KEY,

Line 2197: FND_GLOBAL.USER_ID,

2193: p_program_id,
2194: p_user_id,
2195: p_machine,
2196: p_terminal,
2197: FND_GLOBAL.USER_ID,
2198: SYSDATE,
2199: FND_GLOBAL.USER_ID,
2200: SYSDATE,
2201: FND_GLOBAL.USER_ID

Line 2199: FND_GLOBAL.USER_ID,

2195: p_machine,
2196: p_terminal,
2197: FND_GLOBAL.USER_ID,
2198: SYSDATE,
2199: FND_GLOBAL.USER_ID,
2200: SYSDATE,
2201: FND_GLOBAL.USER_ID
2202: FROM BSC_KPIS_B;
2203:

Line 2201: FND_GLOBAL.USER_ID

2197: FND_GLOBAL.USER_ID,
2198: SYSDATE,
2199: FND_GLOBAL.USER_ID,
2200: SYSDATE,
2201: FND_GLOBAL.USER_ID
2202: FROM BSC_KPIS_B;
2203:
2204: EXCEPTION
2205: WHEN FND_API.G_EXC_ERROR THEN

Line 2306: FND_GLOBAL.USER_ID,

2302: ) SELECT DISTINCT TO_CHAR(DIM_GROUP_ID),
2303: l_object_type,
2304: 'W',
2305: SYSDATE,
2306: FND_GLOBAL.USER_ID,
2307: SYSDATE,
2308: FND_GLOBAL.USER_ID,
2309: SYSDATE,
2310: FND_GLOBAL.USER_ID,

Line 2308: FND_GLOBAL.USER_ID,

2304: 'W',
2305: SYSDATE,
2306: FND_GLOBAL.USER_ID,
2307: SYSDATE,
2308: FND_GLOBAL.USER_ID,
2309: SYSDATE,
2310: FND_GLOBAL.USER_ID,
2311: l_session_id
2312: FROM BSC_SYS_DIM_GROUPS_TL;

Line 2310: FND_GLOBAL.USER_ID,

2306: FND_GLOBAL.USER_ID,
2307: SYSDATE,
2308: FND_GLOBAL.USER_ID,
2309: SYSDATE,
2310: FND_GLOBAL.USER_ID,
2311: l_session_id
2312: FROM BSC_SYS_DIM_GROUPS_TL;
2313:
2314: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 2334: FND_GLOBAL.USER_ID,

2330: p_program_id,
2331: p_user_id,
2332: p_machine,
2333: p_terminal,
2334: FND_GLOBAL.USER_ID,
2335: SYSDATE,
2336: FND_GLOBAL.USER_ID,
2337: SYSDATE,
2338: FND_GLOBAL.USER_ID

Line 2336: FND_GLOBAL.USER_ID,

2332: p_machine,
2333: p_terminal,
2334: FND_GLOBAL.USER_ID,
2335: SYSDATE,
2336: FND_GLOBAL.USER_ID,
2337: SYSDATE,
2338: FND_GLOBAL.USER_ID
2339: FROM BSC_SYS_DIM_GROUPS_TL;
2340:

Line 2338: FND_GLOBAL.USER_ID

2334: FND_GLOBAL.USER_ID,
2335: SYSDATE,
2336: FND_GLOBAL.USER_ID,
2337: SYSDATE,
2338: FND_GLOBAL.USER_ID
2339: FROM BSC_SYS_DIM_GROUPS_TL;
2340:
2341: INSERT INTO BSC_OBJECT_LOCK_USERS (
2342: OBJECT_KEY,

Line 2361: FND_GLOBAL.USER_ID,

2357: p_program_id,
2358: p_user_id,
2359: p_machine,
2360: p_terminal,
2361: FND_GLOBAL.USER_ID,
2362: SYSDATE,
2363: FND_GLOBAL.USER_ID,
2364: SYSDATE,
2365: FND_GLOBAL.USER_ID

Line 2363: FND_GLOBAL.USER_ID,

2359: p_machine,
2360: p_terminal,
2361: FND_GLOBAL.USER_ID,
2362: SYSDATE,
2363: FND_GLOBAL.USER_ID,
2364: SYSDATE,
2365: FND_GLOBAL.USER_ID
2366: FROM BSC_SYS_DIM_GROUPS_TL;
2367:

Line 2365: FND_GLOBAL.USER_ID

2361: FND_GLOBAL.USER_ID,
2362: SYSDATE,
2363: FND_GLOBAL.USER_ID,
2364: SYSDATE,
2365: FND_GLOBAL.USER_ID
2366: FROM BSC_SYS_DIM_GROUPS_TL;
2367:
2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN

Line 2470: FND_GLOBAL.USER_ID,

2466: ) SELECT TO_CHAR(DIM_LEVEL_ID),
2467: l_object_type,
2468: 'W',
2469: SYSDATE,
2470: FND_GLOBAL.USER_ID,
2471: SYSDATE,
2472: FND_GLOBAL.USER_ID,
2473: SYSDATE,
2474: FND_GLOBAL.USER_ID,

Line 2472: FND_GLOBAL.USER_ID,

2468: 'W',
2469: SYSDATE,
2470: FND_GLOBAL.USER_ID,
2471: SYSDATE,
2472: FND_GLOBAL.USER_ID,
2473: SYSDATE,
2474: FND_GLOBAL.USER_ID,
2475: l_session_id
2476: FROM BSC_SYS_DIM_LEVELS_B;

Line 2474: FND_GLOBAL.USER_ID,

2470: FND_GLOBAL.USER_ID,
2471: SYSDATE,
2472: FND_GLOBAL.USER_ID,
2473: SYSDATE,
2474: FND_GLOBAL.USER_ID,
2475: l_session_id
2476: FROM BSC_SYS_DIM_LEVELS_B;
2477:
2478: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 2498: FND_GLOBAL.USER_ID,

2494: p_program_id,
2495: p_user_id,
2496: p_machine,
2497: p_terminal,
2498: FND_GLOBAL.USER_ID,
2499: SYSDATE,
2500: FND_GLOBAL.USER_ID,
2501: SYSDATE,
2502: FND_GLOBAL.USER_ID

Line 2500: FND_GLOBAL.USER_ID,

2496: p_machine,
2497: p_terminal,
2498: FND_GLOBAL.USER_ID,
2499: SYSDATE,
2500: FND_GLOBAL.USER_ID,
2501: SYSDATE,
2502: FND_GLOBAL.USER_ID
2503: FROM BSC_SYS_DIM_LEVELS_B;
2504:

Line 2502: FND_GLOBAL.USER_ID

2498: FND_GLOBAL.USER_ID,
2499: SYSDATE,
2500: FND_GLOBAL.USER_ID,
2501: SYSDATE,
2502: FND_GLOBAL.USER_ID
2503: FROM BSC_SYS_DIM_LEVELS_B;
2504:
2505: INSERT INTO BSC_OBJECT_LOCK_USERS (
2506: OBJECT_KEY,

Line 2525: FND_GLOBAL.USER_ID,

2521: p_program_id,
2522: p_user_id,
2523: p_machine,
2524: p_terminal,
2525: FND_GLOBAL.USER_ID,
2526: SYSDATE,
2527: FND_GLOBAL.USER_ID,
2528: SYSDATE,
2529: FND_GLOBAL.USER_ID

Line 2527: FND_GLOBAL.USER_ID,

2523: p_machine,
2524: p_terminal,
2525: FND_GLOBAL.USER_ID,
2526: SYSDATE,
2527: FND_GLOBAL.USER_ID,
2528: SYSDATE,
2529: FND_GLOBAL.USER_ID
2530: FROM BSC_SYS_DIM_LEVELS_B;
2531:

Line 2529: FND_GLOBAL.USER_ID

2525: FND_GLOBAL.USER_ID,
2526: SYSDATE,
2527: FND_GLOBAL.USER_ID,
2528: SYSDATE,
2529: FND_GLOBAL.USER_ID
2530: FROM BSC_SYS_DIM_LEVELS_B;
2531:
2532: EXCEPTION
2533: WHEN FND_API.G_EXC_ERROR THEN

Line 2634: FND_GLOBAL.USER_ID,

2630: ) SELECT TO_CHAR(DATASET_ID),
2631: l_object_type,
2632: 'W',
2633: SYSDATE,
2634: FND_GLOBAL.USER_ID,
2635: SYSDATE,
2636: FND_GLOBAL.USER_ID,
2637: SYSDATE,
2638: FND_GLOBAL.USER_ID,

Line 2636: FND_GLOBAL.USER_ID,

2632: 'W',
2633: SYSDATE,
2634: FND_GLOBAL.USER_ID,
2635: SYSDATE,
2636: FND_GLOBAL.USER_ID,
2637: SYSDATE,
2638: FND_GLOBAL.USER_ID,
2639: l_session_id
2640: FROM BSC_SYS_DATASETS_B;

Line 2638: FND_GLOBAL.USER_ID,

2634: FND_GLOBAL.USER_ID,
2635: SYSDATE,
2636: FND_GLOBAL.USER_ID,
2637: SYSDATE,
2638: FND_GLOBAL.USER_ID,
2639: l_session_id
2640: FROM BSC_SYS_DATASETS_B;
2641:
2642: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 2662: FND_GLOBAL.USER_ID,

2658: p_program_id,
2659: p_user_id,
2660: p_machine,
2661: p_terminal,
2662: FND_GLOBAL.USER_ID,
2663: SYSDATE,
2664: FND_GLOBAL.USER_ID,
2665: SYSDATE,
2666: FND_GLOBAL.USER_ID

Line 2664: FND_GLOBAL.USER_ID,

2660: p_machine,
2661: p_terminal,
2662: FND_GLOBAL.USER_ID,
2663: SYSDATE,
2664: FND_GLOBAL.USER_ID,
2665: SYSDATE,
2666: FND_GLOBAL.USER_ID
2667: FROM BSC_SYS_DATASETS_B;
2668:

Line 2666: FND_GLOBAL.USER_ID

2662: FND_GLOBAL.USER_ID,
2663: SYSDATE,
2664: FND_GLOBAL.USER_ID,
2665: SYSDATE,
2666: FND_GLOBAL.USER_ID
2667: FROM BSC_SYS_DATASETS_B;
2668:
2669: INSERT INTO BSC_OBJECT_LOCK_USERS (
2670: OBJECT_KEY,

Line 2689: FND_GLOBAL.USER_ID,

2685: p_program_id,
2686: p_user_id,
2687: p_machine,
2688: p_terminal,
2689: FND_GLOBAL.USER_ID,
2690: SYSDATE,
2691: FND_GLOBAL.USER_ID,
2692: SYSDATE,
2693: FND_GLOBAL.USER_ID

Line 2691: FND_GLOBAL.USER_ID,

2687: p_machine,
2688: p_terminal,
2689: FND_GLOBAL.USER_ID,
2690: SYSDATE,
2691: FND_GLOBAL.USER_ID,
2692: SYSDATE,
2693: FND_GLOBAL.USER_ID
2694: FROM BSC_SYS_DATASETS_B;
2695:

Line 2693: FND_GLOBAL.USER_ID

2689: FND_GLOBAL.USER_ID,
2690: SYSDATE,
2691: FND_GLOBAL.USER_ID,
2692: SYSDATE,
2693: FND_GLOBAL.USER_ID
2694: FROM BSC_SYS_DATASETS_B;
2695:
2696: EXCEPTION
2697: WHEN FND_API.G_EXC_ERROR THEN

Line 2798: FND_GLOBAL.USER_ID,

2794: ) SELECT TO_CHAR(MEASURE_ID),
2795: l_object_type,
2796: 'W',
2797: SYSDATE,
2798: FND_GLOBAL.USER_ID,
2799: SYSDATE,
2800: FND_GLOBAL.USER_ID,
2801: SYSDATE,
2802: FND_GLOBAL.USER_ID,

Line 2800: FND_GLOBAL.USER_ID,

2796: 'W',
2797: SYSDATE,
2798: FND_GLOBAL.USER_ID,
2799: SYSDATE,
2800: FND_GLOBAL.USER_ID,
2801: SYSDATE,
2802: FND_GLOBAL.USER_ID,
2803: l_session_id
2804: FROM BSC_SYS_MEASURES;

Line 2802: FND_GLOBAL.USER_ID,

2798: FND_GLOBAL.USER_ID,
2799: SYSDATE,
2800: FND_GLOBAL.USER_ID,
2801: SYSDATE,
2802: FND_GLOBAL.USER_ID,
2803: l_session_id
2804: FROM BSC_SYS_MEASURES;
2805:
2806: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 2826: FND_GLOBAL.USER_ID,

2822: p_program_id,
2823: p_user_id,
2824: p_machine,
2825: p_terminal,
2826: FND_GLOBAL.USER_ID,
2827: SYSDATE,
2828: FND_GLOBAL.USER_ID,
2829: SYSDATE,
2830: FND_GLOBAL.USER_ID

Line 2828: FND_GLOBAL.USER_ID,

2824: p_machine,
2825: p_terminal,
2826: FND_GLOBAL.USER_ID,
2827: SYSDATE,
2828: FND_GLOBAL.USER_ID,
2829: SYSDATE,
2830: FND_GLOBAL.USER_ID
2831: FROM BSC_SYS_MEASURES;
2832:

Line 2830: FND_GLOBAL.USER_ID

2826: FND_GLOBAL.USER_ID,
2827: SYSDATE,
2828: FND_GLOBAL.USER_ID,
2829: SYSDATE,
2830: FND_GLOBAL.USER_ID
2831: FROM BSC_SYS_MEASURES;
2832:
2833: INSERT INTO BSC_OBJECT_LOCK_USERS (
2834: OBJECT_KEY,

Line 2853: FND_GLOBAL.USER_ID,

2849: p_program_id,
2850: p_user_id,
2851: p_machine,
2852: p_terminal,
2853: FND_GLOBAL.USER_ID,
2854: SYSDATE,
2855: FND_GLOBAL.USER_ID,
2856: SYSDATE,
2857: FND_GLOBAL.USER_ID

Line 2855: FND_GLOBAL.USER_ID,

2851: p_machine,
2852: p_terminal,
2853: FND_GLOBAL.USER_ID,
2854: SYSDATE,
2855: FND_GLOBAL.USER_ID,
2856: SYSDATE,
2857: FND_GLOBAL.USER_ID
2858: FROM BSC_SYS_MEASURES;
2859:

Line 2857: FND_GLOBAL.USER_ID

2853: FND_GLOBAL.USER_ID,
2854: SYSDATE,
2855: FND_GLOBAL.USER_ID,
2856: SYSDATE,
2857: FND_GLOBAL.USER_ID
2858: FROM BSC_SYS_MEASURES;
2859:
2860: EXCEPTION
2861: WHEN FND_API.G_EXC_ERROR THEN

Line 2962: FND_GLOBAL.USER_ID,

2958: ) SELECT TO_CHAR(TAB_ID)||','||TO_CHAR(TAB_VIEW_ID),
2959: l_object_type,
2960: 'W',
2961: SYSDATE,
2962: FND_GLOBAL.USER_ID,
2963: SYSDATE,
2964: FND_GLOBAL.USER_ID,
2965: SYSDATE,
2966: FND_GLOBAL.USER_ID,

Line 2964: FND_GLOBAL.USER_ID,

2960: 'W',
2961: SYSDATE,
2962: FND_GLOBAL.USER_ID,
2963: SYSDATE,
2964: FND_GLOBAL.USER_ID,
2965: SYSDATE,
2966: FND_GLOBAL.USER_ID,
2967: l_session_id
2968: FROM BSC_TAB_VIEWS_B;

Line 2966: FND_GLOBAL.USER_ID,

2962: FND_GLOBAL.USER_ID,
2963: SYSDATE,
2964: FND_GLOBAL.USER_ID,
2965: SYSDATE,
2966: FND_GLOBAL.USER_ID,
2967: l_session_id
2968: FROM BSC_TAB_VIEWS_B;
2969:
2970: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 2990: FND_GLOBAL.USER_ID,

2986: p_program_id,
2987: p_user_id,
2988: p_machine,
2989: p_terminal,
2990: FND_GLOBAL.USER_ID,
2991: SYSDATE,
2992: FND_GLOBAL.USER_ID,
2993: SYSDATE,
2994: FND_GLOBAL.USER_ID

Line 2992: FND_GLOBAL.USER_ID,

2988: p_machine,
2989: p_terminal,
2990: FND_GLOBAL.USER_ID,
2991: SYSDATE,
2992: FND_GLOBAL.USER_ID,
2993: SYSDATE,
2994: FND_GLOBAL.USER_ID
2995: FROM BSC_TAB_VIEWS_B;
2996:

Line 2994: FND_GLOBAL.USER_ID

2990: FND_GLOBAL.USER_ID,
2991: SYSDATE,
2992: FND_GLOBAL.USER_ID,
2993: SYSDATE,
2994: FND_GLOBAL.USER_ID
2995: FROM BSC_TAB_VIEWS_B;
2996:
2997: INSERT INTO BSC_OBJECT_LOCK_USERS (
2998: OBJECT_KEY,

Line 3017: FND_GLOBAL.USER_ID,

3013: p_program_id,
3014: p_user_id,
3015: p_machine,
3016: p_terminal,
3017: FND_GLOBAL.USER_ID,
3018: SYSDATE,
3019: FND_GLOBAL.USER_ID,
3020: SYSDATE,
3021: FND_GLOBAL.USER_ID

Line 3019: FND_GLOBAL.USER_ID,

3015: p_machine,
3016: p_terminal,
3017: FND_GLOBAL.USER_ID,
3018: SYSDATE,
3019: FND_GLOBAL.USER_ID,
3020: SYSDATE,
3021: FND_GLOBAL.USER_ID
3022: FROM BSC_TAB_VIEWS_B;
3023:

Line 3021: FND_GLOBAL.USER_ID

3017: FND_GLOBAL.USER_ID,
3018: SYSDATE,
3019: FND_GLOBAL.USER_ID,
3020: SYSDATE,
3021: FND_GLOBAL.USER_ID
3022: FROM BSC_TAB_VIEWS_B;
3023:
3024: EXCEPTION
3025: WHEN FND_API.G_EXC_ERROR THEN

Line 3126: FND_GLOBAL.USER_ID,

3122: ) SELECT TO_CHAR(LINK_ID),
3123: l_object_type,
3124: 'W',
3125: SYSDATE,
3126: FND_GLOBAL.USER_ID,
3127: SYSDATE,
3128: FND_GLOBAL.USER_ID,
3129: SYSDATE,
3130: FND_GLOBAL.USER_ID,

Line 3128: FND_GLOBAL.USER_ID,

3124: 'W',
3125: SYSDATE,
3126: FND_GLOBAL.USER_ID,
3127: SYSDATE,
3128: FND_GLOBAL.USER_ID,
3129: SYSDATE,
3130: FND_GLOBAL.USER_ID,
3131: l_session_id
3132: FROM BSC_TAB_VIEW_LABELS_B

Line 3130: FND_GLOBAL.USER_ID,

3126: FND_GLOBAL.USER_ID,
3127: SYSDATE,
3128: FND_GLOBAL.USER_ID,
3129: SYSDATE,
3130: FND_GLOBAL.USER_ID,
3131: l_session_id
3132: FROM BSC_TAB_VIEW_LABELS_B
3133: WHERE LABEL_TYPE = 2;
3134:

Line 3155: FND_GLOBAL.USER_ID,

3151: p_program_id,
3152: p_user_id,
3153: p_machine,
3154: p_terminal,
3155: FND_GLOBAL.USER_ID,
3156: SYSDATE,
3157: FND_GLOBAL.USER_ID,
3158: SYSDATE,
3159: FND_GLOBAL.USER_ID

Line 3157: FND_GLOBAL.USER_ID,

3153: p_machine,
3154: p_terminal,
3155: FND_GLOBAL.USER_ID,
3156: SYSDATE,
3157: FND_GLOBAL.USER_ID,
3158: SYSDATE,
3159: FND_GLOBAL.USER_ID
3160: FROM BSC_TAB_VIEW_LABELS_B
3161: WHERE LABEL_TYPE = 2;

Line 3159: FND_GLOBAL.USER_ID

3155: FND_GLOBAL.USER_ID,
3156: SYSDATE,
3157: FND_GLOBAL.USER_ID,
3158: SYSDATE,
3159: FND_GLOBAL.USER_ID
3160: FROM BSC_TAB_VIEW_LABELS_B
3161: WHERE LABEL_TYPE = 2;
3162:
3163: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 3183: FND_GLOBAL.USER_ID,

3179: p_program_id,
3180: p_user_id,
3181: p_machine,
3182: p_terminal,
3183: FND_GLOBAL.USER_ID,
3184: SYSDATE,
3185: FND_GLOBAL.USER_ID,
3186: SYSDATE,
3187: FND_GLOBAL.USER_ID

Line 3185: FND_GLOBAL.USER_ID,

3181: p_machine,
3182: p_terminal,
3183: FND_GLOBAL.USER_ID,
3184: SYSDATE,
3185: FND_GLOBAL.USER_ID,
3186: SYSDATE,
3187: FND_GLOBAL.USER_ID
3188: FROM BSC_TAB_VIEW_LABELS_B
3189: WHERE LABEL_TYPE = 2;

Line 3187: FND_GLOBAL.USER_ID

3183: FND_GLOBAL.USER_ID,
3184: SYSDATE,
3185: FND_GLOBAL.USER_ID,
3186: SYSDATE,
3187: FND_GLOBAL.USER_ID
3188: FROM BSC_TAB_VIEW_LABELS_B
3189: WHERE LABEL_TYPE = 2;
3190:
3191: EXCEPTION

Line 3293: FND_GLOBAL.USER_ID,

3289: ) SELECT TO_CHAR(PERIODICITY_ID),
3290: l_object_type,
3291: 'W',
3292: SYSDATE,
3293: FND_GLOBAL.USER_ID,
3294: SYSDATE,
3295: FND_GLOBAL.USER_ID,
3296: SYSDATE,
3297: FND_GLOBAL.USER_ID,

Line 3295: FND_GLOBAL.USER_ID,

3291: 'W',
3292: SYSDATE,
3293: FND_GLOBAL.USER_ID,
3294: SYSDATE,
3295: FND_GLOBAL.USER_ID,
3296: SYSDATE,
3297: FND_GLOBAL.USER_ID,
3298: l_session_id
3299: FROM BSC_SYS_PERIODICITIES;

Line 3297: FND_GLOBAL.USER_ID,

3293: FND_GLOBAL.USER_ID,
3294: SYSDATE,
3295: FND_GLOBAL.USER_ID,
3296: SYSDATE,
3297: FND_GLOBAL.USER_ID,
3298: l_session_id
3299: FROM BSC_SYS_PERIODICITIES;
3300:
3301: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 3321: FND_GLOBAL.USER_ID,

3317: p_program_id,
3318: p_user_id,
3319: p_machine,
3320: p_terminal,
3321: FND_GLOBAL.USER_ID,
3322: SYSDATE,
3323: FND_GLOBAL.USER_ID,
3324: SYSDATE,
3325: FND_GLOBAL.USER_ID

Line 3323: FND_GLOBAL.USER_ID,

3319: p_machine,
3320: p_terminal,
3321: FND_GLOBAL.USER_ID,
3322: SYSDATE,
3323: FND_GLOBAL.USER_ID,
3324: SYSDATE,
3325: FND_GLOBAL.USER_ID
3326: FROM BSC_SYS_PERIODICITIES;
3327:

Line 3325: FND_GLOBAL.USER_ID

3321: FND_GLOBAL.USER_ID,
3322: SYSDATE,
3323: FND_GLOBAL.USER_ID,
3324: SYSDATE,
3325: FND_GLOBAL.USER_ID
3326: FROM BSC_SYS_PERIODICITIES;
3327:
3328: INSERT INTO BSC_OBJECT_LOCK_USERS (
3329: OBJECT_KEY,

Line 3348: FND_GLOBAL.USER_ID,

3344: p_program_id,
3345: p_user_id,
3346: p_machine,
3347: p_terminal,
3348: FND_GLOBAL.USER_ID,
3349: SYSDATE,
3350: FND_GLOBAL.USER_ID,
3351: SYSDATE,
3352: FND_GLOBAL.USER_ID

Line 3350: FND_GLOBAL.USER_ID,

3346: p_machine,
3347: p_terminal,
3348: FND_GLOBAL.USER_ID,
3349: SYSDATE,
3350: FND_GLOBAL.USER_ID,
3351: SYSDATE,
3352: FND_GLOBAL.USER_ID
3353: FROM BSC_SYS_PERIODICITIES;
3354:

Line 3352: FND_GLOBAL.USER_ID

3348: FND_GLOBAL.USER_ID,
3349: SYSDATE,
3350: FND_GLOBAL.USER_ID,
3351: SYSDATE,
3352: FND_GLOBAL.USER_ID
3353: FROM BSC_SYS_PERIODICITIES;
3354:
3355: EXCEPTION
3356: WHEN FND_API.G_EXC_ERROR THEN

Line 3457: FND_GLOBAL.USER_ID,

3453: ) SELECT TO_CHAR(CALENDAR_ID),
3454: l_object_type,
3455: 'W',
3456: SYSDATE,
3457: FND_GLOBAL.USER_ID,
3458: SYSDATE,
3459: FND_GLOBAL.USER_ID,
3460: SYSDATE,
3461: FND_GLOBAL.USER_ID,

Line 3459: FND_GLOBAL.USER_ID,

3455: 'W',
3456: SYSDATE,
3457: FND_GLOBAL.USER_ID,
3458: SYSDATE,
3459: FND_GLOBAL.USER_ID,
3460: SYSDATE,
3461: FND_GLOBAL.USER_ID,
3462: l_session_id
3463: FROM BSC_SYS_CALENDARS_B;

Line 3461: FND_GLOBAL.USER_ID,

3457: FND_GLOBAL.USER_ID,
3458: SYSDATE,
3459: FND_GLOBAL.USER_ID,
3460: SYSDATE,
3461: FND_GLOBAL.USER_ID,
3462: l_session_id
3463: FROM BSC_SYS_CALENDARS_B;
3464:
3465: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 3485: FND_GLOBAL.USER_ID,

3481: p_program_id,
3482: p_user_id,
3483: p_machine,
3484: p_terminal,
3485: FND_GLOBAL.USER_ID,
3486: SYSDATE,
3487: FND_GLOBAL.USER_ID,
3488: SYSDATE,
3489: FND_GLOBAL.USER_ID

Line 3487: FND_GLOBAL.USER_ID,

3483: p_machine,
3484: p_terminal,
3485: FND_GLOBAL.USER_ID,
3486: SYSDATE,
3487: FND_GLOBAL.USER_ID,
3488: SYSDATE,
3489: FND_GLOBAL.USER_ID
3490: FROM BSC_SYS_CALENDARS_B;
3491:

Line 3489: FND_GLOBAL.USER_ID

3485: FND_GLOBAL.USER_ID,
3486: SYSDATE,
3487: FND_GLOBAL.USER_ID,
3488: SYSDATE,
3489: FND_GLOBAL.USER_ID
3490: FROM BSC_SYS_CALENDARS_B;
3491:
3492: INSERT INTO BSC_OBJECT_LOCK_USERS (
3493: OBJECT_KEY,

Line 3512: FND_GLOBAL.USER_ID,

3508: p_program_id,
3509: p_user_id,
3510: p_machine,
3511: p_terminal,
3512: FND_GLOBAL.USER_ID,
3513: SYSDATE,
3514: FND_GLOBAL.USER_ID,
3515: SYSDATE,
3516: FND_GLOBAL.USER_ID

Line 3514: FND_GLOBAL.USER_ID,

3510: p_machine,
3511: p_terminal,
3512: FND_GLOBAL.USER_ID,
3513: SYSDATE,
3514: FND_GLOBAL.USER_ID,
3515: SYSDATE,
3516: FND_GLOBAL.USER_ID
3517: FROM BSC_SYS_CALENDARS_B;
3518:

Line 3516: FND_GLOBAL.USER_ID

3512: FND_GLOBAL.USER_ID,
3513: SYSDATE,
3514: FND_GLOBAL.USER_ID,
3515: SYSDATE,
3516: FND_GLOBAL.USER_ID
3517: FROM BSC_SYS_CALENDARS_B;
3518:
3519: EXCEPTION
3520: WHEN FND_API.G_EXC_ERROR THEN

Line 3621: FND_GLOBAL.USER_ID,

3617: ) SELECT TABLE_NAME,
3618: l_object_type,
3619: 'W',
3620: SYSDATE,
3621: FND_GLOBAL.USER_ID,
3622: SYSDATE,
3623: FND_GLOBAL.USER_ID,
3624: SYSDATE,
3625: FND_GLOBAL.USER_ID,

Line 3623: FND_GLOBAL.USER_ID,

3619: 'W',
3620: SYSDATE,
3621: FND_GLOBAL.USER_ID,
3622: SYSDATE,
3623: FND_GLOBAL.USER_ID,
3624: SYSDATE,
3625: FND_GLOBAL.USER_ID,
3626: l_session_id
3627: FROM BSC_DB_TABLES;

Line 3625: FND_GLOBAL.USER_ID,

3621: FND_GLOBAL.USER_ID,
3622: SYSDATE,
3623: FND_GLOBAL.USER_ID,
3624: SYSDATE,
3625: FND_GLOBAL.USER_ID,
3626: l_session_id
3627: FROM BSC_DB_TABLES;
3628:
3629: INSERT INTO BSC_OBJECT_LOCK_USERS (

Line 3649: FND_GLOBAL.USER_ID,

3645: p_program_id,
3646: p_user_id,
3647: p_machine,
3648: p_terminal,
3649: FND_GLOBAL.USER_ID,
3650: SYSDATE,
3651: FND_GLOBAL.USER_ID,
3652: SYSDATE,
3653: FND_GLOBAL.USER_ID

Line 3651: FND_GLOBAL.USER_ID,

3647: p_machine,
3648: p_terminal,
3649: FND_GLOBAL.USER_ID,
3650: SYSDATE,
3651: FND_GLOBAL.USER_ID,
3652: SYSDATE,
3653: FND_GLOBAL.USER_ID
3654: FROM BSC_DB_TABLES;
3655:

Line 3653: FND_GLOBAL.USER_ID

3649: FND_GLOBAL.USER_ID,
3650: SYSDATE,
3651: FND_GLOBAL.USER_ID,
3652: SYSDATE,
3653: FND_GLOBAL.USER_ID
3654: FROM BSC_DB_TABLES;
3655:
3656: INSERT INTO BSC_OBJECT_LOCK_USERS (
3657: OBJECT_KEY,

Line 3676: FND_GLOBAL.USER_ID,

3672: p_program_id,
3673: p_user_id,
3674: p_machine,
3675: p_terminal,
3676: FND_GLOBAL.USER_ID,
3677: SYSDATE,
3678: FND_GLOBAL.USER_ID,
3679: SYSDATE,
3680: FND_GLOBAL.USER_ID

Line 3678: FND_GLOBAL.USER_ID,

3674: p_machine,
3675: p_terminal,
3676: FND_GLOBAL.USER_ID,
3677: SYSDATE,
3678: FND_GLOBAL.USER_ID,
3679: SYSDATE,
3680: FND_GLOBAL.USER_ID
3681: FROM BSC_DB_TABLES;
3682:

Line 3680: FND_GLOBAL.USER_ID

3676: FND_GLOBAL.USER_ID,
3677: SYSDATE,
3678: FND_GLOBAL.USER_ID,
3679: SYSDATE,
3680: FND_GLOBAL.USER_ID
3681: FROM BSC_DB_TABLES;
3682:
3683: EXCEPTION
3684: WHEN FND_API.G_EXC_ERROR THEN

Line 3765: FND_GLOBAL.USER_ID,

3761: p_object_key,
3762: p_object_type,
3763: p_lock_type,
3764: p_last_save_time,
3765: FND_GLOBAL.USER_ID,
3766: SYSDATE,
3767: FND_GLOBAL.USER_ID,
3768: SYSDATE,
3769: FND_GLOBAL.USER_ID,

Line 3767: FND_GLOBAL.USER_ID,

3763: p_lock_type,
3764: p_last_save_time,
3765: FND_GLOBAL.USER_ID,
3766: SYSDATE,
3767: FND_GLOBAL.USER_ID,
3768: SYSDATE,
3769: FND_GLOBAL.USER_ID,
3770: p_session_id
3771: );

Line 3769: FND_GLOBAL.USER_ID,

3765: FND_GLOBAL.USER_ID,
3766: SYSDATE,
3767: FND_GLOBAL.USER_ID,
3768: SYSDATE,
3769: FND_GLOBAL.USER_ID,
3770: p_session_id
3771: );
3772:
3773: EXCEPTION

Line 3925: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3921:
3922: IF (p_object_key = 'ALL' AND p_object_type = 'ALL') THEN
3923: UPDATE BSC_OBJECT_LOCKS
3924: SET LAST_SAVE_TIME = p_last_save_time,
3925: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3926: LAST_UPDATE_DATE = SYSDATE,
3927: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
3928: SESSION_ID = p_session_id
3929: WHERE p_lock_type = 'ALL'

Line 3927: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,

3923: UPDATE BSC_OBJECT_LOCKS
3924: SET LAST_SAVE_TIME = p_last_save_time,
3925: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3926: LAST_UPDATE_DATE = SYSDATE,
3927: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
3928: SESSION_ID = p_session_id
3929: WHERE p_lock_type = 'ALL'
3930: OR LOCK_TYPE = p_lock_type;
3931:

Line 3935: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3931:
3932: ELSE
3933: UPDATE BSC_OBJECT_LOCKS
3934: SET LAST_SAVE_TIME = p_last_save_time,
3935: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3936: LAST_UPDATE_DATE = SYSDATE,
3937: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
3938: SESSION_ID = p_session_id
3939: WHERE OBJECT_TYPE = p_object_type

Line 3937: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,

3933: UPDATE BSC_OBJECT_LOCKS
3934: SET LAST_SAVE_TIME = p_last_save_time,
3935: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3936: LAST_UPDATE_DATE = SYSDATE,
3937: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
3938: SESSION_ID = p_session_id
3939: WHERE OBJECT_TYPE = p_object_type
3940: AND OBJECT_KEY = p_object_key
3941: AND LOCK_TYPE = p_lock_type;

Line 4143: FND_GLOBAL.USER_ID,

4139: p_program_id,
4140: p_user_id,
4141: p_machine,
4142: p_terminal,
4143: FND_GLOBAL.USER_ID,
4144: SYSDATE,
4145: FND_GLOBAL.USER_ID,
4146: SYSDATE,
4147: FND_GLOBAL.USER_ID

Line 4145: FND_GLOBAL.USER_ID,

4141: p_machine,
4142: p_terminal,
4143: FND_GLOBAL.USER_ID,
4144: SYSDATE,
4145: FND_GLOBAL.USER_ID,
4146: SYSDATE,
4147: FND_GLOBAL.USER_ID
4148: );
4149:

Line 4147: FND_GLOBAL.USER_ID

4143: FND_GLOBAL.USER_ID,
4144: SYSDATE,
4145: FND_GLOBAL.USER_ID,
4146: SYSDATE,
4147: FND_GLOBAL.USER_ID
4148: );
4149:
4150: EXCEPTION
4151: WHEN FND_API.G_EXC_ERROR THEN

Line 4337: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

4333: SET PROGRAM_ID = p_program_id,
4334: USER_ID = p_user_id,
4335: MACHINE = p_machine,
4336: TERMINAL = p_terminal,
4337: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4338: LAST_UPDATE_DATE = SYSDATE,
4339: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4340: WHERE p_user_type = 'ALL'
4341: OR USER_TYPE = p_user_type;

Line 4339: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

4335: MACHINE = p_machine,
4336: TERMINAL = p_terminal,
4337: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4338: LAST_UPDATE_DATE = SYSDATE,
4339: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4340: WHERE p_user_type = 'ALL'
4341: OR USER_TYPE = p_user_type;
4342:
4343: ELSE

Line 4349: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

4345: SET PROGRAM_ID = p_program_id,
4346: USER_ID = p_user_id,
4347: MACHINE = p_machine,
4348: TERMINAL = p_terminal,
4349: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4350: LAST_UPDATE_DATE = SYSDATE,
4351: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4352: WHERE OBJECT_TYPE = p_object_type
4353: AND OBJECT_KEY = p_object_key

Line 4351: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

4347: MACHINE = p_machine,
4348: TERMINAL = p_terminal,
4349: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4350: LAST_UPDATE_DATE = SYSDATE,
4351: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4352: WHERE OBJECT_TYPE = p_object_type
4353: AND OBJECT_KEY = p_object_key
4354: AND USER_TYPE = p_user_type;
4355:

Line 4391: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

4387: SET PROGRAM_ID = p_program_id,
4388: USER_ID = p_user_id,
4389: MACHINE = p_machine,
4390: TERMINAL = p_terminal,
4391: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4392: LAST_UPDATE_DATE = SYSDATE,
4393: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4394: WHERE OBJECT_TYPE = p_object_type
4395: AND OBJECT_KEY = p_object_key

Line 4393: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

4389: MACHINE = p_machine,
4390: TERMINAL = p_terminal,
4391: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4392: LAST_UPDATE_DATE = SYSDATE,
4393: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4394: WHERE OBJECT_TYPE = p_object_type
4395: AND OBJECT_KEY = p_object_key
4396: AND SUBSTR(USER_TYPE,1,1) = 'L';
4397: END IF;