DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on FND_GLOBAL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4058: x_created_by => fnd_global.USER_ID,

4054: fnd_documents_pkg.insert_row(
4055: x_rowid => l_row_id,
4056: x_document_id => l_doc_id,
4057: x_creation_date => sysdate,
4058: x_created_by => fnd_global.USER_ID,
4059: x_last_update_date => sysdate,
4060: x_last_updated_by => fnd_global.USER_ID,
4061: x_last_update_login => fnd_global.USER_ID,
4062: x_request_id => fnd_global.USER_ID,

Line 4060: x_last_updated_by => fnd_global.USER_ID,

4056: x_document_id => l_doc_id,
4057: x_creation_date => sysdate,
4058: x_created_by => fnd_global.USER_ID,
4059: x_last_update_date => sysdate,
4060: x_last_updated_by => fnd_global.USER_ID,
4061: x_last_update_login => fnd_global.USER_ID,
4062: x_request_id => fnd_global.USER_ID,
4063: x_program_application_id => fnd_global.PROG_APPL_ID,
4064: x_program_id => fnd_global.CONC_REQUEST_ID,

Line 4061: x_last_update_login => fnd_global.USER_ID,

4057: x_creation_date => sysdate,
4058: x_created_by => fnd_global.USER_ID,
4059: x_last_update_date => sysdate,
4060: x_last_updated_by => fnd_global.USER_ID,
4061: x_last_update_login => fnd_global.USER_ID,
4062: x_request_id => fnd_global.USER_ID,
4063: x_program_application_id => fnd_global.PROG_APPL_ID,
4064: x_program_id => fnd_global.CONC_REQUEST_ID,
4065: x_program_update_date => sysdate,

Line 4062: x_request_id => fnd_global.USER_ID,

4058: x_created_by => fnd_global.USER_ID,
4059: x_last_update_date => sysdate,
4060: x_last_updated_by => fnd_global.USER_ID,
4061: x_last_update_login => fnd_global.USER_ID,
4062: x_request_id => fnd_global.USER_ID,
4063: x_program_application_id => fnd_global.PROG_APPL_ID,
4064: x_program_id => fnd_global.CONC_REQUEST_ID,
4065: x_program_update_date => sysdate,
4066: x_datatype_id => 2,

Line 4063: x_program_application_id => fnd_global.PROG_APPL_ID,

4059: x_last_update_date => sysdate,
4060: x_last_updated_by => fnd_global.USER_ID,
4061: x_last_update_login => fnd_global.USER_ID,
4062: x_request_id => fnd_global.USER_ID,
4063: x_program_application_id => fnd_global.PROG_APPL_ID,
4064: x_program_id => fnd_global.CONC_REQUEST_ID,
4065: x_program_update_date => sysdate,
4066: x_datatype_id => 2,
4067: x_category_id => 33,

Line 4064: x_program_id => fnd_global.CONC_REQUEST_ID,

4060: x_last_updated_by => fnd_global.USER_ID,
4061: x_last_update_login => fnd_global.USER_ID,
4062: x_request_id => fnd_global.USER_ID,
4063: x_program_application_id => fnd_global.PROG_APPL_ID,
4064: x_program_id => fnd_global.CONC_REQUEST_ID,
4065: x_program_update_date => sysdate,
4066: x_datatype_id => 2,
4067: x_category_id => 33,
4068: x_security_type => 4,

Line 4149: , x_created_by => fnd_global.USER_ID

4145: , x_pk4_value => NULL
4146: , x_pk5_value => NULL
4147: , x_automatically_added_flag => 'N'
4148: , x_creation_date => sysdate
4149: , x_created_by => fnd_global.USER_ID
4150: , x_last_update_date => sysdate
4151: , x_last_updated_by => fnd_global.USER_ID
4152: , x_last_update_login => fnd_global.LOGIN_ID
4153: -- following parameters are required for the API but we do not

Line 4151: , x_last_updated_by => fnd_global.USER_ID

4147: , x_automatically_added_flag => 'N'
4148: , x_creation_date => sysdate
4149: , x_created_by => fnd_global.USER_ID
4150: , x_last_update_date => sysdate
4151: , x_last_updated_by => fnd_global.USER_ID
4152: , x_last_update_login => fnd_global.LOGIN_ID
4153: -- following parameters are required for the API but we do not
4154: -- use so send in as null
4155: , x_column1 => null

Line 4152: , x_last_update_login => fnd_global.LOGIN_ID

4148: , x_creation_date => sysdate
4149: , x_created_by => fnd_global.USER_ID
4150: , x_last_update_date => sysdate
4151: , x_last_updated_by => fnd_global.USER_ID
4152: , x_last_update_login => fnd_global.LOGIN_ID
4153: -- following parameters are required for the API but we do not
4154: -- use so send in as null
4155: , x_column1 => null
4156: , x_datatype_id => null

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

4250: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4251: l_model_ord_qty Number;
4252:
4253:
4254: l_new_line varchar2(10) := fnd_global.newline;
4255: l_hdr_text varchar2(1000);
4256: l_temp_text varchar2(1000);
4257: --l_form_feed varchar2(100) := FND_GLOBAL.local_chr(12); Bugfix 6116881
4258: l_space varchar2(10) := fnd_global.local_chr(32);

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

4253:
4254: l_new_line varchar2(10) := fnd_global.newline;
4255: l_hdr_text varchar2(1000);
4256: l_temp_text varchar2(1000);
4257: --l_form_feed varchar2(100) := FND_GLOBAL.local_chr(12); Bugfix 6116881
4258: l_space varchar2(10) := fnd_global.local_chr(32);
4259:
4260: l_page_size Number := 15;
4261: l_stmt Number;

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

4254: l_new_line varchar2(10) := fnd_global.newline;
4255: l_hdr_text varchar2(1000);
4256: l_temp_text varchar2(1000);
4257: --l_form_feed varchar2(100) := FND_GLOBAL.local_chr(12); Bugfix 6116881
4258: l_space varchar2(10) := fnd_global.local_chr(32);
4259:
4260: l_page_size Number := 15;
4261: l_stmt Number;
4262: l_line_count Number := 0;

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

5925: pline_no number := 1111 ;
5926:
5927: lstmt_num number ;
5928:
5929: l_new_line varchar2(10) := fnd_global.local_chr(10);
5930:
5931: i number ;
5932:
5933:

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

6174: )
6175: is
6176: PRAGMA AUTONOMOUS_TRANSACTION ;
6177:
6178: l_new_line varchar2(10) := fnd_global.local_chr(10);
6179: v_error_message varchar2(2300) ;
6180: l_msg_data varchar2(2300) ;
6181:
6182: