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.MRP_KANBAN_SNAPSHOT_PK dependencies on FLM_UTIL

Line 400: package 'flm_util', where we use bind variables. */

396: p_where OUT NOCOPY VARCHAR2 )
397: RETURN BOOLEAN IS
398:
399: /* This function is obsoleted since we now use the same-named function in
400: package 'flm_util', where we use bind variables. */
401:
402: BEGIN
403:
404: RETURN TRUE;

Line 426: package 'flm_util', where we use bind variables. */

422: p_where OUT NOCOPY VARCHAR2 )
423: RETURN BOOLEAN IS
424:
425: /* This function is obsoleted since we now use the same-named function in
426: package 'flm_util', where we use bind variables. */
427:
428: BEGIN
429:
430: RETURN TRUE;

Line 639: flm_util.init_bind;

635:
636: -- now lets go ahead and build our dynamic sql statement based on
637: -- the item/category range and category set parameter values
638:
639: flm_util.init_bind;
640:
641: -- include category set in the sql stmt
642: l_additional_tables := ' mtl_item_categories mic, ';
643: l_additional_where :=

Line 662: l_ret_val := flm_util.Item_Where_Clause(

658: IF mrp_kanban_plan_pk.g_kanban_info_rec.from_item IS NOT NULL OR
659: mrp_kanban_plan_pk.g_kanban_info_rec.to_item IS NOT NULL THEN
660:
661: -- call the function that builds the item where clause
662: l_ret_val := flm_util.Item_Where_Clause(
663: mrp_kanban_plan_pk.g_kanban_info_rec.from_item,
664: mrp_kanban_plan_pk.g_kanban_info_rec.to_item,
665: 'msi',
666: l_item_where_clause,

Line 701: l_ret_val := flm_util.Category_Where_Clause(

697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR
698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND
699: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id IS NOT NULL THEN
700:
701: l_ret_val := flm_util.Category_Where_Clause(
702: mrp_kanban_plan_pk.g_kanban_info_rec.from_category,
703: mrp_kanban_plan_pk.g_kanban_info_rec.to_category,
704: 'mcat',
705: mrp_kanban_plan_pk.g_kanban_info_rec.category_structure_id,

Line 900: flm_util.add_bind (':b_kanban_plan_id',

896: -- parse the sql statement that we just built
897: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
898:
899: -- put values into all the bind variables
900: flm_util.add_bind (':b_kanban_plan_id',
901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);
902: flm_util.add_bind (':b_organization_id',
903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',

Line 902: flm_util.add_bind (':b_organization_id',

898:
899: -- put values into all the bind variables
900: flm_util.add_bind (':b_kanban_plan_id',
901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);
902: flm_util.add_bind (':b_organization_id',
903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',

Line 904: flm_util.add_bind (':b_bom_effectivity',

900: flm_util.add_bind (':b_kanban_plan_id',
901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);
902: flm_util.add_bind (':b_organization_id',
903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',

Line 906: flm_util.add_bind (':b_PRODUCTION_KANBAN',

902: flm_util.add_bind (':b_organization_id',
903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);
910: flm_util.add_bind (':b_category_set_id',

Line 908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',

904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);
910: flm_util.add_bind (':b_category_set_id',
911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);
912: flm_util.do_binds(l_cursor);

Line 910: flm_util.add_bind (':b_category_set_id',

906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);
910: flm_util.add_bind (':b_category_set_id',
911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);
912: flm_util.do_binds(l_cursor);
913:
914: -- now execute the sql stmt

Line 912: flm_util.do_binds(l_cursor);

908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);
910: flm_util.add_bind (':b_category_set_id',
911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);
912: flm_util.do_binds(l_cursor);
913:
914: -- now execute the sql stmt
915: l_rows_processed := dbms_sql.execute(l_cursor);
916: