DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_UTILS

Line 2828: new_EFFECTIVE_FROM:=CZ_UTILS.EPOCH_END_;

2824:
2825: IF p_rule_folder_id IS NOT NULL AND p_rule_folder_id<>-1 THEN
2826: new_RULE_FOLDER_ID:=p_rule_folder_id;
2827: new_EFFECTIVITY_SET_ID:=NULL;
2828: new_EFFECTIVE_FROM:=CZ_UTILS.EPOCH_END_;
2829: new_EFFECTIVE_UNTIL:=CZ_UTILS.EPOCH_BEGIN_;
2830: SELECT NVL(MAX(SEQ_NBR),0)+1 INTO new_SEQ_NBR FROM CZ_RULES
2831: WHERE rule_folder_id=p_rule_folder_id AND deleted_flag=NO_FLAG;
2832: ELSE

Line 2829: new_EFFECTIVE_UNTIL:=CZ_UTILS.EPOCH_BEGIN_;

2825: IF p_rule_folder_id IS NOT NULL AND p_rule_folder_id<>-1 THEN
2826: new_RULE_FOLDER_ID:=p_rule_folder_id;
2827: new_EFFECTIVITY_SET_ID:=NULL;
2828: new_EFFECTIVE_FROM:=CZ_UTILS.EPOCH_END_;
2829: new_EFFECTIVE_UNTIL:=CZ_UTILS.EPOCH_BEGIN_;
2830: SELECT NVL(MAX(SEQ_NBR),0)+1 INTO new_SEQ_NBR FROM CZ_RULES
2831: WHERE rule_folder_id=p_rule_folder_id AND deleted_flag=NO_FLAG;
2832: ELSE
2833: new_RULE_FOLDER_ID:=i.RULE_FOLDER_ID;