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.10.12020000.2 2012/08/17 15:27:12 smanna ship $ */
3:
4: ITEMS_POP CONSTANT INTEGER:=1;
5: ITEM_TYPES_POP CONSTANT INTEGER:=2;

Line 113: 'CZ_POPULATORS_PKG',

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

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

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

Line 330: var_view_name CZ_POPULATORS.view_name%TYPE;

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

Line 331: var_based_view CZ_POPULATORS.view_name%TYPE;

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

Line 332: var_sql CZ_POPULATORS.query_syntax%TYPE;

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

Line 339: var_pop_name CZ_POPULATORS.name%TYPE;

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

Line 348: var_ps_node_id CZ_POPULATORS.owned_by_node_id%TYPE;

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

Line 367: FROM CZ_POPULATORS

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

Line 373: FROM CZ_FILTER_SETS a, CZ_POPULATORS b

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

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

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

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

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

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

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

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

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

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

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

Line 469: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS

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

Line 504: var_pop_name CZ_POPULATORS.name%TYPE;

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

Line 505: var_view_name CZ_POPULATORS.view_name%TYPE;

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

Line 506: var_last_update CZ_POPULATORS.last_update_date%TYPE;

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

Line 507: var_result_type CZ_POPULATORS.result_type%TYPE;

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

Line 509: var_sql CZ_POPULATORS.query_syntax%TYPE;

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

Line 510: var_has_level CZ_POPULATORS.has_level%TYPE;

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

Line 511: var_has_item CZ_POPULATORS.has_item%TYPE;

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

Line 512: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;

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

Line 513: var_has_property CZ_POPULATORS.has_property%TYPE;

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

Line 616: FROM CZ_POPULATORS

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

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

858:
859: IF ps_node_already_exists AND exists_in_t_names THEN
860:
861: -- Need to update the previous entry
862: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Updating previous entry');
863: UPDATE CZ_IMP_PS_NODES
864: SET PROPERTY_BACKPTR = var_property_ptr,ITEM_TYPE_BACKPTR = var_item_type_ptr,INTL_TEXT_ID = var_new_text_id,
865: ITEM_ID = var_item_id,USER_STR03 = var_key,FSK_PSNODE_3_EXT = var_fk_key,
866: PRIMARY_UOM_CODE = var_primary_uom_code,

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

871: PARENT_ID = var_ps_node_id AND NAME = var_name;
872: -- Implies we encountered the new node later to old node or another new node
873: ELSE
874: 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
875: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Skipping entry :'||var_name);
876: RAISE SKIP_IT;
877: ELSE
878: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
879: -- Need to INSERT

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

878: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
879: -- Need to INSERT
880: t_names(t_names.Count+1):=var_name;
881: var_tree_seq:=var_tree_seq+1;
882: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Inserting entry :'||var_name);
883:
884: --Bug8584377
885: IF (NOT ps_node_already_exists) THEN
886: var_new_text_id := get_Next_Seq_Id(mINTL_TEXT_SEQUENCE);

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

968:
969: --
970: -- set descriptive fields --
971: --
972: --UPDATE CZ_POPULATORS SET has_item_type=var_has_item_type,
973: -- has_item=var_has_item,
974: -- has_property=var_has_property
975: --WHERE populator_id=p_populator_id;
976:

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

979: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
980: DBMS_SQL.CLOSE_CURSOR(var_cursor);
981: END IF;
982: p_err:=mRUN_ID;
983: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);
984: WHEN WRONG_SQL THEN
985: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
986: DBMS_SQL.CLOSE_CURSOR(var_cursor);
987: END IF;

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

985: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
986: DBMS_SQL.CLOSE_CURSOR(var_cursor);
987: END IF;
988: p_err:=mRUN_ID;
989: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);
990: WHEN OTHERS THEN
991: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
992: DBMS_SQL.CLOSE_CURSOR(var_cursor);
993: END IF;

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

991: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
992: DBMS_SQL.CLOSE_CURSOR(var_cursor);
993: END IF;
994: p_err:=mRUN_ID;
995: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);
996: END Preview_unsec;
997:
998: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
999: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 1032: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS

1028: --
1029: IF mDB_SETTING_USE_SECURITY THEN
1030:
1031: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1032: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1033: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1034:
1035: lock_Model(l_model_id, l_locked_entities_tbl);
1036:

Line 1076: var_pop_name CZ_POPULATORS.name%TYPE;

1072: var_dups INTEGER;
1073: var_nochange INTEGER;/*Meant for nochange in disposition*/
1074: var_tree_seq INTEGER;
1075: var_name_counter INTEGER;
1076: var_pop_name CZ_POPULATORS.name%TYPE;
1077: var_name CZ_PS_NODES.name%TYPE;
1078: var_view CZ_POPULATORS.view_name%TYPE;
1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;

Line 1078: var_view CZ_POPULATORS.view_name%TYPE;

1074: var_tree_seq INTEGER;
1075: var_name_counter INTEGER;
1076: var_pop_name CZ_POPULATORS.name%TYPE;
1077: var_name CZ_PS_NODES.name%TYPE;
1078: var_view CZ_POPULATORS.view_name%TYPE;
1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1082: var_component_id CZ_PS_NODES.component_id%TYPE;

Line 1079: var_sql CZ_POPULATORS.query_syntax%TYPE;

1075: var_name_counter INTEGER;
1076: var_pop_name CZ_POPULATORS.name%TYPE;
1077: var_name CZ_PS_NODES.name%TYPE;
1078: var_view CZ_POPULATORS.view_name%TYPE;
1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1082: var_component_id CZ_PS_NODES.component_id%TYPE;
1083: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;

Line 1106: FROM CZ_POPULATORS WHERE populator_id=p_populator_id;

1102: --
1103: -- find owner of Populator --
1104: --
1105: SELECT owned_by_node_id,name INTO var_parent_id,var_pop_name
1106: FROM CZ_POPULATORS WHERE populator_id=p_populator_id;
1107:
1108: SELECT component_id INTO var_component_id FROM CZ_PS_NODES
1109: WHERE ps_node_id=var_parent_id;
1110:

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

1161: mXFR_PROJECT_GROUP);
1162:
1163: IF var_failed>0 THEN
1164: p_err:=mRUN_ID;
1165: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Populator failed ...');
1166: END IF;
1167: RAISE STOP_IT;
1168: END IF;
1169:

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

1353: WHEN STOP_IT THEN
1354: NULL;
1355: WHEN OTHERS THEN
1356: p_err:=mRUN_ID;
1357: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Execute populator "'||var_pop_name||'" failed : '||SQLERRM);
1358: END Execute_unsec;
1359:
1360: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1361: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 1394: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS

1390: --
1391: IF mDB_SETTING_USE_SECURITY THEN
1392:
1393: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1394: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1395: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1396:
1397: lock_Model(l_model_id, l_locked_entities_tbl);
1398:

Line 1434: var_sql CZ_POPULATORS.query_syntax%TYPE;

1430: var_err INTEGER;
1431: var_err_id INTEGER;
1432: var_counter INTEGER:=0;
1433: var_view VARCHAR2(100);
1434: var_sql CZ_POPULATORS.query_syntax%TYPE;
1435: SKIP_IT EXCEPTION;
1436: MODEL_DOES_NOT_EXIST EXCEPTION;
1437: BEGIN
1438:

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

1448: WHEN NO_DATA_FOUND THEN
1449: RAISE MODEL_DOES_NOT_EXIST;
1450: END;
1451:
1452: FOR i IN(SELECT populator_id FROM CZ_POPULATORS a,CZ_PS_NODES b
1453: WHERE a.owned_by_node_id=b.ps_node_id AND b.devl_project_id=p_model_id AND
1454: a.deleted_flag='0' AND b.deleted_flag='0')
1455: LOOP
1456: var_counter:=var_counter+1;

Line 1501: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',

1497:
1498: EXCEPTION
1499: WHEN MODEL_DOES_NOT_EXIST THEN
1500: p_err:=mRUN_ID;
1501: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',
1502: 'Model with model_id='||TO_CHAR(p_model_id)||' does not exist.');
1503: END Repopulate_unsec;
1504:
1505: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 1597: END CZ_POPULATORS_PKG;

1593: mALWAYS_REGENERATE := 'N';
1594: END;
1595:
1596:
1597: END CZ_POPULATORS_PKG;