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_FLOW_SCHEDULE_UTIL dependencies on FLM_UTIL

Line 3569: flm_util.init_bind;

3565: RAISE expected_error;
3566: END IF;
3567:
3568: -- begin new binds
3569: flm_util.init_bind;
3570:
3571: -- Construct where clause
3572: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
3573: l_where_clause := ' and wfs.line_id in (select line_id from wip_lines '||

Line 3575: flm_util.add_bind(':from_line', p_from_line);

3571: -- Construct where clause
3572: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
3573: l_where_clause := ' and wfs.line_id in (select line_id from wip_lines '||
3574: ' where line_code between :from_line and :to_line )';
3575: flm_util.add_bind(':from_line', p_from_line);
3576: flm_util.add_bind(':to_line', p_to_line);
3577: END IF;
3578:
3579: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN

Line 3576: flm_util.add_bind(':to_line', p_to_line);

3572: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
3573: l_where_clause := ' and wfs.line_id in (select line_id from wip_lines '||
3574: ' where line_code between :from_line and :to_line )';
3575: flm_util.add_bind(':from_line', p_from_line);
3576: flm_util.add_bind(':to_line', p_to_line);
3577: END IF;
3578:
3579: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
3580: -- Call procedure (from Kanban) to construct item_where_clause

Line 3581: l_return := flm_util.Item_Where_Clause(

3577: END IF;
3578:
3579: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
3580: -- Call procedure (from Kanban) to construct item_where_clause
3581: l_return := flm_util.Item_Where_Clause(
3582: p_from_item,
3583: p_to_item,
3584: 'msi',
3585: l_item_where_clause,

Line 3603: l_return := flm_util.Category_Where_Clause(

3599: END IF;
3600:
3601: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
3602: AND p_category_set_id IS NOT NULL THEN
3603: l_return := flm_util.Category_Where_Clause(
3604: p_from_category,
3605: p_to_category,
3606: 'cat',
3607: p_category_structure_id,

Line 3626: flm_util.add_bind(':cat_organization_id', p_organization_id);

3622: ' cat.category_id = mic.category_id ' ||
3623: ' and mic.organization_id = :cat_organization_id ' ||
3624: ' and mic.category_set_id = :cat_category_set_id ' ||
3625: ' and ' || l_cat_where_clause || ')';
3626: flm_util.add_bind(':cat_organization_id', p_organization_id);
3627: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
3628: ELSIF p_category_set_id IS NOT NULL THEN
3629: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3630: ' inventory_item_id from mtl_item_categories mic '||

Line 3627: flm_util.add_bind(':cat_category_set_id', p_category_set_id);

3623: ' and mic.organization_id = :cat_organization_id ' ||
3624: ' and mic.category_set_id = :cat_category_set_id ' ||
3625: ' and ' || l_cat_where_clause || ')';
3626: flm_util.add_bind(':cat_organization_id', p_organization_id);
3627: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
3628: ELSIF p_category_set_id IS NOT NULL THEN
3629: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3630: ' inventory_item_id from mtl_item_categories mic '||
3631: ' where mic.organization_id = :cat_organization_id '||

Line 3633: flm_util.add_bind(':cat_organization_id', p_organization_id);

3629: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3630: ' inventory_item_id from mtl_item_categories mic '||
3631: ' where mic.organization_id = :cat_organization_id '||
3632: ' and mic.category_set_id = :cat_category_set_id ) ';
3633: flm_util.add_bind(':cat_organization_id', p_organization_id);
3634: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
3635: END IF;
3636:
3637: l_where_clause := l_where_clause || l_item_where_clause ||

Line 3634: flm_util.add_bind(':cat_category_set_id', p_category_set_id);

3630: ' inventory_item_id from mtl_item_categories mic '||
3631: ' where mic.organization_id = :cat_organization_id '||
3632: ' and mic.category_set_id = :cat_category_set_id ) ';
3633: flm_util.add_bind(':cat_organization_id', p_organization_id);
3634: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
3635: END IF;
3636:
3637: l_where_clause := l_where_clause || l_item_where_clause ||
3638: l_cat_where_clause;

Line 3658: flm_util.add_bind(':organization_id', p_organization_id);

3654: ' where transaction_source_id = wfs.wip_entity_id ' ||
3655: ' and organization_id = wfs.organization_id ' ||
3656: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
3657: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';
3658: flm_util.add_bind(':organization_id', p_organization_id);
3659: flm_util.add_bind(':start_date', l_start_date);
3660: flm_util.add_bind(':end_date', l_end_date+1-1/(24*60*60));
3661: --end of fix bug#3170105
3662: -- get the cursor

Line 3659: flm_util.add_bind(':start_date', l_start_date);

3655: ' and organization_id = wfs.organization_id ' ||
3656: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
3657: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';
3658: flm_util.add_bind(':organization_id', p_organization_id);
3659: flm_util.add_bind(':start_date', l_start_date);
3660: flm_util.add_bind(':end_date', l_end_date+1-1/(24*60*60));
3661: --end of fix bug#3170105
3662: -- get the cursor
3663: l_cursor := dbms_sql.open_cursor;

Line 3660: flm_util.add_bind(':end_date', l_end_date+1-1/(246060));

3656: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
3657: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';
3658: flm_util.add_bind(':organization_id', p_organization_id);
3659: flm_util.add_bind(':start_date', l_start_date);
3660: flm_util.add_bind(':end_date', l_end_date+1-1/(24*60*60));
3661: --end of fix bug#3170105
3662: -- get the cursor
3663: l_cursor := dbms_sql.open_cursor;
3664:

Line 3667: flm_util.do_binds(l_cursor);

3663: l_cursor := dbms_sql.open_cursor;
3664:
3665: -- parse the sql statement
3666: dbms_sql.parse(l_cursor, l_sql_stmt, dbms_sql.native);
3667: flm_util.do_binds(l_cursor);
3668:
3669:
3670: -- define column
3671: dbms_sql.define_column(l_cursor, 1, l_wip_entity_id);

Line 4258: flm_util.init_bind;

4254: l_return BOOLEAN;
4255: BEGIN
4256:
4257: -- begin new binds
4258: flm_util.init_bind;
4259:
4260: -- Construct where clause
4261: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4262: l_where_clause := ' and line.line_code between :from_line and :to_line ';

Line 4263: flm_util.add_bind(':from_line', p_from_line);

4259:
4260: -- Construct where clause
4261: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4262: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4263: flm_util.add_bind(':from_line', p_from_line);
4264: flm_util.add_bind(':to_line', p_to_line);
4265: END IF;
4266:
4267: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN

Line 4264: flm_util.add_bind(':to_line', p_to_line);

4260: -- Construct where clause
4261: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4262: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4263: flm_util.add_bind(':from_line', p_from_line);
4264: flm_util.add_bind(':to_line', p_to_line);
4265: END IF;
4266:
4267: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4268: -- Call procedure to construct item_where_clause

Line 4269: l_return := flm_util.Item_Where_Clause(

4265: END IF;
4266:
4267: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4268: -- Call procedure to construct item_where_clause
4269: l_return := flm_util.Item_Where_Clause(
4270: p_from_item,
4271: p_to_item,
4272: 'msi',
4273: l_item_where_clause,

Line 4290: l_return := flm_util.Category_Where_Clause(

4286:
4287: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
4288: AND p_category_set_id IS NOT NULL THEN
4289:
4290: l_return := flm_util.Category_Where_Clause(
4291: p_from_category,
4292: p_to_category,
4293: 'cat',
4294: p_category_structure_id,

Line 4313: flm_util.add_bind(':cat_organization_id', p_organization_id);

4309: ' cat.category_id = mic.category_id ' ||
4310: ' and mic.organization_id = :cat_organization_id ' ||
4311: ' and mic.category_set_id = :cat_category_set_id ' ||
4312: ' and ' || l_cat_where_clause || ')';
4313: flm_util.add_bind(':cat_organization_id', p_organization_id);
4314: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4315: END IF;
4316:
4317: l_where_clause := l_where_clause || l_item_where_clause ||

Line 4314: flm_util.add_bind(':cat_category_set_id', p_category_set_id);

4310: ' and mic.organization_id = :cat_organization_id ' ||
4311: ' and mic.category_set_id = :cat_category_set_id ' ||
4312: ' and ' || l_cat_where_clause || ')';
4313: flm_util.add_bind(':cat_organization_id', p_organization_id);
4314: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4315: END IF;
4316:
4317: l_where_clause := l_where_clause || l_item_where_clause ||
4318: l_cat_where_clause;

Line 4326: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);

4322: l_cat_sql :=
4323: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4324: ' and mic.organization_id = fs.organization_id ' ||
4325: ' and mic.category_set_id = :cat2_category_set_id ';
4326: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);
4327: ELSE
4328: l_cat_table_sql := ' ';
4329: l_cat_sql := ' ';
4330: END IF;

Line 4357: flm_util.add_bind(':organization_id', p_organization_id);

4353: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
4354: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';
4355:
4356:
4357: flm_util.add_bind(':organization_id', p_organization_id);
4358:
4359: -- get the cursor
4360: l_cursor_name := dbms_sql.open_cursor;
4361:

Line 4364: flm_util.do_binds(l_cursor_name);

4360: l_cursor_name := dbms_sql.open_cursor;
4361:
4362: -- parse the sql statement
4363: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4364: flm_util.do_binds(l_cursor_name);
4365:
4366: dbms_sql.define_column(l_cursor_name, 1, l_flow_schedule_rec.wip_entity_id);
4367:
4368:

Line 4413: flm_util.init_bind;

4409:
4410: BEGIN
4411:
4412: -- new binds
4413: flm_util.init_bind;
4414:
4415: -- Construct where clause
4416: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4417: l_where_clause := ' and line.line_code between :from_line and :to_line ';

Line 4418: flm_util.add_bind(':from_line', p_from_line);

4414:
4415: -- Construct where clause
4416: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4417: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4418: flm_util.add_bind(':from_line', p_from_line);
4419: flm_util.add_bind(':to_line', p_to_line);
4420: END IF;
4421:
4422: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN

Line 4419: flm_util.add_bind(':to_line', p_to_line);

4415: -- Construct where clause
4416: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4417: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4418: flm_util.add_bind(':from_line', p_from_line);
4419: flm_util.add_bind(':to_line', p_to_line);
4420: END IF;
4421:
4422: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4423: -- Call procedure to construct item_where_clause

Line 4424: l_return := flm_util.Item_Where_Clause(

4420: END IF;
4421:
4422: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4423: -- Call procedure to construct item_where_clause
4424: l_return := flm_util.Item_Where_Clause(
4425: p_from_item,
4426: p_to_item,
4427: 'msi',
4428: l_item_where_clause,

Line 4444: l_return := flm_util.Category_Where_Clause(

4440: END IF;
4441:
4442: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
4443: AND p_category_set_id IS NOT NULL THEN
4444: l_return := flm_util.Category_Where_Clause(
4445: p_from_category,
4446: p_to_category,
4447: 'cat',
4448: p_category_structure_id,

Line 4467: flm_util.add_bind(':cat_organization_id', p_organization_id);

4463: ' cat.category_id = mic.category_id ' ||
4464: ' and mic.organization_id = :cat_organization_id ' ||
4465: ' and mic.category_set_id = :cat_category_set_id ' ||
4466: ' and ' || l_cat_where_clause || ')';
4467: flm_util.add_bind(':cat_organization_id', p_organization_id);
4468: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4469: END IF;
4470:
4471: l_where_clause := l_where_clause || l_item_where_clause ||

Line 4468: flm_util.add_bind(':cat_category_set_id', p_category_set_id);

4464: ' and mic.organization_id = :cat_organization_id ' ||
4465: ' and mic.category_set_id = :cat_category_set_id ' ||
4466: ' and ' || l_cat_where_clause || ')';
4467: flm_util.add_bind(':cat_organization_id', p_organization_id);
4468: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4469: END IF;
4470:
4471: l_where_clause := l_where_clause || l_item_where_clause ||
4472: l_cat_where_clause;

Line 4481: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);

4477: l_cat_sql :=
4478: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4479: ' and mic.organization_id = fs.organization_id ' ||
4480: ' and mic.category_set_id = :cat2_category_set_id ';
4481: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);
4482: ELSE
4483: l_cat_table_sql := ' ';
4484: l_cat_sql := ' ';
4485: END IF;

Line 4520: flm_util.add_bind(':organization_id', p_organization_id);

4516: ' group by fs.line_id, line.line_code, fs.primary_item_id, ' ||
4517: ' msi.concatenated_segments ' ||
4518: ' order by line.line_code, msi.concatenated_segments ' ;
4519:
4520: flm_util.add_bind(':organization_id', p_organization_id);
4521: flm_util.add_bind(':from_start_date', p_from_start_date);
4522: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
4523: --end of fix bug#3170105
4524:

Line 4521: flm_util.add_bind(':from_start_date', p_from_start_date);

4517: ' msi.concatenated_segments ' ||
4518: ' order by line.line_code, msi.concatenated_segments ' ;
4519:
4520: flm_util.add_bind(':organization_id', p_organization_id);
4521: flm_util.add_bind(':from_start_date', p_from_start_date);
4522: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
4523: --end of fix bug#3170105
4524:
4525: -- get the cursor

Line 4522: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(246060));

4518: ' order by line.line_code, msi.concatenated_segments ' ;
4519:
4520: flm_util.add_bind(':organization_id', p_organization_id);
4521: flm_util.add_bind(':from_start_date', p_from_start_date);
4522: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
4523: --end of fix bug#3170105
4524:
4525: -- get the cursor
4526: l_cursor_name := dbms_sql.open_cursor;

Line 4530: flm_util.do_binds(l_cursor_name);

4526: l_cursor_name := dbms_sql.open_cursor;
4527:
4528: -- parse the sql statement
4529: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4530: flm_util.do_binds(l_cursor_name);
4531:
4532: -- define columns
4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);

Line 4595: flm_util.init_bind;

4591:
4592: BEGIN
4593:
4594: -- new binds
4595: flm_util.init_bind;
4596:
4597: -- Construct where clause
4598: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4599: l_where_clause := ' and line.line_code between :from_line and :to_line ';

Line 4600: flm_util.add_bind(':from_line', p_from_line);

4596:
4597: -- Construct where clause
4598: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4599: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4600: flm_util.add_bind(':from_line', p_from_line);
4601: flm_util.add_bind(':to_line', p_to_line);
4602: END IF;
4603:
4604: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN

Line 4601: flm_util.add_bind(':to_line', p_to_line);

4597: -- Construct where clause
4598: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4599: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4600: flm_util.add_bind(':from_line', p_from_line);
4601: flm_util.add_bind(':to_line', p_to_line);
4602: END IF;
4603:
4604: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4605: -- Call procedure to construct item_where_clause

Line 4606: l_return := flm_util.Item_Where_Clause(

4602: END IF;
4603:
4604: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4605: -- Call procedure to construct item_where_clause
4606: l_return := flm_util.Item_Where_Clause(
4607: p_from_item,
4608: p_to_item,
4609: 'msi',
4610: l_item_where_clause,

Line 4627: l_return := flm_util.Category_Where_Clause(

4623:
4624: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
4625: AND p_category_set_id IS NOT NULL THEN
4626:
4627: l_return := flm_util.Category_Where_Clause(
4628: p_from_category,
4629: p_to_category,
4630: 'cat',
4631: p_category_structure_id,

Line 4650: flm_util.add_bind(':cat_organization_id', p_organization_id);

4646: ' cat.category_id = mic.category_id ' ||
4647: ' and mic.organization_id = :cat_organization_id ' ||
4648: ' and mic.category_set_id = :cat_category_set_id ' ||
4649: ' and ' || l_cat_where_clause || ')';
4650: flm_util.add_bind(':cat_organization_id', p_organization_id);
4651: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4652: END IF;
4653:
4654: l_where_clause := l_where_clause || l_item_where_clause ||

Line 4651: flm_util.add_bind(':cat_category_set_id', p_category_set_id);

4647: ' and mic.organization_id = :cat_organization_id ' ||
4648: ' and mic.category_set_id = :cat_category_set_id ' ||
4649: ' and ' || l_cat_where_clause || ')';
4650: flm_util.add_bind(':cat_organization_id', p_organization_id);
4651: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4652: END IF;
4653:
4654: l_where_clause := l_where_clause || l_item_where_clause ||
4655: l_cat_where_clause;

Line 4663: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);

4659: l_cat_sql :=
4660: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4661: ' and mic.organization_id = fs.organization_id ' ||
4662: ' and mic.category_set_id = :cat2_category_set_id ';
4663: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);
4664: ELSE
4665: l_cat_table_sql := ' ';
4666: l_cat_sql := ' ';
4667: END IF;

Line 4720: flm_util.add_bind(':organization_id', p_organization_id);

4716: ' and organization_id = fs.organization_id ' ||
4717: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
4718: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ' ||
4719: ' order by line.line_code, trunc(fs.scheduled_completion_date), fs.build_sequence ';
4720: flm_util.add_bind(':organization_id', p_organization_id);
4721: flm_util.add_bind(':from_start_date', p_from_start_date);
4722: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
4723: --end of fix bug#3170105
4724: /*

Line 4721: flm_util.add_bind(':from_start_date', p_from_start_date);

4717: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
4718: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ' ||
4719: ' order by line.line_code, trunc(fs.scheduled_completion_date), fs.build_sequence ';
4720: flm_util.add_bind(':organization_id', p_organization_id);
4721: flm_util.add_bind(':from_start_date', p_from_start_date);
4722: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
4723: --end of fix bug#3170105
4724: /*
4725: Bug 2213859 - Removed ' order by line.line_code, msi.concatenated_segments,fs.build_sequence '

Line 4722: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(246060));

4718: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ' ||
4719: ' order by line.line_code, trunc(fs.scheduled_completion_date), fs.build_sequence ';
4720: flm_util.add_bind(':organization_id', p_organization_id);
4721: flm_util.add_bind(':from_start_date', p_from_start_date);
4722: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
4723: --end of fix bug#3170105
4724: /*
4725: Bug 2213859 - Removed ' order by line.line_code, msi.concatenated_segments,fs.build_sequence '
4726: and added a new order by above

Line 4734: flm_util.do_binds(l_cursor_name);

4730: l_cursor_name := dbms_sql.open_cursor;
4731:
4732: -- parse the sql statement
4733: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4734: flm_util.do_binds(l_cursor_name);
4735:
4736:
4737: -- define columns
4738: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);

Line 4947: flm_util.init_bind;

4943:
4944: BEGIN
4945:
4946: -- new binds
4947: flm_util.init_bind;
4948:
4949: -- Construct where clause
4950: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4951: l_where_clause := ' and line.line_code between :from_line and :to_line ';

Line 4952: flm_util.add_bind(':from_line', p_from_line);

4948:
4949: -- Construct where clause
4950: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4951: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4952: flm_util.add_bind(':from_line', p_from_line);
4953: flm_util.add_bind(':to_line', p_to_line);
4954: END IF;
4955:
4956: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN

Line 4953: flm_util.add_bind(':to_line', p_to_line);

4949: -- Construct where clause
4950: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
4951: l_where_clause := ' and line.line_code between :from_line and :to_line ';
4952: flm_util.add_bind(':from_line', p_from_line);
4953: flm_util.add_bind(':to_line', p_to_line);
4954: END IF;
4955:
4956: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4957: -- Call procedure to construct item_where_clause

Line 4958: l_return := flm_util.Item_Where_Clause(

4954: END IF;
4955:
4956: IF p_from_item IS NOT NULL and p_to_item IS NOT NULL THEN
4957: -- Call procedure to construct item_where_clause
4958: l_return := flm_util.Item_Where_Clause(
4959: p_from_item,
4960: p_to_item,
4961: 'msi',
4962: l_item_where_clause,

Line 4979: l_return := flm_util.Category_Where_Clause(

4975:
4976: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
4977: AND p_category_set_id IS NOT NULL THEN
4978:
4979: l_return := flm_util.Category_Where_Clause(
4980: p_from_category,
4981: p_to_category,
4982: 'cat',
4983: p_category_structure_id,

Line 5002: flm_util.add_bind(':cat_organization_id', p_organization_id);

4998: ' cat.category_id = mic.category_id ' ||
4999: ' and mic.organization_id = :cat_organization_id ' ||
5000: ' and mic.category_set_id = :cat_category_set_id ' ||
5001: ' and ' || l_cat_where_clause || ')';
5002: flm_util.add_bind(':cat_organization_id', p_organization_id);
5003: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
5004: END IF;
5005:
5006: l_where_clause := l_where_clause || l_item_where_clause ||

Line 5003: flm_util.add_bind(':cat_category_set_id', p_category_set_id);

4999: ' and mic.organization_id = :cat_organization_id ' ||
5000: ' and mic.category_set_id = :cat_category_set_id ' ||
5001: ' and ' || l_cat_where_clause || ')';
5002: flm_util.add_bind(':cat_organization_id', p_organization_id);
5003: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
5004: END IF;
5005:
5006: l_where_clause := l_where_clause || l_item_where_clause ||
5007: l_cat_where_clause;

Line 5021: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);

5017: l_cat_sql :=
5018: ' and mic.inventory_item_id = fs.primary_item_id ' ||
5019: ' and mic.organization_id = fs.organization_id ' ||
5020: ' and mic.category_set_id = :cat2_category_set_id ';
5021: flm_util.add_bind(':cat2_category_set_id', p_category_set_id);
5022: ELSE
5023: l_cat_table_sql := ' ';
5024: l_cat_sql := ' ';
5025: END IF;

Line 5053: flm_util.add_bind(':organization_id', p_organization_id);

5049: ' and organization_id = fs.organization_id ' ||
5050: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
5051: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';
5052:
5053: flm_util.add_bind(':organization_id', p_organization_id);
5054: flm_util.add_bind(':from_start_date', p_from_start_date);
5055: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
5056: --end of fix bug#3170105x
5057:

Line 5054: flm_util.add_bind(':from_start_date', p_from_start_date);

5050: ' and transaction_source_type_id = 5 ' || -- perf bug 4911894
5051: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';
5052:
5053: flm_util.add_bind(':organization_id', p_organization_id);
5054: flm_util.add_bind(':from_start_date', p_from_start_date);
5055: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
5056: --end of fix bug#3170105x
5057:
5058: -- get the cursor

Line 5055: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(246060));

5051: ' and transaction_action_id in (1, 27, 30, 31, 32, 33, 34) ) ';
5052:
5053: flm_util.add_bind(':organization_id', p_organization_id);
5054: flm_util.add_bind(':from_start_date', p_from_start_date);
5055: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
5056: --end of fix bug#3170105x
5057:
5058: -- get the cursor
5059: l_cursor_name := dbms_sql.open_cursor;

Line 5063: flm_util.do_binds(l_cursor_name);

5059: l_cursor_name := dbms_sql.open_cursor;
5060:
5061: -- parse the sql statement
5062: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
5063: flm_util.do_binds(l_cursor_name);
5064:
5065: -- define columns
5066: dbms_sql.define_column(l_cursor_name, 1, l_wip_entity_id);
5067:

Line 7322: /* this method is moved to package FLM_UTIL */

7318: -- ========================================================================
7319: /** Bug 2558664 - modified Item_Where_Clause to use fnd_flex_server.parse_flex_values
7320: which handles 'delimiter' more gracefully **/
7321: /** don't use this method!!! */
7322: /* this method is moved to package FLM_UTIL */
7323: FUNCTION Item_Where_Clause( p_item_lo IN VARCHAR2,
7324: p_item_hi IN VARCHAR2,
7325: p_table_name IN VARCHAR2,
7326: x_where OUT NOCOPY VARCHAR2,

Line 7343: /* this method is moved to package FLM_UTIL */

7339: -- ========================================================================
7340: -- This function builds the where clause for the category range specified
7341: -- ========================================================================
7342: /** don't use this method!!! */
7343: /* this method is moved to package FLM_UTIL */
7344: FUNCTION Category_Where_Clause ( p_cat_lo IN VARCHAR2,
7345: p_cat_hi IN VARCHAR2,
7346: p_table_name IN VARCHAR2,
7347: p_cat_struct_id IN NUMBER,