APPS.FEM_MULTI_PROC_PKG dependencies on FEM_MP_PROCESS_ARGS_T

Line 13: c_arg_table CONSTANT VARCHAR2(30) := 'FEM_MP_PROCESS_ARGS_T';

9:
10: c_max_procs CONSTANT NUMBER := 8;
11:
12: c_ctl_table CONSTANT VARCHAR2(30) := 'FEM_MP_PROCESS_CTL_T';
13: c_arg_table CONSTANT VARCHAR2(30) := 'FEM_MP_PROCESS_ARGS_T';
14:
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;

Line 1505: DELETE FROM fem_mp_process_args_t T

1501: WHERE phase_code = 'C')
1502: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1503: WHERE request_id = T.req_id));
1504:
1505: DELETE FROM fem_mp_process_args_t T
1506: WHERE rule_id = p_rule_id
1507: AND (req_id IN (SELECT request_id
1508: FROM fnd_concurrent_requests
1509: WHERE phase_code = 'C')

Line 1654: DELETE FROM fem_mp_process_args_t

1650:
1651: NOT running as a Restart -- Store new arguments
1652:
1653: ***********************************************************************/
1654: DELETE FROM fem_mp_process_args_t
1655: WHERE req_id = v_req_id;
1656:
1657: COMMIT;
1658:

Line 1683: p_msg_text => 'Inserting into FEM_MP_PROCESS_ARGS_T...');

1679:
1680: FEM_ENGINES_PKG.TECH_MESSAGE(
1681: p_severity => c_log_level_1,
1682: p_module => v_block||'.v_sql_cmd{525}',
1683: p_msg_text => 'Inserting into FEM_MP_PROCESS_ARGS_T...');
1684:
1685: INSERT INTO fem_mp_process_args_t
1686: (req_id,rule_id,eng_prg,eng_sql,slc_pred,arg_count,
1687: arg1,arg2,arg3,arg4,arg5,arg6,arg7,arg8,

Line 1685: INSERT INTO fem_mp_process_args_t

1681: p_severity => c_log_level_1,
1682: p_module => v_block||'.v_sql_cmd{525}',
1683: p_msg_text => 'Inserting into FEM_MP_PROCESS_ARGS_T...');
1684:
1685: INSERT INTO fem_mp_process_args_t
1686: (req_id,rule_id,eng_prg,eng_sql,slc_pred,arg_count,
1687: arg1,arg2,arg3,arg4,arg5,arg6,arg7,arg8,
1688: arg9,arg10,arg11,arg12,arg13,arg14,arg15,arg16,
1689: arg17,arg18,arg19,arg20,arg21,arg22,arg23,arg24,

Line 2119: FROM fem_mp_process_args_t

2115: IF (p_mp_method = 1)
2116: THEN
2117: SELECT rule_id,eng_prg,eng_sql,slc_pred,arg_count
2118: INTO v_rule_id,v_eng_prg,v_eng_sql_param,v_slc_pred,v_args_count
2119: FROM fem_mp_process_args_t
2120: WHERE req_id = p_req_id;
2121: ELSE
2122: SELECT
2123: rule_id,eng_prg,eng_sql,slc_pred,arg_count,

Line 2146: FROM fem_mp_process_args_t

2142: t_arg(25),t_arg(26),t_arg(27),t_arg(28),
2143: t_arg(29),t_arg(30),t_arg(31),t_arg(32),
2144: t_arg(33),t_arg(34),t_arg(35),t_arg(36),
2145: t_arg(37),t_arg(38),t_arg(39),t_arg(40)
2146: FROM fem_mp_process_args_t
2147: WHERE req_id = p_req_id;
2148: END IF;
2149:
2150: FEM_ENGINES_PKG.TECH_MESSAGE

Line 5330: DELETE FROM fem_mp_process_args_t

5326: WHERE req_id = p_req_id;
5327:
5328: COMMIT;
5329:
5330: DELETE FROM fem_mp_process_args_t
5331: WHERE req_id = p_req_id;
5332:
5333: COMMIT;
5334: