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 1155: l_new_line varchar2(10) := fnd_global.local_chr(10);

1151: /* LBM Project */
1152: v_diff_basis_string varchar2(2000);
1153: v_sub_diff_basis_string varchar2(2000);
1154:
1155: l_new_line varchar2(10) := fnd_global.local_chr(10);
1156:
1157: basis_model_comp_seq_id_arr seq_tab;
1158: basis_component_item_id_arr seq_tab;
1159:

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

4756: ,s.attribute14
4757: ,s.attribute15
4758: ,s.original_system_reference
4759: ,s.enforce_int_requirements
4760: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
4761: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
4762: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
4763: ,sysdate /* PROGRAM_UPDATE_DATE */
4764: ,sysdate /* LAST_UPDATE_DATE */

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

4757: ,s.attribute15
4758: ,s.original_system_reference
4759: ,s.enforce_int_requirements
4760: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
4761: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
4762: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
4763: ,sysdate /* PROGRAM_UPDATE_DATE */
4764: ,sysdate /* LAST_UPDATE_DATE */
4765: ,gUserId /* LAST_UPDATED_BY */

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

4758: ,s.original_system_reference
4759: ,s.enforce_int_requirements
4760: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
4761: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
4762: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
4763: ,sysdate /* PROGRAM_UPDATE_DATE */
4764: ,sysdate /* LAST_UPDATE_DATE */
4765: ,gUserId /* LAST_UPDATED_BY */
4766: ,sysdate /* CREATION_DATE */