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
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 ;
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) ;
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:
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
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:
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 */
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:
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 */
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 */
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 */