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.MST_PQ_WORKS dependencies on FND_PROFILE

Line 64: l_user NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

60: l_multi_select_temp NUMBER;
61: l_fetch_required BOOLEAN ;
62: l_changed CONSTANT VARCHAR2(4):='@<~#';
63:
64: l_user NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
65: l_insert_str VARCHAR2(200) ; --:= 'INSERT INTO MST_PERSONAL_QUERY_RESULTS ';
66: l_insert_Col VARCHAR2(200) ;
67: l_select_str VARCHAR2(2000);
68: l_executed NUMBER ;

Line 75: l_user := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

71: execution_failed EXCEPTION;
72: related_field_notfound EXCEPTION;
73: BEGIN
74: l_fetch_required := TRUE;
75: l_user := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
76: l_insert_str := 'INSERT INTO MST_PERSONAL_QUERY_RESULTS ';
77: BEGIN
78: l_delete_str := 'DELETE MST_PERSONAL_QUERY_RESULTS WHERE QUERY_ID = :P_QUERY_ID AND PLAN_ID=:P_PLAN_ID';
79: EXECUTE IMMEDIATE(l_delete_str) USING p_query_id,p_plan_id;

Line 949: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

945: l_active_flag NUMBER ; --:= 1;
946: l_delim CONSTANT VARCHAR2(1) := ',';
947: l_separator CONSTANT VARCHAR2(1):= ';';
948: l_null_str CONSTANT VARCHAR2(6) := 'NULL';
949: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
950: execution_failed EXCEPTION;
951: BEGIN
952: l_sequence := 0;
953: l_multi_select := 2; -- 1 true, 2 false

Line 955: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

951: BEGIN
952: l_sequence := 0;
953: l_multi_select := 2; -- 1 true, 2 false
954: l_active_flag := 1;
955: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
956: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
957: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
958: IF l_executed = 0 THEN
959: RAISE execution_failed;

Line 2387: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

2383: l_active_flag NUMBER ; --:= 1;
2384: l_delim CONSTANT VARCHAR2(1) := ',';
2385: l_separator CONSTANT VARCHAR2(1):= ';';
2386: l_null_str CONSTANT VARCHAR2(6) := 'NULL';
2387: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
2388: execution_failed EXCEPTION;
2389: BEGIN
2390: l_sequence := 0;
2391: l_multi_select := 2; -- 1 true, 2 false

Line 2393: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

2389: BEGIN
2390: l_sequence := 0;
2391: l_multi_select := 2; -- 1 true, 2 false
2392: l_active_flag := 1;
2393: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
2394: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
2395: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
2396: IF l_executed = 0 THEN
2397: RAISE execution_failed;

Line 2651: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

2647: l_active_flag NUMBER ; --:= 1;
2648: l_delim CONSTANT VARCHAR2(1) := ',';
2649: l_separator CONSTANT VARCHAR2(1):= ';';
2650: l_null_str CONSTANT VARCHAR2(6) := 'NULL';
2651: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
2652: execution_failed EXCEPTION;
2653: BEGIN
2654: l_sequence := 0;
2655: l_multi_select := 2; -- 1 true, 2 false

Line 2657: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

2653: BEGIN
2654: l_sequence := 0;
2655: l_multi_select := 2; -- 1 true, 2 false
2656: l_active_flag := 1;
2657: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
2658: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
2659: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
2660: IF l_executed = 0 THEN
2661: RAISE execution_failed;

Line 3814: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

3810: l_active_flag NUMBER ;--:= 1;
3811: l_delim CONSTANT VARCHAR2(1) := ',';
3812: l_separator CONSTANT VARCHAR2(1):= ';';
3813: l_null_str CONSTANT VARCHAR2(6) := 'NULL';
3814: l_userid NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3815: execution_failed EXCEPTION;
3816: BEGIN
3817: l_sequence := 0;
3818: l_multi_select := 2; -- 1 true, 2 false

Line 3820: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

3816: BEGIN
3817: l_sequence := 0;
3818: l_multi_select := 2; -- 1 true, 2 false
3819: l_active_flag := 1;
3820: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3821: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
3822: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
3823: IF l_executed = 0 THEN
3824: RAISE execution_failed;