DBA Data[Home] [Help]

APPS.OE_GROUP_SCH_UTIL dependencies on OE_CONFIG_SCHEDULE_PVT

Line 1589: Oe_Config_Schedule_Pvt.Query_Set_Lines

1585: -- Decided to query the line. See what to pass to query sets.
1586: IF l_smc_flag = 'Y'
1587: THEN
1588:
1589: Oe_Config_Schedule_Pvt.Query_Set_Lines
1590: (p_header_id => l_header_id,
1591: p_model_line_id => l_top_model_line_id,
1592: p_sch_action => p_sch_action,
1593: x_line_tbl => l_line_tbl,

Line 1652: Oe_Config_Schedule_Pvt.Query_Set_Lines

1648: -- and its options If the model is selected query whole
1649: -- model and try to place them in the
1650: -- out table if they are not present already.
1651:
1652: Oe_Config_Schedule_Pvt.Query_Set_Lines
1653: (p_header_id => l_header_id,
1654: p_model_line_id => l_top_model_line_id,
1655: p_sch_action => p_sch_action,
1656: x_line_tbl => l_line_tbl,

Line 1710: Oe_Config_Schedule_Pvt.Query_Set_Lines

1706: IF l_item_type_code = 'CLASS'
1707: OR l_item_type_code = 'KIT'
1708: THEN
1709:
1710: Oe_Config_Schedule_Pvt.Query_Set_Lines
1711: (p_header_id => l_header_id,
1712: p_link_to_line_id => l_line_id,
1713: p_sch_action => p_sch_action,
1714: x_line_tbl => l_line_tbl,

Line 1964: Oe_Config_Schedule_Pvt.Query_Set_Lines

1960: -- query using top_model_line_id / ato line id
1961:
1962:
1963: IF l_smc_flag = 'Y' THEN
1964: Oe_Config_Schedule_Pvt.Query_Set_Lines
1965: (p_header_id => l_header_id,
1966: p_model_line_id => l_top_model_line_id,
1967: p_sch_action => p_sch_action,
1968: x_line_tbl => l_line_tbl,

Line 2007: Oe_Config_Schedule_Pvt.Query_Set_Lines

2003: -- and its options If the model is selected query
2004: -- whole model and try to place them in the
2005: -- out table if they are not present already.
2006:
2007: Oe_Config_Schedule_Pvt.Query_Set_Lines
2008: (p_header_id => l_header_id,
2009: p_model_line_id => l_top_model_line_id,
2010: p_sch_action => p_sch_action,
2011: x_line_tbl => l_line_tbl,

Line 2110: Oe_Config_Schedule_Pvt.Query_Set_Lines

2106: IF l_item_type_code = 'CLASS'
2107: OR l_item_type_code = 'KIT'
2108: THEN
2109:
2110: Oe_Config_Schedule_Pvt.Query_Set_Lines
2111: (p_header_id => l_header_id,
2112: p_link_to_line_id => l_line_id,
2113: p_sch_action => p_sch_action,
2114: x_line_tbl => l_line_tbl,

Line 2335: Oe_Config_Schedule_Pvt.Query_Set_Lines

2331: -- and its options. If the model is selected query
2332: -- whole model and try to place them in the
2333: -- out table if they are not present already.
2334:
2335: Oe_Config_Schedule_Pvt.Query_Set_Lines
2336: (p_header_id => l_header_id,
2337: p_model_line_id => l_top_model_line_id,
2338: p_sch_action => p_sch_action,
2339: x_line_tbl => l_line_tbl,

Line 2433: Oe_Config_Schedule_Pvt.Query_Set_Lines

2429: IF l_item_type_code = 'CLASS'
2430: OR l_item_type_code = 'KIT'
2431: THEN
2432:
2433: Oe_Config_Schedule_Pvt.Query_Set_Lines
2434: (p_header_id => l_header_id,
2435: p_link_to_line_id => l_line_id,
2436: p_sch_action => p_sch_action,
2437: x_line_tbl => l_line_tbl,

Line 2681: Oe_Config_Schedule_Pvt.Query_Set_Lines

2677: -- and its options.If the model is selected query whole
2678: -- model and try to place them in the
2679: -- out table if they are not present already.
2680:
2681: Oe_Config_Schedule_Pvt.Query_Set_Lines
2682: (p_header_id => l_header_id,
2683: p_model_line_id => l_top_model_line_id,
2684: p_sch_action => p_sch_action,
2685: x_line_tbl => x_line_tbl,

Line 2885: Oe_Config_Schedule_Pvt.Query_Set_Lines

2881: IF l_item_type_code = 'CLASS'
2882: OR l_item_type_code = 'KIT'
2883: THEN
2884:
2885: Oe_Config_Schedule_Pvt.Query_Set_Lines
2886: (p_header_id => l_header_id,
2887: p_link_to_line_id => l_line_id,
2888: p_sch_action => p_sch_action,
2889: x_line_tbl => x_line_tbl,

Line 3264: Oe_Config_Schedule_Pvt.Query_Set_Lines

3260: OR l_ship_set_id is not null
3261: OR l_smc_flag = 'Y'
3262: THEN
3263:
3264: Oe_Config_Schedule_Pvt.Query_Set_Lines
3265: (p_header_id => l_header_id,
3266: p_arrival_set_id => l_arrival_set_id,
3267: p_ship_set_id => l_ship_set_id,
3268: p_model_line_id => l_top_model_line_id,

Line 3313: Oe_Config_Schedule_Pvt.Query_Set_Lines

3309: -- and its options. If the model is selected query whole model
3310: -- and try to place them in the
3311: -- out table if they are not present already.
3312:
3313: Oe_Config_Schedule_Pvt.Query_Set_Lines
3314: (p_header_id => l_header_id,
3315: p_model_line_id => l_top_model_line_id,
3316: p_sch_action => p_sch_action,
3317: x_line_tbl => l_line_tbl,

Line 3389: Oe_Config_Schedule_Pvt.Query_Set_Lines

3385: IF l_item_type_code = 'CLASS'
3386: OR l_item_type_code = 'KIT'
3387: THEN
3388:
3389: Oe_Config_Schedule_Pvt.Query_Set_Lines
3390: (p_header_id => l_header_id,
3391: p_link_to_line_id => l_line_id,
3392: p_sch_action => p_sch_action,
3393: x_line_tbl => l_line_tbl,

Line 3558: Oe_Config_Schedule_Pvt.Process_Group

3554: END IF;
3555:
3556: IF l_line_tbl.count > 0 THEN
3557:
3558: Oe_Config_Schedule_Pvt.Process_Group
3559: (p_x_line_tbl => l_line_tbl
3560: ,p_old_line_tbl => l_old_line_tbl
3561: ,p_caller => 'UI_ACTION'
3562: ,p_sch_action => p_sch_action

Line 3827: Oe_Config_Schedule_Pvt.Process_Group

3823: IF l_line_tbl.count > 0
3824: AND x_return_status = FND_API.G_RET_STS_SUCCESS
3825: THEN
3826:
3827: Oe_Config_Schedule_Pvt.Process_Group
3828: (p_x_line_tbl => l_line_tbl
3829: ,p_old_line_tbl => l_old_line_tbl
3830: ,p_caller => 'UI_ACTION'
3831: ,p_sch_action => p_sch_action

Line 4316: Oe_Config_Schedule_Pvt.Query_Set_Lines

4312: oe_debug_pub.add(' item type ' || l_item_type_code,3);
4313: oe_debug_pub.add(' header_id ' || l_header_id,3);
4314:
4315: IF p_sch_set_tbl(I).entity_id = nvl(l_top_model_line_id,0) THEN
4316: Oe_Config_Schedule_Pvt.Query_Set_Lines
4317: (p_header_id => l_header_id,
4318: p_model_line_id => l_top_model_line_id,
4319: p_sch_action => 'SCHEDULE',
4320: x_line_tbl => l_iline_tbl,

Line 4338: Oe_Config_Schedule_Pvt.Query_Set_Lines

4334:
4335:
4336: ELSE
4337:
4338: Oe_Config_Schedule_Pvt.Query_Set_Lines
4339: (p_header_id => l_header_id,
4340: p_link_to_line_id => p_sch_set_tbl(I).entity_id,
4341: p_sch_action => 'SCHEDULE',
4342: x_line_tbl => l_iline_tbl,

Line 4586: Oe_Config_Schedule_Pvt.Process_Group

4582: END IF;
4583: -- 3564310
4584: IF l_line_tbl.count > 0
4585: AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4586: Oe_Config_Schedule_Pvt.Process_Group
4587: (p_x_line_tbl => l_line_tbl
4588: ,p_old_line_tbl => l_old_line_tbl
4589: ,p_caller => 'SET'
4590: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE

Line 5011: Oe_Config_Schedule_Pvt.Query_Set_Lines

5007: BEGIN
5008:
5009: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5010:
5011: Oe_Config_Schedule_Pvt.Query_Set_Lines
5012: (p_header_id => l_header_id,
5013: p_arrival_set_id => l_set_id,
5014: p_sch_action => l_action,
5015: x_line_tbl => l_line_tbl,

Line 5020: Oe_Config_Schedule_Pvt.Query_Set_Lines

5016: x_return_status => x_return_status);
5017:
5018: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5019:
5020: Oe_Config_Schedule_Pvt.Query_Set_Lines
5021: (p_header_id => l_header_id,
5022: p_ship_set_id => l_set_id,
5023: p_sch_action => l_action,
5024: x_line_tbl => l_line_tbl,

Line 5650: Oe_Config_Schedule_Pvt.Process_Group

5646: RAISE FND_API.G_EXC_ERROR;
5647: END IF;
5648:
5649: /*
5650: Oe_Config_Schedule_Pvt.Process_Group
5651: (p_x_line_tbl => l_line_tbl
5652: ,p_old_line_tbl => l_old_line_tbl
5653: ,p_caller => 'SET'
5654: ,p_sch_action => l_action

Line 5661: Oe_Config_Schedule_Pvt.Process_Group

5657: /* Commented the above code and added the following code to fix the bug 2740480 */
5658: IF l_push_logic = 'Y' THEN
5659:
5660: oe_debug_pub.add('2740480: Push logic is set to Y ',2);
5661: Oe_Config_Schedule_Pvt.Process_Group
5662: (p_x_line_tbl => l_line_tbl
5663: ,p_old_line_tbl => l_old_line_tbl
5664: ,p_caller => 'SET'
5665: ,p_sch_action => l_action

Line 5734: Oe_Config_Schedule_Pvt.Process_Group

5730:
5731: <>
5732:
5733: oe_debug_pub.add('2740480: Push logic is set to N ',2);
5734: Oe_Config_Schedule_Pvt.Process_Group
5735: (p_x_line_tbl => l_line_tbl
5736: ,p_old_line_tbl => l_old_line_tbl
5737: ,p_caller => 'SET'
5738: ,p_sch_action => l_action

Line 6023: Oe_Config_Schedule_Pvt.Query_Set_Lines

6019: GOTO END_PROCESS;
6020: END IF;
6021: IF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
6022: THEN
6023: Oe_Config_Schedule_Pvt.Query_Set_Lines
6024: (p_header_id => p_sch_set_tbl(I).param2,
6025: p_arrival_set_id => p_sch_set_tbl(I).entity_id,
6026: p_sch_action => 'SCHEDULE',
6027: x_line_tbl => l_line_tbl,

Line 6034: Oe_Config_Schedule_Pvt.Query_Set_Lines

6030:
6031: ELSIF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
6032: THEN
6033:
6034: Oe_Config_Schedule_Pvt.Query_Set_Lines
6035: (p_header_id => p_sch_set_tbl(I).param2,
6036: p_ship_set_id => p_sch_set_tbl(I).entity_id,
6037: p_sch_action => 'SCHEDULE',
6038: x_line_tbl => l_line_tbl,

Line 6201: Oe_Config_Schedule_Pvt.Process_Group

6197: END IF;
6198:
6199: IF l_sch_line_tbl.count > 0 THEN
6200:
6201: Oe_Config_Schedule_Pvt.Process_Group
6202: (p_x_line_tbl => l_sch_line_tbl
6203: ,p_old_line_tbl => l_old_line_tbl
6204: ,p_caller => 'SET'
6205: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE