APPS.CZ_PS_COPY dependencies on CZ_SUB_CON_SETS

Line 61: Sequences(3).name:='CZ_SUB_CON_SETS_S';

57: BEGIN
58: numRecords:=0;
59: Sequences(1).name:='CZ_PS_NODES_S';
60: Sequences(2).name:='CZ_FILTER_SETS_S';
61: Sequences(3).name:='CZ_SUB_CON_SETS_S';
62: Sequences(4).name:='CZ_EXPRESSIONS_S';
63: Sequences(5).name:='CZ_RULES_S';
64: Sequences(6).name:='CZ_EXPRESSION_NODES_S';
65: Sequences(7).name:='CZ_POPULATORS_S';

Line 482: get_Next_Val(new_id,'CZ_SUB_CON_SETS_S');

478:
479: BEGIN
480:
481: IF p_old_sub_id IS NOT NULL THEN
482: get_Next_Val(new_id,'CZ_SUB_CON_SETS_S');
483: INSERT INTO CZ_SUB_CON_SETS
484: (SUB_CONS_ID,
485: NAME,
486: DESC_TEXT,

Line 483: INSERT INTO CZ_SUB_CON_SETS

479: BEGIN
480:
481: IF p_old_sub_id IS NOT NULL THEN
482: get_Next_Val(new_id,'CZ_SUB_CON_SETS_S');
483: INSERT INTO CZ_SUB_CON_SETS
484: (SUB_CONS_ID,
485: NAME,
486: DESC_TEXT,
487: DELETED_FLAG,

Line 496: FROM CZ_SUB_CON_SETS

492: DESC_TEXT,
493: DELETED_FLAG,
494: SECURITY_MASK,
495: CHECKOUT_USER
496: FROM CZ_SUB_CON_SETS
497: WHERE sub_cons_id=p_old_sub_id AND deleted_flag=NO_FLAG;
498:
499: PACK;
500:

Line 683: get_Next_Val(new_sub_cons_id,'CZ_SUB_CON_SETS_S');

679: ELSE
680: new_intl_text_id:=NULL;
681: END IF;
682:
683: get_Next_Val(new_sub_cons_id,'CZ_SUB_CON_SETS_S');
684: Copy_SUB_CON_SET(i.sub_cons_id,new_sub_cons_id);
685:
686: INSERT INTO CZ_PS_NODES
687: (PS_NODE_ID,