APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_OBJECT_DEFINITION_B

Line 41: t_object_definition_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

37: t_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
38: t_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
39: t_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
40: t_folder_id FEM_OBJECT_CATALOG_B.folder_id%TYPE;
41: t_object_definition_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
42: t_approval_status_code FEM_OBJECT_DEFINITION_B.approval_status_code%TYPE;
43:
44: t_request_id FEM_WF_REQUESTS.wf_request_id%TYPE;
45: t_id number;

Line 42: t_approval_status_code FEM_OBJECT_DEFINITION_B.approval_status_code%TYPE;

38: t_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
39: t_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
40: t_folder_id FEM_OBJECT_CATALOG_B.folder_id%TYPE;
41: t_object_definition_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
42: t_approval_status_code FEM_OBJECT_DEFINITION_B.approval_status_code%TYPE;
43:
44: t_request_id FEM_WF_REQUESTS.wf_request_id%TYPE;
45: t_id number;
46:

Line 73: ,fem_object_definition_b def

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
77: and req_def.wf_request_id = req.wf_request_id

Line 1330: from fem_object_definition_b

1326: l_msg_data t_msg_data%TYPE;
1327:
1328: cursor l_obj_defs_cur is
1329: select object_definition_id
1330: from fem_object_definition_b
1331: where object_id = p_obj_id
1332: and old_approved_copy_flag = G_CURRENT_COPY;
1333:
1334: BEGIN

Line 2586: from fem_object_definition_b

2582: BEGIN
2583:
2584: select object_id
2585: into l_obj_id
2586: from fem_object_definition_b
2587: where object_definition_id = p_obj_def_id;
2588:
2589: return l_obj_id;
2590:

Line 2636: from fem_object_definition_b

2632: );
2633:
2634: select old_approved_copy_obj_def_id
2635: into l_old_approved_obj_def_id
2636: from fem_object_definition_b
2637: where old_approved_copy_flag = G_CURRENT_COPY
2638: and object_definition_id = p_obj_def_id;
2639:
2640: FEM_ENGINES_PKG.Tech_Message (

Line 3221: update fem_object_definition_b

3217: || ' p_approver_user_id:' || p_approver_user_id
3218: || ' p_approval_date:' || p_approval_date
3219: );
3220:
3221: update fem_object_definition_b
3222: set approval_status_code =
3223: decode(p_approval_status_code
3224: ,FND_API.G_MISS_CHAR,approval_status_code
3225: ,p_approval_status_code)

Line 3291: from fem_object_definition_b

3287: BEGIN
3288:
3289: select approval_status_code
3290: into l_approval_status_code
3291: from fem_object_definition_b
3292: where object_definition_id = p_obj_def_id;
3293:
3294: return l_approval_status_code;
3295:

Line 4193: update fem_object_definition_b

4189: --------------------------------------------------------------------------------
4190: IS
4191: BEGIN
4192:
4193: update fem_object_definition_b
4194: set old_approved_copy_obj_def_id = p_old_approved_obj_def_id
4195: where old_approved_copy_flag = G_CURRENT_COPY
4196: and object_definition_id = p_obj_def_id;
4197:

Line 4228: from fem_object_definition_b

4224: BEGIN
4225:
4226: select count(object_definition_id)
4227: into l_count
4228: from fem_object_definition_b
4229: where object_definition_id = p_obj_def_id;
4230:
4231: return (l_count > 0);
4232:

Line 4266: from fem_object_definition_b

4262: BEGIN
4263:
4264: select count(object_definition_id)
4265: into l_count
4266: from fem_object_definition_b
4267: where old_approved_copy_flag = G_CURRENT_COPY
4268: and object_id = p_obj_id
4269: and object_definition_id <> nvl(p_exclude_obj_def_id, -1);
4270:

Line 4394: ,fem_object_definition_b def

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
4398: and req.wf_request_item_code = p_request_item_code

Line 4515: from fem_object_definition_b

4511: BEGIN
4512:
4513: select effective_start_date, effective_end_date
4514: into x_effective_start_date, x_effective_end_date
4515: from fem_object_definition_b
4516: where object_definition_id = p_obj_def_id;
4517:
4518: END GetEffectiveDates;
4519: