APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on DBMS_LOCK

Line 1177: DBMS_LOCK.ALLOCATE_UNIQUE(

1173:
1174: x_completion_code := 0;
1175: v_rows_processed := 0;
1176:
1177: DBMS_LOCK.ALLOCATE_UNIQUE(
1178: 'FEM_INTG_DIM_RULE' || FEM_INTG_DIM_RULE_ENG_PKG.pv_fem_vs_id,
1179: v_lockhandle,
1180: pc_expiration_secs
1181: );

Line 1197: v_lock_result := DBMS_LOCK.REQUEST(

1193: );
1194: RAISE FEM_INTG_DIM_RULE_ulock_err;
1195: END IF;
1196:
1197: v_lock_result := DBMS_LOCK.REQUEST(
1198: v_lockhandle,
1199: pc_lockmode,
1200: pc_lock_timeout,
1201: pc_release_on_commit

Line 1215: DBMS_LOCK.SLEEP(pc_sleep_second);

1211: p_severity => pc_log_level_statement
1212: ,p_module => pc_module_name||c_func_name
1213: ,p_msg_text => 'sleeping ' || pc_sleep_second || ' second'
1214: );
1215: DBMS_LOCK.SLEEP(pc_sleep_second);
1216: END IF;
1217: END LOOP;
1218:
1219: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label <> 'GEOGRAPHY'

Line 1905: DBMS_LOCK.ALLOCATE_UNIQUE(

1901: p_msg_text => 'begin '||FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label||
1902: ' dimension member population'
1903: );
1904:
1905: DBMS_LOCK.ALLOCATE_UNIQUE(
1906: 'FEM_INTG_DIM_RULE' || FEM_INTG_DIM_RULE_ENG_PKG.pv_fem_vs_id,
1907: v_lockhandle,
1908: pc_expiration_secs
1909: );

Line 1925: v_lock_result := DBMS_LOCK.REQUEST(

1921:
1922: RAISE FEM_INTG_DIM_RULE_ulock_err;
1923: END IF;
1924:
1925: v_lock_result := DBMS_LOCK.REQUEST(
1926: v_lockhandle,
1927: pc_lockmode,
1928: pc_lock_timeout,
1929: pc_release_on_commit

Line 1943: DBMS_LOCK.SLEEP(pc_sleep_second);

1939: p_module => v_module_name || '.ulock_sleep',
1940: p_msg_text => 'sleeping ' || pc_sleep_second || ' second'
1941: );
1942:
1943: DBMS_LOCK.SLEEP(pc_sleep_second);
1944: END IF;
1945:
1946: END LOOP;
1947:

Line 2105: DBMS_LOCK.SLEEP(pc_sleep_second);

2101: AND idr.dimension_id <> 0
2102: --End bug fix 5560443
2103: AND fcr.argument1 = fodb.object_definition_id
2104: AND fcr.argument2 = 'MEMBER');
2105: DBMS_LOCK.SLEEP(pc_sleep_second);
2106: EXCEPTION WHEN NO_DATA_FOUND THEN EXIT;
2107: END;
2108: END LOOP;
2109:

Line 2449: DBMS_LOCK.ALLOCATE_UNIQUE(

2445: ,p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2446:
2447:
2448:
2449: DBMS_LOCK.ALLOCATE_UNIQUE(
2450: 'FEM_INTG_DIM_RULE' || FEM_INTG_DIM_RULE_ENG_PKG.pv_fem_vs_id,
2451: v_lockhandle,
2452: pc_expiration_secs
2453: );

Line 2470: v_lock_result := DBMS_LOCK.REQUEST(

2466: --piush_util.put_line('Raising exception FEM_INTG_DIM_RULE_ulock_err');
2467: RAISE FEM_INTG_DIM_RULE_ulock_err;
2468: END IF;
2469:
2470: v_lock_result := DBMS_LOCK.REQUEST(
2471: v_lockhandle,
2472: pc_lockmode,
2473: pc_lock_timeout,
2474: pc_release_on_commit

Line 2489: DBMS_LOCK.SLEEP(pc_sleep_second);

2485: ,p_module => pc_module_name||c_func_name
2486: ,p_msg_text => 'sleeping ' || pc_sleep_second || ' second'
2487: );
2488:
2489: DBMS_LOCK.SLEEP(pc_sleep_second);
2490: END IF;
2491: END LOOP;
2492: pv_progress := 'Start dynamic building of GT insert';
2493: --piush_util.put_line(pv_progress);

Line 4028: DBMS_LOCK.SLEEP(pc_sleep_second);

4024: AND idr.dimension_id <> 0
4025: --End bug fix 5560443
4026: AND fcr.argument1 = fodb.object_definition_id
4027: AND fcr.argument2 = 'MEMBER');
4028: DBMS_LOCK.SLEEP(pc_sleep_second);
4029: EXCEPTION WHEN NO_DATA_FOUND THEN EXIT;
4030: END;
4031: END LOOP;
4032: