APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_WF_REQ_OBJECT_DEFS

Line 72: ,fem_wf_req_object_defs req_def

68: select req_def.object_definition_id
69: ,req_def.object_type_code
70: ,req_def.prev_approval_status_code
71: from fem_wf_requests req
72: ,fem_wf_req_object_defs req_def
73: ,fem_object_definition_b def
74: where req.wf_request_id = p_request_id
75: and req.wf_request_item_code = p_request_item_code
76: and req.wf_request_type_code = p_request_type_code

Line 99: ,fem_wf_req_object_defs req_def

95: ,obj.folder_id
96: ,fol.folder_name
97: ,typ.view_only_oa_function_name
98: from fem_wf_requests req
99: ,fem_wf_req_object_defs req_def
100: ,fem_object_definition_vl def
101: ,fem_object_catalog_vl obj
102: ,fem_object_types_vl typ
103: ,fem_folders_vl fol

Line 3142: -- FEM_WF_REQ_OBJECT_DEFS table.

3138: -- PurgeApprovalRequest
3139: --
3140: -- DESCRIPTION
3141: -- Deletes all the appropriate approval request records from the
3142: -- FEM_WF_REQ_OBJECT_DEFS table.
3143: --
3144: -- IN
3145: -- p_item_type - The workflow item type (FEMAPPR)
3146: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

Line 3170: delete from fem_wf_req_object_defs

3166: p_item_type, p_item_key, G_REQUEST_ID);
3167:
3168: if (l_request_id is not null) then
3169:
3170: delete from fem_wf_req_object_defs
3171: where wf_request_id = l_request_id;
3172:
3173: end if;
3174:

Line 4281: -- PL/SQL API for creating a row in the FEM_WF_REQ_OBJECT_DEFS table.

4277: -- PROCEDURE
4278: -- CreateWfReqObjectDefRow
4279: --
4280: -- DESCRIPTION
4281: -- PL/SQL API for creating a row in the FEM_WF_REQ_OBJECT_DEFS table.
4282: -- Used for raising FEM Business Rule Events.
4283: --
4284: -- IN
4285: -- p_wf_request_id - Workflow Request Id

Line 4312: insert into fem_wf_req_object_defs (

4308: || ' p_obj_def_id:' || p_obj_def_id || ' p_object_type_code:'
4309: || p_object_type_code || ' p_prev_approval_status_code:' || p_prev_approval_status_code
4310: );
4311:
4312: insert into fem_wf_req_object_defs (
4313: wf_request_id
4314: ,object_definition_id
4315: ,prev_approval_status_code
4316: ,object_type_code

Line 4393: ,fem_wf_req_object_defs req_def

4389:
4390: select count(*)
4391: into l_count
4392: from fem_wf_requests req
4393: ,fem_wf_req_object_defs req_def
4394: ,fem_object_definition_b def
4395: ,fem_object_catalog_b obj
4396: ,fem_object_types typ
4397: where req.wf_request_id = p_request_id