DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on FND_GLOBAL

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

112: g_EstRelDate Date;
113: glast_update_date Date := to_date('01/01/2099 00:00:00','MM/DD/YYYY HH24:MI:SS');
114:
115: /*
116: gUserId number := nvl(Fnd_Global.USER_ID, -1);
117: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);
118: */
119:
120: -- bug 4271269. populate structure_type_id in BOM

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

113: glast_update_date Date := to_date('01/01/2099 00:00:00','MM/DD/YYYY HH24:MI:SS');
114:
115: /*
116: gUserId number := nvl(Fnd_Global.USER_ID, -1);
117: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);
118: */
119:
120: -- bug 4271269. populate structure_type_id in BOM
121: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;

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

119:
120: -- bug 4271269. populate structure_type_id in BOM
121: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;
122:
123: gUserId number := nvl(fnd_global.user_id, -1);
124: gLoginId number := nvl(fnd_global.login_id, -1);
125: gRequestId number := nvl(fnd_global.conc_request_id, -1) ;
126: gProgramApplId number := nvl(fnd_global.prog_appl_id, -1) ;
127: gProgramId number := nvl(fnd_global.conc_program_id, -1) ;

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

120: -- bug 4271269. populate structure_type_id in BOM
121: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;
122:
123: gUserId number := nvl(fnd_global.user_id, -1);
124: gLoginId number := nvl(fnd_global.login_id, -1);
125: gRequestId number := nvl(fnd_global.conc_request_id, -1) ;
126: gProgramApplId number := nvl(fnd_global.prog_appl_id, -1) ;
127: gProgramId number := nvl(fnd_global.conc_program_id, -1) ;
128:

Line 125: gRequestId number := nvl(fnd_global.conc_request_id, -1) ;

121: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;
122:
123: gUserId number := nvl(fnd_global.user_id, -1);
124: gLoginId number := nvl(fnd_global.login_id, -1);
125: gRequestId number := nvl(fnd_global.conc_request_id, -1) ;
126: gProgramApplId number := nvl(fnd_global.prog_appl_id, -1) ;
127: gProgramId number := nvl(fnd_global.conc_program_id, -1) ;
128:
129: -- 3222932 setting global replacement of null disable dates

Line 126: gProgramApplId number := nvl(fnd_global.prog_appl_id, -1) ;

122:
123: gUserId number := nvl(fnd_global.user_id, -1);
124: gLoginId number := nvl(fnd_global.login_id, -1);
125: gRequestId number := nvl(fnd_global.conc_request_id, -1) ;
126: gProgramApplId number := nvl(fnd_global.prog_appl_id, -1) ;
127: gProgramId number := nvl(fnd_global.conc_program_id, -1) ;
128:
129: -- 3222932 setting global replacement of null disable dates
130:

Line 127: gProgramId number := nvl(fnd_global.conc_program_id, -1) ;

123: gUserId number := nvl(fnd_global.user_id, -1);
124: gLoginId number := nvl(fnd_global.login_id, -1);
125: gRequestId number := nvl(fnd_global.conc_request_id, -1) ;
126: gProgramApplId number := nvl(fnd_global.prog_appl_id, -1) ;
127: gProgramId number := nvl(fnd_global.conc_program_id, -1) ;
128:
129: -- 3222932 setting global replacement of null disable dates
130:
131: g_futuredate DATE := to_date('01/01/2099 00:00:00','MM/DD/YYYY HH24:MI:SS'); /* 02-14-2005 Sushant */

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

1092: /* LBM Project */
1093: v_diff_basis_string varchar2(2000);
1094: v_sub_diff_basis_string varchar2(2000);
1095:
1096: l_new_line varchar2(10) := fnd_global.local_chr(10);
1097:
1098: basis_model_comp_seq_id_arr seq_tab;
1099: basis_component_item_id_arr seq_tab;
1100:

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

4573: ,s.attribute14
4574: ,s.attribute15
4575: ,s.original_system_reference
4576: ,s.enforce_int_requirements
4577: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
4578: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
4579: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
4580: ,sysdate /* PROGRAM_UPDATE_DATE */
4581: ,sysdate /* LAST_UPDATE_DATE */

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

4574: ,s.attribute15
4575: ,s.original_system_reference
4576: ,s.enforce_int_requirements
4577: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
4578: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
4579: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
4580: ,sysdate /* PROGRAM_UPDATE_DATE */
4581: ,sysdate /* LAST_UPDATE_DATE */
4582: ,gUserId /* LAST_UPDATED_BY */

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

4575: ,s.original_system_reference
4576: ,s.enforce_int_requirements
4577: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
4578: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
4579: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
4580: ,sysdate /* PROGRAM_UPDATE_DATE */
4581: ,sysdate /* LAST_UPDATE_DATE */
4582: ,gUserId /* LAST_UPDATED_BY */
4583: ,sysdate /* CREATION_DATE */