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

Line 520: gUserId := nvl(fnd_global.user_id, -1);

516: -- pLineId is the line_id of the model line
517: --
518:
519: lStmtNumber := 10;
520: gUserId := nvl(fnd_global.user_id, -1);
521: gLoginId := nvl(fnd_global.login_id, -1);
522:
523: /* get top model's ato_line_id */
524: --

Line 521: gLoginId := nvl(fnd_global.login_id, -1);

517: --
518:
519: lStmtNumber := 10;
520: gUserId := nvl(fnd_global.user_id, -1);
521: gLoginId := nvl(fnd_global.login_id, -1);
522:
523: /* get top model's ato_line_id */
524: --
525: -- The column top_model_line_id in bom_cto_src_orgs is being used

Line 2198: gUserId := nvl(Fnd_Global.USER_ID, -1);

2194:
2195:
2196: begin
2197:
2198: gUserId := nvl(Fnd_Global.USER_ID, -1);
2199: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
2200:
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202:

Line 2199: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);

2195:
2196: begin
2197:
2198: gUserId := nvl(Fnd_Global.USER_ID, -1);
2199: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
2200:
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202:
2203: v_step := 'Step A1' ;

Line 2360: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );

2356:
2357:
2358:
2359: oe_debug_pub.add('bcol info : CONC REQ PARAMS ' , 3) ;
2360: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );
2361: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2362: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2363:
2364:

Line 2361: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );

2357:
2358:
2359: oe_debug_pub.add('bcol info : CONC REQ PARAMS ' , 3) ;
2360: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );
2361: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2362: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2363:
2364:
2365: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;

Line 2362: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );

2358:
2359: oe_debug_pub.add('bcol info : CONC REQ PARAMS ' , 3) ;
2360: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );
2361: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2362: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2363:
2364:
2365: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2366: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 2365: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;

2361: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2362: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2363:
2364:
2365: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2366: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;
2367: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;
2368:
2369:

Line 2366: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;

2362: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2363:
2364:
2365: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2366: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;
2367: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;
2368:
2369:
2370:

Line 2367: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;

2363:
2364:
2365: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2366: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;
2367: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;
2368:
2369:
2370:
2371: /* set plan level to 0 for top level item */

Line 2477: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );

2473: t_bcol(v_bcol_line_id).perform_match := 'N' ;
2474: end if;
2475:
2476: oe_debug_pub.add('bcol info : CONC REQ PARAMS ' , 3) ;
2477: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );
2478: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2479: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2480:
2481:

Line 2478: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );

2474: end if;
2475:
2476: oe_debug_pub.add('bcol info : CONC REQ PARAMS ' , 3) ;
2477: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );
2478: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2479: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2480:
2481:
2482: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;

Line 2479: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );

2475:
2476: oe_debug_pub.add('bcol info : CONC REQ PARAMS ' , 3) ;
2477: oe_debug_pub.add('bcol info : CONC REQ ' || FND_GLOBAL.CONC_REQUEST_ID , 3 );
2478: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2479: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2480:
2481:
2482: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2483: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 2482: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;

2478: oe_debug_pub.add('bcol info : CONC PROG ' || FND_GLOBAL.CONC_PROGRAM_ID , 3 );
2479: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2480:
2481:
2482: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2483: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;
2484: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;
2485:
2486:

Line 2483: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;

2479: oe_debug_pub.add('bcol info : PROG APPL ' || FND_GLOBAL.PROG_APPL_ID , 3 );
2480:
2481:
2482: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2483: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;
2484: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;
2485:
2486:
2487: v_kount := v_kount + 1 ;

Line 2484: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;

2480:
2481:
2482: t_bcol(v_bcol_line_id).Request_Id := FND_GLOBAL.CONC_REQUEST_ID;
2483: t_bcol(v_bcol_line_id).Program_Id := FND_GLOBAL.CONC_PROGRAM_ID;
2484: t_bcol(v_bcol_line_id).Program_Application_Id := FND_GLOBAL.PROG_APPL_ID;
2485:
2486:
2487: v_kount := v_kount + 1 ;
2488:

Line 2803: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */

2799: ,gUserId /* CREATED_BY */
2800: ,sysdate /* LAST_UPDATE_DATE */
2801: ,gUserId /* LAST_UPDATED_BY */
2802: ,gLoginId /* LAST_UPDATE_LOGIN */
2803: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
2804: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
2805: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
2806: ,sysdate /* PROGRAM_UPDATE_DATE */
2807: ,t_bcol(i).ordered_quantity / t_bcol(t_bcol(i).parent_ato_line_id).ordered_quantity

Line 2804: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */

2800: ,sysdate /* LAST_UPDATE_DATE */
2801: ,gUserId /* LAST_UPDATED_BY */
2802: ,gLoginId /* LAST_UPDATE_LOGIN */
2803: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
2804: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
2805: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
2806: ,sysdate /* PROGRAM_UPDATE_DATE */
2807: ,t_bcol(i).ordered_quantity / t_bcol(t_bcol(i).parent_ato_line_id).ordered_quantity
2808: ,'N'

Line 2805: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

2801: ,gUserId /* LAST_UPDATED_BY */
2802: ,gLoginId /* LAST_UPDATE_LOGIN */
2803: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
2804: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
2805: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
2806: ,sysdate /* PROGRAM_UPDATE_DATE */
2807: ,t_bcol(i).ordered_quantity / t_bcol(t_bcol(i).parent_ato_line_id).ordered_quantity
2808: ,'N'
2809: ,'N'

Line 2883: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */

2879: ,gUserId /* CREATED_BY */
2880: ,sysdate /* LAST_UPDATE_DATE */
2881: ,gUserId /* LAST_UPDATED_BY */
2882: ,gLoginId /* LAST_UPDATE_LOGIN */
2883: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
2884: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
2885: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
2886: ,sysdate /* PROGRAM_UPDATE_DATE */
2887: ,t_bcol(i).ordered_quantity / t_bcol(t_bcol(i).parent_ato_line_id).ordered_quantity

Line 2884: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */

2880: ,sysdate /* LAST_UPDATE_DATE */
2881: ,gUserId /* LAST_UPDATED_BY */
2882: ,gLoginId /* LAST_UPDATE_LOGIN */
2883: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
2884: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
2885: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
2886: ,sysdate /* PROGRAM_UPDATE_DATE */
2887: ,t_bcol(i).ordered_quantity / t_bcol(t_bcol(i).parent_ato_line_id).ordered_quantity
2888: ,t_bcol(i).config_creation

Line 2885: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

2881: ,gUserId /* LAST_UPDATED_BY */
2882: ,gLoginId /* LAST_UPDATE_LOGIN */
2883: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
2884: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
2885: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
2886: ,sysdate /* PROGRAM_UPDATE_DATE */
2887: ,t_bcol(i).ordered_quantity / t_bcol(t_bcol(i).parent_ato_line_id).ordered_quantity
2888: ,t_bcol(i).config_creation
2889: , 'N'

Line 4080: x_created_by => fnd_global.USER_ID,

4076: fnd_documents_pkg.insert_row(
4077: x_rowid => l_row_id,
4078: x_document_id => l_doc_id,
4079: x_creation_date => sysdate,
4080: x_created_by => fnd_global.USER_ID,
4081: x_last_update_date => sysdate,
4082: x_last_updated_by => fnd_global.USER_ID,
4083: x_last_update_login => fnd_global.USER_ID,
4084: x_request_id => fnd_global.USER_ID,

Line 4082: x_last_updated_by => fnd_global.USER_ID,

4078: x_document_id => l_doc_id,
4079: x_creation_date => sysdate,
4080: x_created_by => fnd_global.USER_ID,
4081: x_last_update_date => sysdate,
4082: x_last_updated_by => fnd_global.USER_ID,
4083: x_last_update_login => fnd_global.USER_ID,
4084: x_request_id => fnd_global.USER_ID,
4085: x_program_application_id => fnd_global.PROG_APPL_ID,
4086: x_program_id => fnd_global.CONC_REQUEST_ID,

Line 4083: x_last_update_login => fnd_global.USER_ID,

4079: x_creation_date => sysdate,
4080: x_created_by => fnd_global.USER_ID,
4081: x_last_update_date => sysdate,
4082: x_last_updated_by => fnd_global.USER_ID,
4083: x_last_update_login => fnd_global.USER_ID,
4084: x_request_id => fnd_global.USER_ID,
4085: x_program_application_id => fnd_global.PROG_APPL_ID,
4086: x_program_id => fnd_global.CONC_REQUEST_ID,
4087: x_program_update_date => sysdate,

Line 4084: x_request_id => fnd_global.USER_ID,

4080: x_created_by => fnd_global.USER_ID,
4081: x_last_update_date => sysdate,
4082: x_last_updated_by => fnd_global.USER_ID,
4083: x_last_update_login => fnd_global.USER_ID,
4084: x_request_id => fnd_global.USER_ID,
4085: x_program_application_id => fnd_global.PROG_APPL_ID,
4086: x_program_id => fnd_global.CONC_REQUEST_ID,
4087: x_program_update_date => sysdate,
4088: x_datatype_id => 2,

Line 4085: x_program_application_id => fnd_global.PROG_APPL_ID,

4081: x_last_update_date => sysdate,
4082: x_last_updated_by => fnd_global.USER_ID,
4083: x_last_update_login => fnd_global.USER_ID,
4084: x_request_id => fnd_global.USER_ID,
4085: x_program_application_id => fnd_global.PROG_APPL_ID,
4086: x_program_id => fnd_global.CONC_REQUEST_ID,
4087: x_program_update_date => sysdate,
4088: x_datatype_id => 2,
4089: x_category_id => 33,

Line 4086: x_program_id => fnd_global.CONC_REQUEST_ID,

4082: x_last_updated_by => fnd_global.USER_ID,
4083: x_last_update_login => fnd_global.USER_ID,
4084: x_request_id => fnd_global.USER_ID,
4085: x_program_application_id => fnd_global.PROG_APPL_ID,
4086: x_program_id => fnd_global.CONC_REQUEST_ID,
4087: x_program_update_date => sysdate,
4088: x_datatype_id => 2,
4089: x_category_id => 33,
4090: x_security_type => 4,

Line 4173: , x_created_by => fnd_global.USER_ID

4169: , x_pk4_value => NULL
4170: , x_pk5_value => NULL
4171: , x_automatically_added_flag => 'N'
4172: , x_creation_date => sysdate
4173: , x_created_by => fnd_global.USER_ID
4174: , x_last_update_date => sysdate
4175: , x_last_updated_by => fnd_global.USER_ID
4176: , x_last_update_login => fnd_global.LOGIN_ID
4177: -- following parameters are required for the API but we do not

Line 4175: , x_last_updated_by => fnd_global.USER_ID

4171: , x_automatically_added_flag => 'N'
4172: , x_creation_date => sysdate
4173: , x_created_by => fnd_global.USER_ID
4174: , x_last_update_date => sysdate
4175: , x_last_updated_by => fnd_global.USER_ID
4176: , x_last_update_login => fnd_global.LOGIN_ID
4177: -- following parameters are required for the API but we do not
4178: -- use so send in as null
4179: , x_column1 => null

Line 4176: , x_last_update_login => fnd_global.LOGIN_ID

4172: , x_creation_date => sysdate
4173: , x_created_by => fnd_global.USER_ID
4174: , x_last_update_date => sysdate
4175: , x_last_updated_by => fnd_global.USER_ID
4176: , x_last_update_login => fnd_global.LOGIN_ID
4177: -- following parameters are required for the API but we do not
4178: -- use so send in as null
4179: , x_column1 => null
4180: , x_datatype_id => null

Line 4278: l_new_line varchar2(10) := fnd_global.newline;

4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4275: l_model_ord_qty Number;
4276:
4277:
4278: l_new_line varchar2(10) := fnd_global.newline;
4279: l_hdr_text varchar2(1000);
4280: l_temp_text varchar2(1000);
4281: --l_form_feed varchar2(100) := FND_GLOBAL.local_chr(12); Bugfix 6116881
4282: l_space varchar2(10) := fnd_global.local_chr(32);

Line 4281: --l_form_feed varchar2(100) := FND_GLOBAL.local_chr(12); Bugfix 6116881

4277:
4278: l_new_line varchar2(10) := fnd_global.newline;
4279: l_hdr_text varchar2(1000);
4280: l_temp_text varchar2(1000);
4281: --l_form_feed varchar2(100) := FND_GLOBAL.local_chr(12); Bugfix 6116881
4282: l_space varchar2(10) := fnd_global.local_chr(32);
4283:
4284: l_page_size Number := 15;
4285: l_stmt Number;

Line 4282: l_space varchar2(10) := fnd_global.local_chr(32);

4278: l_new_line varchar2(10) := fnd_global.newline;
4279: l_hdr_text varchar2(1000);
4280: l_temp_text varchar2(1000);
4281: --l_form_feed varchar2(100) := FND_GLOBAL.local_chr(12); Bugfix 6116881
4282: l_space varchar2(10) := fnd_global.local_chr(32);
4283:
4284: l_page_size Number := 15;
4285: l_stmt Number;
4286: l_line_count Number := 0;

Line 5953: l_new_line varchar2(10) := fnd_global.local_chr(10);

5949: pline_no number := 1111 ;
5950:
5951: lstmt_num number ;
5952:
5953: l_new_line varchar2(10) := fnd_global.local_chr(10);
5954:
5955: i number ;
5956:
5957:

Line 6202: l_new_line varchar2(10) := fnd_global.local_chr(10);

6198: )
6199: is
6200: PRAGMA AUTONOMOUS_TRANSACTION ;
6201:
6202: l_new_line varchar2(10) := fnd_global.local_chr(10);
6203: v_error_message varchar2(2300) ;
6204: l_msg_data varchar2(2300) ;
6205:
6206: