APPS.FEM_UD_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 1061: FROM fem_object_catalog_b o, fem_object_definition_b d

1057: BEGIN
1058:
1059: SELECT object_definition_id
1060: INTO v_undo_list_obj_def_id
1061: FROM fem_object_catalog_b o, fem_object_definition_b d
1062: WHERE o.object_id = p_undo_list_obj_id
1063: AND o.object_type_code = 'UNDO'
1064: AND o.object_id = d.object_id;
1065:

Line 3515: FROM fem_object_definition_b

3511: END;
3512:
3513: -- Retrieve undo list object id
3514: SELECT object_id INTO v_undo_list_obj_id
3515: FROM fem_object_definition_b
3516: WHERE object_definition_id = p_undo_list_obj_def_id;
3517:
3518: -- ============================================================================
3519: -- STEP 1:

Line 4568: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u

4564: BEGIN
4565:
4566: SELECT u.undo_list_obj_def_id
4567: INTO v_undo_list_obj_def_id
4568: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u
4569: WHERE o.object_id = p_undo_list_obj_id
4570: AND o.object_type_code = 'UNDO'
4571: AND o.object_id = d.object_id
4572: AND d.object_definition_id = u.undo_list_obj_def_id;

Line 5148: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u

5144: v_check_status BOOLEAN;
5145:
5146: CURSOR c1 IS
5147: SELECT o.object_id
5148: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u
5149: WHERE o.object_type_code = 'UNDO'
5150: AND o.object_id = d.object_id
5151: AND d.object_definition_id = u.undo_list_obj_def_id
5152: AND (u.execution_date < SYSDATE OR u.execution_date = SYSDATE)

Line 5396: FROM fem_object_catalog_vl o, fem_object_definition_b d

5392: BEGIN
5393:
5394: SELECT o.object_id, d.object_definition_id, o.object_name
5395: INTO v_undo_list_obj_id, v_undo_list_obj_def_id, pv_undo_object_name
5396: FROM fem_object_catalog_vl o, fem_object_definition_b d
5397: WHERE o.object_type_code = 'UNDO'
5398: AND o.object_id = d.object_id
5399: AND o.object_name = 'UNDO - REQUEST_ID: '||p_request_id||' OBJECT_ID: '||p_object_id;
5400: v_undo_list_exists := 'T';

Line 5817: FROM fem_object_catalog_vl o, fem_object_definition_b d

5813: BEGIN
5814:
5815: SELECT o.object_id, d.object_definition_id, o.object_name
5816: INTO v_undo_list_obj_id, v_undo_list_obj_def_id, pv_undo_object_name
5817: FROM fem_object_catalog_vl o, fem_object_definition_b d
5818: WHERE o.object_type_code = 'UNDO'
5819: AND o.object_id = d.object_id
5820: AND o.object_name = 'UNDO - REQUEST_ID: '||p_request_id;
5821: v_undo_list_exists := 'T';

Line 6226: FROM fem_object_catalog_vl o, fem_object_definition_b d

6222: BEGIN
6223:
6224: SELECT o.object_id, d.object_definition_id
6225: INTO v_undo_list_obj_id, v_undo_list_obj_def_id
6226: FROM fem_object_catalog_vl o, fem_object_definition_b d
6227: WHERE o.object_type_code = 'UNDO'
6228: AND o.object_id = d.object_id
6229: AND o.object_name = p_undo_list_name;
6230: v_undo_list_exists := 'T';

Line 7225: l_obj_def_id fem_object_definition_b.object_definition_id%TYPE := NULL;

7221:
7222: l_return_status varchar2(1);
7223: l_msg_count NUMBER;
7224: l_msg_data varchar2(2000);
7225: l_obj_def_id fem_object_definition_b.object_definition_id%TYPE := NULL;
7226: l_exec_state varchar2(30); -- normal, restart, rerun
7227: l_prev_request_id number;
7228:
7229: l_prg_msg VARCHAR2(2000);

Line 8182: from fem_object_definition_b d

8178: );
8179:
8180: select d.object_definition_id
8181: into x_obj_def_id
8182: from fem_object_definition_b d
8183: where d.object_id = p_object_id
8184: and p_effective_date between d.effective_start_date and d.effective_end_date
8185: and d.old_approved_copy_flag = 'N';
8186:

Line 8199: from fem_object_definition_b d

8195: when no_data_found then
8196:
8197: select d.object_definition_id
8198: into x_obj_def_id
8199: from fem_object_definition_b d
8200: where d.object_id = p_object_id
8201: AND ROWNUM = 1;
8202:
8203: FEM_ENGINES_PKG.Tech_Message (