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

Line 111: okc_debug.Log('25: User ID : '||fnd_global.user_id,2);

107: CLOSE csr_sessionid;
108:
109: IF (l_debug = 'Y') THEN
110: okc_debug.Log('25: Session ID : '||l_sessionid,2);
111: okc_debug.Log('25: User ID : '||fnd_global.user_id,2);
112: okc_debug.Log('25: Conc Req ID : '||fnd_global.conc_request_id,2);
113: END IF;
114:
115: -- log session details

Line 112: okc_debug.Log('25: Conc Req ID : '||fnd_global.conc_request_id,2);

108:
109: IF (l_debug = 'Y') THEN
110: okc_debug.Log('25: Session ID : '||l_sessionid,2);
111: okc_debug.Log('25: User ID : '||fnd_global.user_id,2);
112: okc_debug.Log('25: Conc Req ID : '||fnd_global.conc_request_id,2);
113: END IF;
114:
115: -- log session details
116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');

Line 118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);

114:
115: -- log session details
116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');

Line 119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);

115: -- log session details
116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');
123:

Line 202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||

198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');
204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
205: fnd_file.put_line(FND_FILE.LOG,' ');
206: fnd_file.put_line(FND_FILE.LOG,' ');

Line 304: fnd_global.conc_request_id,

300: sysdate,
301: 'N',
302: NULL,
303: NULL,
304: fnd_global.conc_request_id,
305: fnd_global.user_id,
306: fnd_global.user_id,
307: fnd_global.conc_login_id
308: );

Line 305: fnd_global.user_id,

301: 'N',
302: NULL,
303: NULL,
304: fnd_global.conc_request_id,
305: fnd_global.user_id,
306: fnd_global.user_id,
307: fnd_global.conc_login_id
308: );
309:

Line 306: fnd_global.user_id,

302: NULL,
303: NULL,
304: fnd_global.conc_request_id,
305: fnd_global.user_id,
306: fnd_global.user_id,
307: fnd_global.conc_login_id
308: );
309:
310: -- commit the record

Line 307: fnd_global.conc_login_id

303: NULL,
304: fnd_global.conc_request_id,
305: fnd_global.user_id,
306: fnd_global.user_id,
307: fnd_global.conc_login_id
308: );
309:
310: -- commit the record
311: commit;

Line 446: fnd_global.conc_request_id,

442: sysdate,
443: 'P',
444: p_category_code,
445: NULL,
446: fnd_global.conc_request_id,
447: fnd_global.user_id,
448: fnd_global.user_id,
449: fnd_global.conc_login_id
450: );

Line 447: fnd_global.user_id,

443: 'P',
444: p_category_code,
445: NULL,
446: fnd_global.conc_request_id,
447: fnd_global.user_id,
448: fnd_global.user_id,
449: fnd_global.conc_login_id
450: );
451:

Line 448: fnd_global.user_id,

444: p_category_code,
445: NULL,
446: fnd_global.conc_request_id,
447: fnd_global.user_id,
448: fnd_global.user_id,
449: fnd_global.conc_login_id
450: );
451:
452: -- commit the record

Line 449: fnd_global.conc_login_id

445: NULL,
446: fnd_global.conc_request_id,
447: fnd_global.user_id,
448: fnd_global.user_id,
449: fnd_global.conc_login_id
450: );
451:
452: -- commit the record
453: commit;

Line 979: program_application_id = fnd_global.prog_appl_id,

975: last_update_date = sysdate ,
976: line_list_price = l_line_list_price_tbl(j),
977: price_list_id = l_price_list_tbl(j),
978: item_to_price_yn = l_itm_to_price_tbl(j),
979: program_application_id = fnd_global.prog_appl_id,
980: program_id = fnd_global.conc_program_id,
981: program_update_date = sysdate,
982: request_id = fnd_global.conc_request_id,
983: pricing_date = sysdate

Line 980: program_id = fnd_global.conc_program_id,

976: line_list_price = l_line_list_price_tbl(j),
977: price_list_id = l_price_list_tbl(j),
978: item_to_price_yn = l_itm_to_price_tbl(j),
979: program_application_id = fnd_global.prog_appl_id,
980: program_id = fnd_global.conc_program_id,
981: program_update_date = sysdate,
982: request_id = fnd_global.conc_request_id,
983: pricing_date = sysdate
984: WHERE rowid = l_line_rowid_tbl(j);

Line 982: request_id = fnd_global.conc_request_id,

978: item_to_price_yn = l_itm_to_price_tbl(j),
979: program_application_id = fnd_global.prog_appl_id,
980: program_id = fnd_global.conc_program_id,
981: program_update_date = sysdate,
982: request_id = fnd_global.conc_request_id,
983: pricing_date = sysdate
984: WHERE rowid = l_line_rowid_tbl(j);
985:
986: END IF; --#end if12

Line 1002: program_application_id = fnd_global.prog_appl_id,

998: total_line_list_price = l_hdr_list_price,
999: price_list_id = l_hdr_price_list,
1000: estimated_amount = NVL(l_estimated_amount,0),
1001: user_estimated_amount = NVL(l_user_estimated_amount,0),
1002: program_application_id = fnd_global.prog_appl_id,
1003: program_id = fnd_global.conc_program_id,
1004: program_update_date = sysdate,
1005: request_id = fnd_global.conc_request_id,
1006: pricing_date = sysdate

Line 1003: program_id = fnd_global.conc_program_id,

999: price_list_id = l_hdr_price_list,
1000: estimated_amount = NVL(l_estimated_amount,0),
1001: user_estimated_amount = NVL(l_user_estimated_amount,0),
1002: program_application_id = fnd_global.prog_appl_id,
1003: program_id = fnd_global.conc_program_id,
1004: program_update_date = sysdate,
1005: request_id = fnd_global.conc_request_id,
1006: pricing_date = sysdate
1007: WHERE rowid = chr_rec.rowid;

Line 1005: request_id = fnd_global.conc_request_id,

1001: user_estimated_amount = NVL(l_user_estimated_amount,0),
1002: program_application_id = fnd_global.prog_appl_id,
1003: program_id = fnd_global.conc_program_id,
1004: program_update_date = sysdate,
1005: request_id = fnd_global.conc_request_id,
1006: pricing_date = sysdate
1007: WHERE rowid = chr_rec.rowid;
1008:
1009:

Line 1151: fnd_global.conc_request_id,

1147: 'Y',
1148: p_category_code,
1149: p_chr_id,
1150: g_k_price_list_id,
1151: fnd_global.conc_request_id,
1152: fnd_global.user_id,
1153: fnd_global.user_id,
1154: fnd_global.conc_login_id
1155: );

Line 1152: fnd_global.user_id,

1148: p_category_code,
1149: p_chr_id,
1150: g_k_price_list_id,
1151: fnd_global.conc_request_id,
1152: fnd_global.user_id,
1153: fnd_global.user_id,
1154: fnd_global.conc_login_id
1155: );
1156:

Line 1153: fnd_global.user_id,

1149: p_chr_id,
1150: g_k_price_list_id,
1151: fnd_global.conc_request_id,
1152: fnd_global.user_id,
1153: fnd_global.user_id,
1154: fnd_global.conc_login_id
1155: );
1156:
1157:

Line 1154: fnd_global.conc_login_id

1150: g_k_price_list_id,
1151: fnd_global.conc_request_id,
1152: fnd_global.user_id,
1153: fnd_global.user_id,
1154: fnd_global.conc_login_id
1155: );
1156:
1157:
1158: -- initialize the g_k_price_list_id

Line 2115: fnd_global.user_id,

2111: l_qp_list_lines_rec.substitution_attribute , -- SUBSTITUTION_ATTRIBUTE
2112: l_qp_list_lines_rec.override_flag , -- UPDATE_ALLOWED
2113: 'Y' , -- UPDATED_FLAG
2114: 1, -- OBJECT_VERSION_NUMBER
2115: fnd_global.user_id,
2116: sysdate,
2117: fnd_global.user_id,
2118: sysdate
2119: );

Line 2117: fnd_global.user_id,

2113: 'Y' , -- UPDATED_FLAG
2114: 1, -- OBJECT_VERSION_NUMBER
2115: fnd_global.user_id,
2116: sysdate,
2117: fnd_global.user_id,
2118: sysdate
2119: );
2120:
2121: CLOSE csr_list_lines; -- close the list line cursor