DBA Data[Home] [Help]

APPS.FEM_RULE_SET_MANAGER dependencies on FEM_OBJECT_CATALOG_B

Line 396: from fem_object_catalog_b o

392: l_module_name VARCHAR2(70) := G_MODULE_NAME || 'GetObjectIDFromDefID';
393:
394: Cursor getObjectID(p_Obj_Def_ID IN DEF_OBJECT_DEFINITION_ID%TYPE) IS
395: SELECT o.object_id
396: from fem_object_catalog_b o
397: ,fem_object_definition_b od
398: where o.object_id = od.object_id
399: and od.object_definition_id = p_Obj_Def_ID;
400:

Line 2865: from Fem_Object_Catalog_B

2861: Begin
2862: -- get rule's local value set combo ID
2863: select local_vs_combo_id
2864: into l_Rule_Local_VSCID
2865: from Fem_Object_Catalog_B
2866: where object_id = p_Rule_Object_ID;
2867:
2868: -- if the rule's local value set id doesn't match the one for the ledger, its BAD.
2869: If (l_Rule_Local_VSCID <> z_local_vs_for_session) then

Line 3137: from Fem_Object_Catalog_B

3133:
3134: Begin /*--Check Local VS of Rule Set being run --*/
3135: select local_vs_combo_id
3136: into l_RuleSet_LocalVSComboID
3137: from Fem_Object_Catalog_B
3138: where object_id = p_Orig_RuleSet_Object_ID;
3139: If (l_RuleSet_LocalVSComboID <> z_local_vs_for_session) then
3140: z_Err_Code := 9;
3141: z_Err_Msg := G_INVALID_LVSCID_ON_OBJECT;

Line 3597: from Fem_Object_Catalog_B

3593:
3594: Begin /*--Check Local VS of Rule Set being run --*/
3595: select local_vs_combo_id
3596: into l_RuleSet_LocalVSComboID
3597: from Fem_Object_Catalog_B
3598: where object_id = p_Orig_RuleSet_Object_ID;
3599: If (l_RuleSet_LocalVSComboID <> z_local_vs_for_session) then
3600:
3601: -- originally error number's 8 and 9.