DBA Data[Home] [Help]

APPS.CZ_RULES_SEQ dependencies on DUAL

Line 67: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;

63:
64: PROCEDURE Initialize(x_err OUT NOCOPY NUMBER) IS
65: BEGIN
66: x_err:=0;
67: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
68: END Initialize;
69:
70: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
71: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 303: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;

299: BEGIN
300:
301: p_out_err:=0;
302:
303: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
304:
305: get_LCR
306: (p_model_id,p_rule_sequence_id,p_rule_id,
307: var_left_rule_id,var_right_rule_id,

Line 611: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;

607: BEGIN
608:
609: p_out_err:=0;
610:
611: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
612:
613: get_LCR
614: (p_model_id,p_rule_sequence_id,p_rule_id,
615: var_left_rule_id,var_right_rule_id,

Line 744: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;

740:
741: FND_MSG_PUB.initialize;
742: p_out_err:=0;
743:
744: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
745:
746: UPDATE CZ_EFFECTIVITY_SETS
747: SET effective_from=p_new_start_date,
748: effective_until=p_new_end_date