DBA Data[Home] [Help]

APPS.OE_GROUP_SCH_UTIL dependencies on OE_CONFIG_SCHEDULE_PVT

Line 1629: Oe_Config_Schedule_Pvt.Query_Set_Lines

1625: -- Decided to query the line. See what to pass to query sets.
1626: IF l_smc_flag = 'Y'
1627: THEN
1628:
1629: Oe_Config_Schedule_Pvt.Query_Set_Lines
1630: (p_header_id => l_header_id,
1631: p_model_line_id => l_top_model_line_id,
1632: p_sch_action => p_sch_action,
1633: x_line_tbl => l_line_tbl,

Line 1693: Oe_Config_Schedule_Pvt.Query_Set_Lines

1689: -- and its options If the model is selected query whole
1690: -- model and try to place them in the
1691: -- out table if they are not present already.
1692:
1693: Oe_Config_Schedule_Pvt.Query_Set_Lines
1694: (p_header_id => l_header_id,
1695: p_model_line_id => l_top_model_line_id,
1696: p_sch_action => p_sch_action,
1697: x_line_tbl => l_line_tbl,

Line 1752: Oe_Config_Schedule_Pvt.Query_Set_Lines

1748: IF l_item_type_code = 'CLASS'
1749: OR l_item_type_code = 'KIT'
1750: THEN
1751:
1752: Oe_Config_Schedule_Pvt.Query_Set_Lines
1753: (p_header_id => l_header_id,
1754: p_link_to_line_id => l_line_id,
1755: p_sch_action => p_sch_action,
1756: x_line_tbl => l_line_tbl,

Line 2012: Oe_Config_Schedule_Pvt.Query_Set_Lines

2008: -- query using top_model_line_id / ato line id
2009:
2010:
2011: IF l_smc_flag = 'Y' THEN
2012: Oe_Config_Schedule_Pvt.Query_Set_Lines
2013: (p_header_id => l_header_id,
2014: p_model_line_id => l_top_model_line_id,
2015: p_sch_action => p_sch_action,
2016: x_line_tbl => l_line_tbl,

Line 2055: Oe_Config_Schedule_Pvt.Query_Set_Lines

2051: -- and its options If the model is selected query
2052: -- whole model and try to place them in the
2053: -- out table if they are not present already.
2054:
2055: Oe_Config_Schedule_Pvt.Query_Set_Lines
2056: (p_header_id => l_header_id,
2057: p_model_line_id => l_top_model_line_id,
2058: p_sch_action => p_sch_action,
2059: x_line_tbl => l_line_tbl,

Line 2158: Oe_Config_Schedule_Pvt.Query_Set_Lines

2154: IF l_item_type_code = 'CLASS'
2155: OR l_item_type_code = 'KIT'
2156: THEN
2157:
2158: Oe_Config_Schedule_Pvt.Query_Set_Lines
2159: (p_header_id => l_header_id,
2160: p_link_to_line_id => l_line_id,
2161: p_sch_action => p_sch_action,
2162: x_line_tbl => l_line_tbl,

Line 2383: Oe_Config_Schedule_Pvt.Query_Set_Lines

2379: -- and its options. If the model is selected query
2380: -- whole model and try to place them in the
2381: -- out table if they are not present already.
2382:
2383: Oe_Config_Schedule_Pvt.Query_Set_Lines
2384: (p_header_id => l_header_id,
2385: p_model_line_id => l_top_model_line_id,
2386: p_sch_action => p_sch_action,
2387: x_line_tbl => l_line_tbl,

Line 2481: Oe_Config_Schedule_Pvt.Query_Set_Lines

2477: IF l_item_type_code = 'CLASS'
2478: OR l_item_type_code = 'KIT'
2479: THEN
2480:
2481: Oe_Config_Schedule_Pvt.Query_Set_Lines
2482: (p_header_id => l_header_id,
2483: p_link_to_line_id => l_line_id,
2484: p_sch_action => p_sch_action,
2485: x_line_tbl => l_line_tbl,

Line 2759: Oe_Config_Schedule_Pvt.Query_Set_Lines

2755: -- and its options.If the model is selected query whole
2756: -- model and try to place them in the
2757: -- out table if they are not present already.
2758:
2759: Oe_Config_Schedule_Pvt.Query_Set_Lines
2760: (p_header_id => l_header_id,
2761: p_model_line_id => l_top_model_line_id,
2762: p_sch_action => p_sch_action,
2763: x_line_tbl => x_line_tbl,

Line 2964: Oe_Config_Schedule_Pvt.Query_Set_Lines

2960: IF l_item_type_code = 'CLASS'
2961: OR l_item_type_code = 'KIT'
2962: THEN
2963:
2964: Oe_Config_Schedule_Pvt.Query_Set_Lines
2965: (p_header_id => l_header_id,
2966: p_link_to_line_id => l_line_id,
2967: p_sch_action => p_sch_action,
2968: x_line_tbl => x_line_tbl,

Line 3348: Oe_Config_Schedule_Pvt.Query_Set_Lines

3344: OR l_ship_set_id is not null
3345: OR l_smc_flag = 'Y'
3346: THEN
3347:
3348: Oe_Config_Schedule_Pvt.Query_Set_Lines
3349: (p_header_id => l_header_id,
3350: p_arrival_set_id => l_arrival_set_id,
3351: p_ship_set_id => l_ship_set_id,
3352: p_model_line_id => l_top_model_line_id,

Line 3397: Oe_Config_Schedule_Pvt.Query_Set_Lines

3393: -- and its options. If the model is selected query whole model
3394: -- and try to place them in the
3395: -- out table if they are not present already.
3396:
3397: Oe_Config_Schedule_Pvt.Query_Set_Lines
3398: (p_header_id => l_header_id,
3399: p_model_line_id => l_top_model_line_id,
3400: p_sch_action => p_sch_action,
3401: x_line_tbl => l_line_tbl,

Line 3473: Oe_Config_Schedule_Pvt.Query_Set_Lines

3469: IF l_item_type_code = 'CLASS'
3470: OR l_item_type_code = 'KIT'
3471: THEN
3472:
3473: Oe_Config_Schedule_Pvt.Query_Set_Lines
3474: (p_header_id => l_header_id,
3475: p_link_to_line_id => l_line_id,
3476: p_sch_action => p_sch_action,
3477: x_line_tbl => l_line_tbl,

Line 3642: Oe_Config_Schedule_Pvt.Process_Group

3638: END IF;
3639:
3640: IF l_line_tbl.count > 0 THEN
3641:
3642: Oe_Config_Schedule_Pvt.Process_Group
3643: (p_x_line_tbl => l_line_tbl
3644: ,p_old_line_tbl => l_old_line_tbl
3645: ,p_caller => 'UI_ACTION'
3646: ,p_sch_action => p_sch_action

Line 3911: Oe_Config_Schedule_Pvt.Process_Group

3907: IF l_line_tbl.count > 0
3908: AND x_return_status = FND_API.G_RET_STS_SUCCESS
3909: THEN
3910:
3911: Oe_Config_Schedule_Pvt.Process_Group
3912: (p_x_line_tbl => l_line_tbl
3913: ,p_old_line_tbl => l_old_line_tbl
3914: ,p_caller => 'UI_ACTION'
3915: ,p_sch_action => p_sch_action

Line 4400: Oe_Config_Schedule_Pvt.Query_Set_Lines

4396: oe_debug_pub.add(' item type ' || l_item_type_code,3);
4397: oe_debug_pub.add(' header_id ' || l_header_id,3);
4398:
4399: IF p_sch_set_tbl(I).entity_id = nvl(l_top_model_line_id,0) THEN
4400: Oe_Config_Schedule_Pvt.Query_Set_Lines
4401: (p_header_id => l_header_id,
4402: p_model_line_id => l_top_model_line_id,
4403: p_sch_action => 'SCHEDULE',
4404: x_line_tbl => l_iline_tbl,

Line 4423: Oe_Config_Schedule_Pvt.Query_Set_Lines

4419:
4420:
4421: ELSE
4422:
4423: Oe_Config_Schedule_Pvt.Query_Set_Lines
4424: (p_header_id => l_header_id,
4425: p_link_to_line_id => p_sch_set_tbl(I).entity_id,
4426: p_sch_action => 'SCHEDULE',
4427: x_line_tbl => l_iline_tbl,

Line 4671: Oe_Config_Schedule_Pvt.Process_Group

4667: END IF;
4668: -- 3564310
4669: IF l_line_tbl.count > 0
4670: AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4671: Oe_Config_Schedule_Pvt.Process_Group
4672: (p_x_line_tbl => l_line_tbl
4673: ,p_old_line_tbl => l_old_line_tbl
4674: ,p_caller => 'SET'
4675: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE

Line 5099: Oe_Config_Schedule_Pvt.Query_Set_Lines

5095: BEGIN
5096:
5097: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5098:
5099: Oe_Config_Schedule_Pvt.Query_Set_Lines
5100: (p_header_id => l_header_id,
5101: p_arrival_set_id => l_set_id,
5102: p_sch_action => l_action,
5103: x_line_tbl => l_line_tbl,

Line 5108: Oe_Config_Schedule_Pvt.Query_Set_Lines

5104: x_return_status => x_return_status);
5105:
5106: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5107:
5108: Oe_Config_Schedule_Pvt.Query_Set_Lines
5109: (p_header_id => l_header_id,
5110: p_ship_set_id => l_set_id,
5111: p_sch_action => l_action,
5112: x_line_tbl => l_line_tbl,

Line 5711: Oe_Config_Schedule_Pvt.Process_Group

5707: RAISE FND_API.G_EXC_ERROR;
5708: END IF;
5709:
5710: /*
5711: Oe_Config_Schedule_Pvt.Process_Group
5712: (p_x_line_tbl => l_line_tbl
5713: ,p_old_line_tbl => l_old_line_tbl
5714: ,p_caller => 'SET'
5715: ,p_sch_action => l_action

Line 5722: Oe_Config_Schedule_Pvt.Process_Group

5718: /* Commented the above code and added the following code to fix the bug 2740480 */
5719: IF l_push_logic = 'Y' THEN
5720:
5721: oe_debug_pub.add('2740480: Push logic is set to Y ',2);
5722: Oe_Config_Schedule_Pvt.Process_Group
5723: (p_x_line_tbl => l_line_tbl
5724: ,p_old_line_tbl => l_old_line_tbl
5725: ,p_caller => 'SET'
5726: ,p_sch_action => l_action

Line 5795: Oe_Config_Schedule_Pvt.Process_Group

5791:
5792: <>
5793:
5794: oe_debug_pub.add('2740480: Push logic is set to N ',2);
5795: Oe_Config_Schedule_Pvt.Process_Group
5796: (p_x_line_tbl => l_line_tbl
5797: ,p_old_line_tbl => l_old_line_tbl
5798: ,p_caller => 'SET'
5799: ,p_sch_action => l_action

Line 6089: Oe_Config_Schedule_Pvt.Query_Set_Lines

6085: GOTO END_PROCESS;
6086: END IF;
6087: IF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
6088: THEN
6089: Oe_Config_Schedule_Pvt.Query_Set_Lines
6090: (p_header_id => p_sch_set_tbl(I).param2,
6091: p_arrival_set_id => p_sch_set_tbl(I).entity_id,
6092: p_sch_action => 'SCHEDULE',
6093: x_line_tbl => l_line_tbl,

Line 6100: Oe_Config_Schedule_Pvt.Query_Set_Lines

6096:
6097: ELSIF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
6098: THEN
6099:
6100: Oe_Config_Schedule_Pvt.Query_Set_Lines
6101: (p_header_id => p_sch_set_tbl(I).param2,
6102: p_ship_set_id => p_sch_set_tbl(I).entity_id,
6103: p_sch_action => 'SCHEDULE',
6104: x_line_tbl => l_line_tbl,

Line 6268: Oe_Config_Schedule_Pvt.Process_Group

6264: END IF;
6265:
6266: IF l_sch_line_tbl.count > 0 THEN
6267:
6268: Oe_Config_Schedule_Pvt.Process_Group
6269: (p_x_line_tbl => l_sch_line_tbl
6270: ,p_old_line_tbl => l_old_line_tbl
6271: ,p_caller => 'SET'
6272: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE