eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_POPULATORS_PKG dependencies on CZ_POPULATORS

Line 1: PACKAGE BODY CZ_POPULATORS_PKG AS

1: PACKAGE BODY CZ_POPULATORS_PKG AS
2: /* $Header: czpopb.pls 120.8.12010000.2 2008/09/08 12:07:32 vsingava ship $ */
3:
4: ITEMS_POP CONSTANT INTEGER:=1;
5: ITEM_TYPES_POP CONSTANT INTEGER:=2;

Line 110: 'CZ_POPULATORS_PKG',

106: (p_run_id,
107: SYSDATE,
108: USER,
109: 1,
110: 'CZ_POPULATORS_PKG',
111: 11276,
112: fnd_msg_pub.GET(i,fnd_api.g_false),
113: mCOUNTER);
114: COMMIT;

Line 195: LOG_REPORT('CZ_POPULATORS_PKG.lock_Model',l_msg_data);

191: l_msg_index := 1;
192: WHILE l_msg_count > 0
193: LOOP
194: l_msg_data := fnd_msg_pub.get(l_msg_index,fnd_api.g_false);
195: LOG_REPORT('CZ_POPULATORS_PKG.lock_Model',l_msg_data);
196: l_msg_index := l_msg_index + 1;
197: l_msg_count := l_msg_count - 1;
198: END LOOP;
199: FND_MSG_PUB.initialize;

Line 327: var_view_name CZ_POPULATORS.view_name%TYPE;

323: (p_populator_id IN INTEGER,
324: p_view_name IN OUT NOCOPY VARCHAR2,
325: p_sql_query IN OUT NOCOPY VARCHAR2,
326: p_err OUT NOCOPY INTEGER) IS
327: var_view_name CZ_POPULATORS.view_name%TYPE;
328: var_based_view CZ_POPULATORS.view_name%TYPE;
329: var_sql CZ_POPULATORS.query_syntax%TYPE;
330: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
331: var_source_type CZ_FILTER_SETS.source_type%TYPE;

Line 328: var_based_view CZ_POPULATORS.view_name%TYPE;

324: p_view_name IN OUT NOCOPY VARCHAR2,
325: p_sql_query IN OUT NOCOPY VARCHAR2,
326: p_err OUT NOCOPY INTEGER) IS
327: var_view_name CZ_POPULATORS.view_name%TYPE;
328: var_based_view CZ_POPULATORS.view_name%TYPE;
329: var_sql CZ_POPULATORS.query_syntax%TYPE;
330: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
331: var_source_type CZ_FILTER_SETS.source_type%TYPE;
332: var_rule_id CZ_FILTER_SETS.express_id%TYPE;

Line 329: var_sql CZ_POPULATORS.query_syntax%TYPE;

325: p_sql_query IN OUT NOCOPY VARCHAR2,
326: p_err OUT NOCOPY INTEGER) IS
327: var_view_name CZ_POPULATORS.view_name%TYPE;
328: var_based_view CZ_POPULATORS.view_name%TYPE;
329: var_sql CZ_POPULATORS.query_syntax%TYPE;
330: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
331: var_source_type CZ_FILTER_SETS.source_type%TYPE;
332: var_rule_id CZ_FILTER_SETS.express_id%TYPE;
333: var_operator CZ_EXPRESSION_NODES.expr_subtype%TYPE;

Line 336: var_pop_name CZ_POPULATORS.name%TYPE;

332: var_rule_id CZ_FILTER_SETS.express_id%TYPE;
333: var_operator CZ_EXPRESSION_NODES.expr_subtype%TYPE;
334: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;
335: var_name CZ_PS_NODES.name%TYPE;
336: var_pop_name CZ_POPULATORS.name%TYPE;
337: var_property_id CZ_PROPERTIES.property_id%TYPE;
338: var_item_type_id CZ_ITEM_TYPES.item_type_id%TYPE;
339: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;
340: var_desc_text CZ_ITEM_MASTERS.desc_text%TYPE;

Line 345: var_ps_node_id CZ_POPULATORS.owned_by_node_id%TYPE;

341: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
342: var_quoteable_flag CZ_ITEM_MASTERS.quoteable_flag%TYPE;
343: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
344: var_model_id CZ_PS_NODES.devl_project_id%TYPE;
345: var_ps_node_id CZ_POPULATORS.owned_by_node_id%TYPE;
346: var_level INTEGER;
347: var_current VARCHAR2(1);
348: var_filter VARCHAR2(4000);
349: var_filter1 VARCHAR2(4000);

Line 364: FROM CZ_POPULATORS

360: p_err:=0;
361:
362: SELECT filter_set_id,view_name,result_type,var_ps_node_id,query_syntax,name
363: INTO var_filter_set_id,var_view_name,var_ps_node_type,var_ps_node_id,var_sql,var_pop_name
364: FROM CZ_POPULATORS
365: WHERE populator_id=p_populator_id;
366:
367: BEGIN
368: SELECT a.source_type,a.rule_id,b.view_name

Line 370: FROM CZ_FILTER_SETS a, CZ_POPULATORS b

366:
367: BEGIN
368: SELECT a.source_type,a.rule_id,b.view_name
369: INTO var_source_type,var_rule_id,var_based_view
370: FROM CZ_FILTER_SETS a, CZ_POPULATORS b
371: WHERE a.filter_set_id=var_filter_set_id AND a.source_type=b.populator_id;
372: EXCEPTION
373: WHEN OTHERS THEN
374: there_is_no_seed_data:=TRUE;

Line 402: UPDATE CZ_POPULATORS SET query_syntax=var_sql, last_generation_date=SYSDATE

398: IF var_based_view<>USER_VIEW THEN
399: var_sql:='select * from '||var_based_view||' where '||get_Where(var_rule_id);
400: END IF;
401:
402: UPDATE CZ_POPULATORS SET query_syntax=var_sql, last_generation_date=SYSDATE
403: WHERE populator_id=p_populator_id;
404:
405: --
406: -- this approach is very slow --

Line 414: UPDATE CZ_POPULATORS SET view_name=p_view_name WHERE populator_id=p_populator_id;

410: IF p_view_name IS NULL OR p_view_name='' THEN
411: p_view_name:='CZ_POP_'||TO_CHAR(p_populator_id)||'_V';
412: END IF;
413: EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW '||p_view_name||' AS '||var_sql;
414: UPDATE CZ_POPULATORS SET view_name=p_view_name WHERE populator_id=p_populator_id;
415: END IF;
416:
417: p_sql_query:=var_sql;
418:

Line 422: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : definition was deleted.');

418:
419: EXCEPTION
420: WHEN DELETED_EXPRESSION THEN
421: p_err:=mRUN_ID;
422: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : definition was deleted.');
423: WHEN WRONG_SQL THEN
424: p_err:=mRUN_ID;
425: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);
426: WHEN OTHERS THEN

Line 425: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);

421: p_err:=mRUN_ID;
422: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : definition was deleted.');
423: WHEN WRONG_SQL THEN
424: p_err:=mRUN_ID;
425: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);
426: WHEN OTHERS THEN
427: p_err:=mRUN_ID;
428: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : '||SQLERRM);
429: END Regenerate_unsec;

Line 428: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : '||SQLERRM);

424: p_err:=mRUN_ID;
425: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);
426: WHEN OTHERS THEN
427: p_err:=mRUN_ID;
428: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : '||SQLERRM);
429: END Regenerate_unsec;
430:
431: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
432: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 466: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS

462: --
463: IF mDB_SETTING_USE_SECURITY THEN
464:
465: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
466: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
467: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
468:
469: lock_Model(l_model_id, l_locked_entities_tbl);
470:

Line 501: var_pop_name CZ_POPULATORS.name%TYPE;

497: TYPE t_rec_cols IS TABLE OF rec_cols INDEX BY BINARY_INTEGER;
498: TYPE NamesArray IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
499: t_names NamesArray;
500: t_col t_rec_cols;
501: var_pop_name CZ_POPULATORS.name%TYPE;
502: var_view_name CZ_POPULATORS.view_name%TYPE;
503: var_last_update CZ_POPULATORS.last_update_date%TYPE;
504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

Line 502: var_view_name CZ_POPULATORS.view_name%TYPE;

498: TYPE NamesArray IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
499: t_names NamesArray;
500: t_col t_rec_cols;
501: var_pop_name CZ_POPULATORS.name%TYPE;
502: var_view_name CZ_POPULATORS.view_name%TYPE;
503: var_last_update CZ_POPULATORS.last_update_date%TYPE;
504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;

Line 503: var_last_update CZ_POPULATORS.last_update_date%TYPE;

499: t_names NamesArray;
500: t_col t_rec_cols;
501: var_pop_name CZ_POPULATORS.name%TYPE;
502: var_view_name CZ_POPULATORS.view_name%TYPE;
503: var_last_update CZ_POPULATORS.last_update_date%TYPE;
504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;

Line 504: var_result_type CZ_POPULATORS.result_type%TYPE;

500: t_col t_rec_cols;
501: var_pop_name CZ_POPULATORS.name%TYPE;
502: var_view_name CZ_POPULATORS.view_name%TYPE;
503: var_last_update CZ_POPULATORS.last_update_date%TYPE;
504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;
508: var_has_item CZ_POPULATORS.has_item%TYPE;

Line 506: var_sql CZ_POPULATORS.query_syntax%TYPE;

502: var_view_name CZ_POPULATORS.view_name%TYPE;
503: var_last_update CZ_POPULATORS.last_update_date%TYPE;
504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;
508: var_has_item CZ_POPULATORS.has_item%TYPE;
509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;
510: var_has_property CZ_POPULATORS.has_property%TYPE;

Line 507: var_has_level CZ_POPULATORS.has_level%TYPE;

503: var_last_update CZ_POPULATORS.last_update_date%TYPE;
504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;
508: var_has_item CZ_POPULATORS.has_item%TYPE;
509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;
510: var_has_property CZ_POPULATORS.has_property%TYPE;
511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;

Line 508: var_has_item CZ_POPULATORS.has_item%TYPE;

504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;
508: var_has_item CZ_POPULATORS.has_item%TYPE;
509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;
510: var_has_property CZ_POPULATORS.has_property%TYPE;
511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
512: var_express_id CZ_EXPRESSIONS.express_id%TYPE;

Line 509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;

505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;
508: var_has_item CZ_POPULATORS.has_item%TYPE;
509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;
510: var_has_property CZ_POPULATORS.has_property%TYPE;
511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
512: var_express_id CZ_EXPRESSIONS.express_id%TYPE;
513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;

Line 510: var_has_property CZ_POPULATORS.has_property%TYPE;

506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;
508: var_has_item CZ_POPULATORS.has_item%TYPE;
509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;
510: var_has_property CZ_POPULATORS.has_property%TYPE;
511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
512: var_express_id CZ_EXPRESSIONS.express_id%TYPE;
513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;

Line 612: FROM CZ_POPULATORS

608: SELECT filter_set_id,last_generation_date,view_name,owned_by_node_id,
609: result_type,query_syntax,has_level,feature_type,name
610: INTO var_filter_set_id,var_last_update,var_view_name,var_ps_node_id,
611: var_result_type,var_sql,var_has_level,var_feature_type,var_pop_name
612: FROM CZ_POPULATORS
613: WHERE populator_id=p_populator_id;
614:
615: --
616: -- convert result_type to ps_node_type

Line 856: LOG_REPORT('CZ_POPULATORS_PKG.preview','Updating previous entry');

852:
853: IF ps_node_already_exists AND exists_in_t_names THEN
854:
855: -- Need to update the previous entry
856: LOG_REPORT('CZ_POPULATORS_PKG.preview','Updating previous entry');
857: UPDATE CZ_IMP_PS_NODES
858: SET PROPERTY_BACKPTR = var_property_ptr,ITEM_TYPE_BACKPTR = var_item_type_ptr,INTL_TEXT_ID = var_new_text_id,
859: ITEM_ID = var_item_id,USER_STR03 = var_key,FSK_PSNODE_3_EXT = var_fk_key,
860: PRIMARY_UOM_CODE = var_primary_uom_code,

Line 869: LOG_REPORT('CZ_POPULATORS_PKG.preview','Skipping entry :'||var_name);

865: PARENT_ID = var_ps_node_id AND NAME = var_name;
866: -- Implies we encountered the new node later to old node or another new node
867: ELSE
868: IF(NOT ps_node_already_exists) AND exists_in_t_names THEN-- Implies we encountered the new node later to old node or another new node
869: LOG_REPORT('CZ_POPULATORS_PKG.preview','Skipping entry :'||var_name);
870: RAISE SKIP_IT;
871: ELSE
872: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
873: -- Need to INSERT

Line 876: LOG_REPORT('CZ_POPULATORS_PKG.preview','Inserting entry :'||var_name);

872: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
873: -- Need to INSERT
874: t_names(t_names.Count+1):=var_name;
875: var_tree_seq:=var_tree_seq+1;
876: LOG_REPORT('CZ_POPULATORS_PKG.preview','Inserting entry :'||var_name);
877:
878: INSERT INTO CZ_IMP_PS_NODES
879: (RUN_ID,
880: PS_NODE_ID,

Line 961: --UPDATE CZ_POPULATORS SET has_item_type=var_has_item_type,

957:
958: --
959: -- set descriptive fields --
960: --
961: --UPDATE CZ_POPULATORS SET has_item_type=var_has_item_type,
962: -- has_item=var_has_item,
963: -- has_property=var_has_property
964: --WHERE populator_id=p_populator_id;
965:

Line 972: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);

968: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
969: DBMS_SQL.CLOSE_CURSOR(var_cursor);
970: END IF;
971: p_err:=mRUN_ID;
972: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);
973: WHEN WRONG_SQL THEN
974: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
975: DBMS_SQL.CLOSE_CURSOR(var_cursor);
976: END IF;

Line 978: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);

974: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
975: DBMS_SQL.CLOSE_CURSOR(var_cursor);
976: END IF;
977: p_err:=mRUN_ID;
978: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);
979: WHEN OTHERS THEN
980: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
981: DBMS_SQL.CLOSE_CURSOR(var_cursor);
982: END IF;

Line 984: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);

980: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
981: DBMS_SQL.CLOSE_CURSOR(var_cursor);
982: END IF;
983: p_err:=mRUN_ID;
984: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);
985: END Preview_unsec;
986:
987: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
988: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 1021: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS

1017: --
1018: IF mDB_SETTING_USE_SECURITY THEN
1019:
1020: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1021: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1022: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1023:
1024: lock_Model(l_model_id, l_locked_entities_tbl);
1025:

Line 1064: var_pop_name CZ_POPULATORS.name%TYPE;

1060: var_failed INTEGER;
1061: var_dups INTEGER;
1062: var_tree_seq INTEGER;
1063: var_name_counter INTEGER;
1064: var_pop_name CZ_POPULATORS.name%TYPE;
1065: var_name CZ_PS_NODES.name%TYPE;
1066: var_view CZ_POPULATORS.view_name%TYPE;
1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;

Line 1066: var_view CZ_POPULATORS.view_name%TYPE;

1062: var_tree_seq INTEGER;
1063: var_name_counter INTEGER;
1064: var_pop_name CZ_POPULATORS.name%TYPE;
1065: var_name CZ_PS_NODES.name%TYPE;
1066: var_view CZ_POPULATORS.view_name%TYPE;
1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1070: var_component_id CZ_PS_NODES.component_id%TYPE;

Line 1067: var_sql CZ_POPULATORS.query_syntax%TYPE;

1063: var_name_counter INTEGER;
1064: var_pop_name CZ_POPULATORS.name%TYPE;
1065: var_name CZ_PS_NODES.name%TYPE;
1066: var_view CZ_POPULATORS.view_name%TYPE;
1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1070: var_component_id CZ_PS_NODES.component_id%TYPE;
1071: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;

Line 1094: FROM CZ_POPULATORS WHERE populator_id=p_populator_id;

1090: --
1091: -- find owner of Populator --
1092: --
1093: SELECT owned_by_node_id,name INTO var_parent_id,var_pop_name
1094: FROM CZ_POPULATORS WHERE populator_id=p_populator_id;
1095:
1096: SELECT component_id INTO var_component_id FROM CZ_PS_NODES
1097: WHERE ps_node_id=var_parent_id;
1098:

Line 1151: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Populator failed ...');

1147: mXFR_PROJECT_GROUP);
1148:
1149: IF var_failed>0 THEN
1150: p_err:=mRUN_ID;
1151: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Populator failed ...');
1152: END IF;
1153: RAISE STOP_IT;
1154: END IF;
1155:

Line 1331: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Execute populator "'||var_pop_name||'" failed : '||SQLERRM);

1327: WHEN STOP_IT THEN
1328: NULL;
1329: WHEN OTHERS THEN
1330: p_err:=mRUN_ID;
1331: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Execute populator "'||var_pop_name||'" failed : '||SQLERRM);
1332: END Execute_unsec;
1333:
1334: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1335: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 1368: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS

1364: --
1365: IF mDB_SETTING_USE_SECURITY THEN
1366:
1367: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1368: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1369: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1370:
1371: lock_Model(l_model_id, l_locked_entities_tbl);
1372:

Line 1408: var_sql CZ_POPULATORS.query_syntax%TYPE;

1404: var_err INTEGER;
1405: var_err_id INTEGER;
1406: var_counter INTEGER:=0;
1407: var_view VARCHAR2(100);
1408: var_sql CZ_POPULATORS.query_syntax%TYPE;
1409: SKIP_IT EXCEPTION;
1410: MODEL_DOES_NOT_EXIST EXCEPTION;
1411: BEGIN
1412:

Line 1426: FOR i IN(SELECT populator_id FROM CZ_POPULATORS a,CZ_PS_NODES b

1422: WHEN NO_DATA_FOUND THEN
1423: RAISE MODEL_DOES_NOT_EXIST;
1424: END;
1425:
1426: FOR i IN(SELECT populator_id FROM CZ_POPULATORS a,CZ_PS_NODES b
1427: WHERE a.owned_by_node_id=b.ps_node_id AND b.devl_project_id=p_model_id AND
1428: a.deleted_flag='0' AND b.deleted_flag='0')
1429: LOOP
1430: var_counter:=var_counter+1;

Line 1475: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',

1471:
1472: EXCEPTION
1473: WHEN MODEL_DOES_NOT_EXIST THEN
1474: p_err:=mRUN_ID;
1475: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',
1476: 'Model with model_id='||TO_CHAR(p_model_id)||' does not exist.');
1477: END Repopulate_unsec;
1478:
1479: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 1571: END CZ_POPULATORS_PKG;

1567: mALWAYS_REGENERATE := 'N';
1568: END;
1569:
1570:
1571: END CZ_POPULATORS_PKG;