DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_FILTER_SETS

Line 60: Sequences(2).name:='CZ_FILTER_SETS_S';

56: PROCEDURE Initialize IS
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';

Line 406: FOR i IN (SELECT * FROM CZ_FILTER_SETS

402:
403: k:=FlowId_EXPRESSION.First;
404: LOOP
405: BEGIN
406: FOR i IN (SELECT * FROM CZ_FILTER_SETS
407: WHERE express_id=k AND deleted_flag=NO_FLAG)
408: LOOP
409: BEGIN
410: new_exp_id:=FlowId_EXPRESSION(k);

Line 414: get_Next_Val(new_id,'CZ_FILTER_SETS_S');

410: new_exp_id:=FlowId_EXPRESSION(k);
411:
412: IF (new_exp_id IS not NULL) or (new_exp_id<>NULL_) THEN
413:
414: get_Next_Val(new_id,'CZ_FILTER_SETS_S');
415:
416: INSERT INTO CZ_FILTER_SETS
417: (FILTER_SET_ID,
418: DEVL_PROJECT_ID,

Line 416: INSERT INTO CZ_FILTER_SETS

412: IF (new_exp_id IS not NULL) or (new_exp_id<>NULL_) THEN
413:
414: get_Next_Val(new_id,'CZ_FILTER_SETS_S');
415:
416: INSERT INTO CZ_FILTER_SETS
417: (FILTER_SET_ID,
418: DEVL_PROJECT_ID,
419: EXPRESS_ID,
420: SOURCE_TYPE,