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 3572: flm_util.init_bind;

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

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

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

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

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

Line 3584: l_return := flm_util.Item_Where_Clause(

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

Line 3606: l_return := flm_util.Category_Where_Clause(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3670: flm_util.do_binds(l_cursor);

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

Line 4261: flm_util.init_bind;

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

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

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

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

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

Line 4272: l_return := flm_util.Item_Where_Clause(

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

Line 4293: l_return := flm_util.Category_Where_Clause(

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

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

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

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

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

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

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

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

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

Line 4367: flm_util.do_binds(l_cursor_name);

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

Line 4416: flm_util.init_bind;

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

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

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

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

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

Line 4427: l_return := flm_util.Item_Where_Clause(

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

Line 4447: l_return := flm_util.Category_Where_Clause(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4533: flm_util.do_binds(l_cursor_name);

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

Line 4598: flm_util.init_bind;

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

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

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

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

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

Line 4609: l_return := flm_util.Item_Where_Clause(

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

Line 4630: l_return := flm_util.Category_Where_Clause(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4737: flm_util.do_binds(l_cursor_name);

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

Line 4950: flm_util.init_bind;

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

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

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

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

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

Line 4961: l_return := flm_util.Item_Where_Clause(

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

Line 4982: l_return := flm_util.Category_Where_Clause(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5066: flm_util.do_binds(l_cursor_name);

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

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

7343: -- ========================================================================
7344: /** Bug 2558664 - modified Item_Where_Clause to use fnd_flex_server.parse_flex_values
7345: which handles 'delimiter' more gracefully **/
7346: /** don't use this method!!! */
7347: /* this method is moved to package FLM_UTIL */
7348: FUNCTION Item_Where_Clause( p_item_lo IN VARCHAR2,
7349: p_item_hi IN VARCHAR2,
7350: p_table_name IN VARCHAR2,
7351: x_where OUT NOCOPY VARCHAR2,

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

7364: -- ========================================================================
7365: -- This function builds the where clause for the category range specified
7366: -- ========================================================================
7367: /** don't use this method!!! */
7368: /* this method is moved to package FLM_UTIL */
7369: FUNCTION Category_Where_Clause ( p_cat_lo IN VARCHAR2,
7370: p_cat_hi IN VARCHAR2,
7371: p_table_name IN VARCHAR2,
7372: p_cat_struct_id IN NUMBER,