DBA Data[Home] [Help]

APPS.FEM_DIM_MEMBER_LOADER_PKG dependencies on FEM_MULTI_PROC_PKG

Line 278: through fem_multi_proc_pkg.MASTER altered to comply with Bind Variable Push

274: Rob Flippo 04-AUG-06 Bug 5060746 Change literals to bind variables wherever possible
275: Rob Flippo 12-AUG-06 Bug 5459028 fixed bind variable error for
276: :b_gv_apps_user_id
277: Naveen Kumar 07-Sep-06 Bug#4429427. Call to FEM_COMP_DIM_MEMBER_LOADER_PKG.Process_Rows
278: through fem_multi_proc_pkg.MASTER altered to comply with Bind Variable Push
279: architecture.
280: Rob Flippo 15-MAR-07 Bug#5900463 - TL rows for other languages
281: getting deleted when new members are being
282: loaded - modifications to build_calp_delete_stmt

Line 1604: FEM_MULTI_PROC_PKG.Delete_Data_Slices(

1600: gv_concurrent_status := fnd_concurrent.set_completion_status('NORMAL',null);
1601: END IF;
1602: /*****************************************
1603: -- Clean out the data slice table
1604: FEM_MULTI_PROC_PKG.Delete_Data_Slices(
1605: p_req_id => gv_request_id);
1606: ******************************************/
1607:
1608: ------------------------------------

Line 1908: FEM_Multi_Proc_Pkg.Get_Data_Slice(

1904: LOOP
1905:
1906: IF p_load_type <> ('DIMENSION_GROUP') THEN
1907:
1908: FEM_Multi_Proc_Pkg.Get_Data_Slice(
1909: x_slc_id => v_slc_id,
1910: x_slc_val1 => v_slc_val,
1911: x_slc_val2 => v_slc_val2,
1912: x_slc_val3 => v_slc_val3,

Line 2001: FEM_Multi_Proc_Pkg.Post_Data_Slice(

1997:
1998: END LOOP; -- bad_members
1999:
2000: IF p_load_type <> ('DIMENSION_GROUP') THEN
2001: FEM_Multi_Proc_Pkg.Post_Data_Slice(
2002: p_req_id => p_master_request_id,
2003: p_slc_id => v_slc_id,
2004: p_status => v_mp_status,
2005: p_message => v_mp_message,

Line 2311: FEM_Multi_Proc_Pkg.Get_Data_Slice(

2307: LOOP
2308:
2309: IF p_load_type <> ('DIMENSION_GROUP') THEN
2310:
2311: FEM_Multi_Proc_Pkg.Get_Data_Slice(
2312: x_slc_id => v_slc_id,
2313: x_slc_val1 => v_slc_val,
2314: x_slc_val2 => v_slc_val2,
2315: x_slc_val3 => v_slc_val3,

Line 2611: FEM_Multi_Proc_Pkg.Post_Data_Slice(

2607: t_b_status.DELETE;
2608:
2609: END LOOP; -- bad_attr_vers
2610:
2611: FEM_Multi_Proc_Pkg.Post_Data_Slice(
2612: p_req_id => p_master_request_id,
2613: p_slc_id => v_slc_id,
2614: p_status => v_mp_status,
2615: p_message => v_mp_message,

Line 3185: FEM_Multi_Proc_Pkg.Get_Data_Slice(

3181: LOOP
3182:
3183: IF p_load_type <> ('DIMENSION_GROUP') THEN
3184:
3185: FEM_Multi_Proc_Pkg.Get_Data_Slice(
3186: x_slc_id => v_slc_id,
3187: x_slc_val1 => v_slc_val,
3188: x_slc_val2 => v_slc_val2,
3189: x_slc_val3 => v_slc_val3,

Line 4719: FEM_Multi_Proc_Pkg.Post_Data_Slice(

4715: COMMIT;
4716: END LOOP; -- New Members
4717:
4718: IF p_load_type <> ('DIMENSION_GROUP') THEN
4719: FEM_Multi_Proc_Pkg.Post_Data_Slice(
4720: p_req_id => p_master_request_id,
4721: p_slc_id => v_slc_id,
4722: p_status => v_mp_status,
4723: p_message => v_mp_message,

Line 5093: FEM_Multi_Proc_Pkg.Get_Data_Slice(

5089: LOOP
5090:
5091: IF p_load_type <> ('DIMENSION_GROUP') THEN
5092:
5093: FEM_Multi_Proc_Pkg.Get_Data_Slice(
5094: x_slc_id => v_slc_id,
5095: x_slc_val1 => v_slc_val,
5096: x_slc_val2 => v_slc_val2,
5097: x_slc_val3 => v_slc_val3,

Line 5407: FEM_Multi_Proc_Pkg.Post_Data_Slice(

5403: COMMIT;
5404: END LOOP; -- Bad TL members
5405:
5406: IF p_load_type <> ('DIMENSION_GROUP') THEN
5407: FEM_Multi_Proc_Pkg.Post_Data_Slice(
5408: p_req_id => p_master_request_id,
5409: p_slc_id => v_slc_id,
5410: p_status => v_mp_status,
5411: p_message => v_mp_message,

Line 5695: FEM_Multi_Proc_Pkg.Get_Data_Slice(

5691: LOOP
5692:
5693: IF p_load_type <> ('DIMENSION_GROUP') THEN
5694:
5695: FEM_Multi_Proc_Pkg.Get_Data_Slice(
5696: x_slc_id => v_slc_id,
5697: x_slc_val1 => v_slc_val,
5698: x_slc_val2 => v_slc_val2,
5699: x_slc_val3 => v_slc_val3,

Line 5938: FEM_Multi_Proc_Pkg.Post_Data_Slice(

5934: COMMIT;
5935: END LOOP; -- Remaining members BULK Collect
5936:
5937: IF p_load_type <> ('DIMENSION_GROUP') THEN
5938: FEM_Multi_Proc_Pkg.Post_Data_Slice(
5939: p_req_id => p_master_request_id,
5940: p_slc_id => v_slc_id,
5941: p_status => v_mp_status,
5942: p_message => v_mp_message,

Line 6403: FEM_Multi_Proc_Pkg.Get_Data_Slice(

6399: v_loop_counter := 0; -- used for DIMENSION_GROUP loads to identify when to exit
6400: -- the data slice loop
6401: LOOP
6402:
6403: FEM_Multi_Proc_Pkg.Get_Data_Slice(
6404: x_slc_id => v_slc_id,
6405: x_slc_val1 => v_slc_val,
6406: x_slc_val2 => v_slc_val2,
6407: x_slc_val3 => v_slc_val3,

Line 7652: FEM_Multi_Proc_Pkg.Post_Data_Slice(

7648:
7649: COMMIT;
7650: END LOOP; -- attribute loop
7651:
7652: FEM_Multi_Proc_Pkg.Post_Data_Slice(
7653: p_req_id => p_master_request_id,
7654: p_slc_id => v_slc_id,
7655: p_status => v_mp_status,
7656: p_message => v_mp_message,

Line 9061: FEM_Multi_Proc_Pkg.Get_Data_Slice(

9057: v_loop_counter := 0; -- used for DIMENSION_GROUP loads to identify when to exit
9058: -- the data slice loop
9059: LOOP
9060:
9061: FEM_Multi_Proc_Pkg.Get_Data_Slice(
9062: x_slc_id => v_slc_id,
9063: x_slc_val1 => v_slc_val,
9064: x_slc_val2 => v_slc_val2,
9065: x_slc_val3 => v_slc_val3,

Line 16276: fem_multi_proc_pkg.MASTER

16272:
16273: FEM_ENGINES_PKG.TECH_MESSAGE
16274: (c_log_level_3,c_block||'.'||c_proc_name||'.Start Mbr Pre_Validation',to_char(sysdate,'MM/DD/YYY:HH:MI:SS'));
16275:
16276: fem_multi_proc_pkg.MASTER
16277: (X_PRG_STAT => v_mp_prg_status
16278: ,X_EXCEPTION_CODE => v_mp_exception_code
16279: ,P_RULE_ID => p_object_id
16280: ,P_ENG_STEP => 'ALL'

Line 16341: fem_multi_proc_pkg.MASTER

16337: FEM_ENGINES_PKG.TECH_MESSAGE
16338: (c_log_level_3,c_block||'.'||c_proc_name||'.Start Mbr New_Members',to_char(sysdate,'MM/DD/YYY:HH:MI:SS'));
16339:
16340:
16341: fem_multi_proc_pkg.MASTER
16342: (X_PRG_STAT => v_mp_prg_status
16343: ,X_EXCEPTION_CODE => v_mp_exception_code
16344: ,P_RULE_ID => p_object_id
16345: ,P_ENG_STEP => 'ALL'

Line 16418: fem_multi_proc_pkg.MASTER

16414: calp_date_overlap_check(v_rows_rejected
16415: ,'NEW_MEMBERS');
16416: v_rows_rejected_accum := v_rows_rejected_accum + v_rows_rejected;
16417:
16418: fem_multi_proc_pkg.MASTER
16419: (X_PRG_STAT => v_mp_prg_status
16420: ,X_EXCEPTION_CODE => v_mp_exception_code
16421: ,P_RULE_ID => p_object_id
16422: ,P_ENG_STEP => 'ALL'

Line 16466: fem_multi_proc_pkg.MASTER

16462:
16463: FEM_ENGINES_PKG.TECH_MESSAGE
16464: (c_log_level_3,c_block||'.'||c_proc_name||'.Start Mbr Base_Update',to_char(sysdate,'MM/DD/YYY:HH:MI:SS'));
16465:
16466: fem_multi_proc_pkg.MASTER
16467: (X_PRG_STAT => v_mp_prg_status
16468: ,X_EXCEPTION_CODE => v_mp_exception_code
16469: ,P_RULE_ID => p_object_id
16470: ,P_ENG_STEP => 'ALL'

Line 16520: fem_multi_proc_pkg.MASTER

16516:
16517: FEM_ENGINES_PKG.TECH_MESSAGE
16518: (c_log_level_3,c_block||'.'||c_proc_name||'.Start Mbr TL_Update',to_char(sysdate,'MM/DD/YYY:HH:MI:SS'));
16519:
16520: fem_multi_proc_pkg.MASTER
16521: (X_PRG_STAT => v_mp_prg_status
16522: ,X_EXCEPTION_CODE => v_mp_exception_code
16523: ,P_RULE_ID => p_object_id
16524: ,P_ENG_STEP => 'ALL'

Line 16578: fem_multi_proc_pkg.MASTER

16574: IF (v_simple_dimension_flag = 'N') THEN
16575: FEM_ENGINES_PKG.TECH_MESSAGE
16576: (c_log_level_3,c_block||'.'||c_proc_name||'.Start Mbr Pre_Validation_Attr',to_char(sysdate,'MM/DD/YYY:HH:MI:SS'));
16577:
16578: fem_multi_proc_pkg.MASTER
16579: (X_PRG_STAT => v_mp_prg_status
16580: ,X_EXCEPTION_CODE => v_mp_exception_code
16581: ,P_RULE_ID => p_object_id
16582: ,P_ENG_STEP => 'ALL'

Line 16639: fem_multi_proc_pkg.MASTER

16635:
16636: FEM_ENGINES_PKG.TECH_MESSAGE
16637: (c_log_level_3,c_block||'.'||c_proc_name||'.Start Mbr Attr_Assign_Update',to_char(sysdate,'MM/DD/YYY:HH:MI:SS'));
16638:
16639: fem_multi_proc_pkg.MASTER
16640: (X_PRG_STAT => v_mp_prg_status
16641: ,X_EXCEPTION_CODE => v_mp_exception_code
16642: ,P_RULE_ID => p_object_id
16643: ,P_ENG_STEP => 'ALL'

Line 16698: fem_multi_proc_pkg.MASTER

16694: calp_date_overlap_check(v_rows_rejected
16695: ,'ATTR_ASSIGN_UPDATE');
16696: v_rows_rejected_accum := v_rows_rejected_accum + v_rows_rejected;
16697:
16698: fem_multi_proc_pkg.MASTER
16699: (X_PRG_STAT => v_mp_prg_status
16700: ,X_EXCEPTION_CODE => v_mp_exception_code
16701: ,P_RULE_ID => p_object_id
16702: ,P_ENG_STEP => 'ALL'

Line 16790: fem_multi_proc_pkg.MASTER

16786: --------------------------------------------------------------------------
16787: -- This procedure calls the MP Engine for the proc 'Process_rows'
16788: --------------------------------------------------------------------------
16789:
16790: fem_multi_proc_pkg.MASTER
16791: (X_PRG_STAT => v_mp_prg_status
16792: ,X_EXCEPTION_CODE => v_mp_exception_code
16793: ,P_RULE_ID => p_object_id
16794: ,P_ENG_STEP => 'ALL'