DBA Data[Home] [Help]

APPS.BSC_DIMENSION_EDIT dependencies on BSC_UPDATE_DIM

Line 84: temp:=BSC_UPDATE_DIM.Delete_Codes_Cascade(

80: deleted_code BSC_UPDATE_UTIL.t_array_of_number;
81: temp boolean;
82: begin
83: deleted_code(1):=l_deleted_code;
84: temp:=BSC_UPDATE_DIM.Delete_Codes_Cascade(
85: l_dim_table,
86: deleted_code, 1);
87: --commit;
88: /* if (temp=FALSE) then raise program_error; end if; */

Line 117: x_source => 'BSC_UPDATE_DIM.deleteMNRow');

113: --commit;
114: EXCEPTION
115: WHEN OTHERS THEN
116: BSC_MESSAGE.Add(x_message => SQLERRM,
117: x_source => 'BSC_UPDATE_DIM.deleteMNRow');
118: end deleteMNRow;
119:
120: procedure markKPI( l_dim_table IN VARCHAR2) is
121: begin

Line 249: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);

245: if (checkrecord(l_dim_table, l_user_code, l_name)) then
246: l_message:=fnd_message.get_string('BSC','BSC_PMD_LDR_UNICONSTR_VIOLATE');
247: -- raise_application_error(-20000,'UNIQUE_CONSTRAINT_VIOLATED');
248: else
249: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);
250: l_source_lang:=USERENV('LANG');
251:
252: IF h_num_installed_languages is NULL THEN
253: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);

Line 337: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);

333: l_message:=fnd_message.get_string('BSC','BSC_PMD_LDR_UNICONSTR_VIOLATE');
334: --raise_application_error(-20000,'UNIQUE_CONSTRAINT_VIOLATED');
335: end if;
336: else
337: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);
338: l_source_lang:=USERENV('LANG');
339:
340: IF h_num_installed_languages is NULL THEN
341: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);

Line 539: x_source => 'BSC_UPDATE_DIM.Delete_Codes_CascadeMN');

535:
536: EXCEPTION
537: WHEN OTHERS THEN
538: BSC_MESSAGE.Add(x_message => SQLERRM,
539: x_source => 'BSC_UPDATE_DIM.Delete_Codes_CascadeMN');
540: RETURN FALSE;
541:
542: END Delete_Codes_CascadeMN;
543:

Line 590: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);

586: l_message:=fnd_message.get_string('BSC','BSC_PMD_LDR_UNICONSTR_VIOLATE');
587: --raise_application_error(-20000,'UNIQUE_CONSTRAINT_VIOLATED');
588: end if;
589: else
590: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);
591: l_source_lang:=USERENV('LANG');
592: for i in 1 ..l_parentcount loop
593: l_t1:=l_t1||' , '||l_fklist(i)||' , '||l_fklist(i)||'_USR';
594: l_t2:=l_t2||' , '||to_number(l_fkvaluelist(i))||' , '''||l_fkuservaluelist(i)||'''';