DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_SCH_CONC_REQUESTS

Line 3305: --IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN

3301: ( p_line_id => rec.line_id
3302: ,p_schedule_action_code => OESCH_ACT_UNSCHEDULE
3303: ,x_return_status => l_return_status);
3304: --8731703
3305: --IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
3306: -- OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
3307: --END IF;
3308: EXIT; --only once is enough.
3309: END IF;

Line 3306: -- OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';

3302: ,p_schedule_action_code => OESCH_ACT_UNSCHEDULE
3303: ,x_return_status => l_return_status);
3304: --8731703
3305: --IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
3306: -- OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
3307: --END IF;
3308: EXIT; --only once is enough.
3309: END IF;
3310: END LOOP;

Line 3340: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN

3336: ( p_line_id => rec.line_id
3337: ,p_schedule_action_code => OESCH_ACT_UNSCHEDULE
3338: ,x_return_status => l_return_status);
3339: --8731703
3340: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
3341: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
3342: END IF;
3343: l_mrp_rollback_schedule := 1;
3344: EXIT; --only once is enough.

Line 3341: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';

3337: ,p_schedule_action_code => OESCH_ACT_UNSCHEDULE
3338: ,x_return_status => l_return_status);
3339: --8731703
3340: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
3341: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
3342: END IF;
3343: l_mrp_rollback_schedule := 1;
3344: EXIT; --only once is enough.
3345: END IF;

Line 3371: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN

3367: ( p_line_id => rec.line_id
3368: ,p_schedule_action_code => 'REDEMAND'
3369: ,x_return_status => l_return_status);
3370: --8731703
3371: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
3372: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
3373: END IF;
3374: EXIT; --only once is enough.
3375: END IF;

Line 3372: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';

3368: ,p_schedule_action_code => 'REDEMAND'
3369: ,x_return_status => l_return_status);
3370: --8731703
3371: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
3372: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
3373: END IF;
3374: EXIT; --only once is enough.
3375: END IF;
3376: END LOOP;

Line 3906: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN -- 9108353

3902: Where line_id=p_old_line_rec.line_id;
3903: END IF; */
3904: END IF; -- action=**
3905:
3906: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN -- 9108353
3907: -- Schords (R12 Project #6403)
3908: IF p_line_rec.ship_model_complete_flag = 'N' AND
3909: p_line_rec.top_model_line_id IS NOT NULL AND
3910: (p_line_rec.ato_line_id IS NULL OR

Line 3915: --IF NOT OE_SCH_CONC_REQUESTS.included_processed(p_line_rec.line_id) THEN

3911: p_line_rec.ato_line_id <> p_line_rec.top_model_line_id) AND
3912: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3913:
3914: l_line_id_mod := MOD(p_line_rec.line_id,G_BINARY_LIMIT); --7827737
3915: --IF NOT OE_SCH_CONC_REQUESTS.included_processed(p_line_rec.line_id) THEN
3916: IF NOT OE_SCH_CONC_REQUESTS.included_processed(l_line_id_mod) THEN -- 9108353
3917: IF l_debug_level > 0 THEN
3918: oe_debug_pub.add( 'INCLUDED PROCESSED : ' || p_line_rec.line_id, 3 ) ;
3919: END IF;

Line 3916: IF NOT OE_SCH_CONC_REQUESTS.included_processed(l_line_id_mod) THEN -- 9108353

3912: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3913:
3914: l_line_id_mod := MOD(p_line_rec.line_id,G_BINARY_LIMIT); --7827737
3915: --IF NOT OE_SCH_CONC_REQUESTS.included_processed(p_line_rec.line_id) THEN
3916: IF NOT OE_SCH_CONC_REQUESTS.included_processed(l_line_id_mod) THEN -- 9108353
3917: IF l_debug_level > 0 THEN
3918: oe_debug_pub.add( 'INCLUDED PROCESSED : ' || p_line_rec.line_id, 3 ) ;
3919: END IF;
3920: --5166476

Line 3922: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';

3918: oe_debug_pub.add( 'INCLUDED PROCESSED : ' || p_line_rec.line_id, 3 ) ;
3919: END IF;
3920: --5166476
3921:
3922: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3923: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) :='Y';--7827737
3924: --OE_SCH_CONC_REQUESTS.g_process_records := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3925: END IF;
3926: ELSE

Line 3923: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) :='Y';--7827737

3919: END IF;
3920: --5166476
3921:
3922: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3923: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) :='Y';--7827737
3924: --OE_SCH_CONC_REQUESTS.g_process_records := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3925: END IF;
3926: ELSE
3927: l_line_id_mod := MOD(p_line_rec.line_id,G_BINARY_LIMIT); --7827737

Line 3924: --OE_SCH_CONC_REQUESTS.g_process_records := OE_SCH_CONC_REQUESTS.g_process_records + 1;

3920: --5166476
3921:
3922: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3923: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) :='Y';--7827737
3924: --OE_SCH_CONC_REQUESTS.g_process_records := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3925: END IF;
3926: ELSE
3927: l_line_id_mod := MOD(p_line_rec.line_id,G_BINARY_LIMIT); --7827737
3928: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476

Line 3928: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476

3924: --OE_SCH_CONC_REQUESTS.g_process_records := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3925: END IF;
3926: ELSE
3927: l_line_id_mod := MOD(p_line_rec.line_id,G_BINARY_LIMIT); --7827737
3928: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
3929: --5166476
3930:
3931: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3932: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) := 'Y';--7827737

Line 3931: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';

3927: l_line_id_mod := MOD(p_line_rec.line_id,G_BINARY_LIMIT); --7827737
3928: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
3929: --5166476
3930:
3931: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3932: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) := 'Y';--7827737
3933: --OE_SCH_CONC_REQUESTS.g_process_records
3934: -- := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3935: END IF;

Line 3932: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) := 'Y';--7827737

3928: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
3929: --5166476
3930:
3931: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3932: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) := 'Y';--7827737
3933: --OE_SCH_CONC_REQUESTS.g_process_records
3934: -- := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3935: END IF;
3936: END IF;

Line 3933: --OE_SCH_CONC_REQUESTS.g_process_records

3929: --5166476
3930:
3931: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3932: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) := 'Y';--7827737
3933: --OE_SCH_CONC_REQUESTS.g_process_records
3934: -- := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3935: END IF;
3936: END IF;
3937: END IF; -- 9108353

Line 3934: -- := OE_SCH_CONC_REQUESTS.g_process_records + 1;

3930:
3931: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_line_rec.line_id) := 'Y';
3932: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id_mod) := 'Y';--7827737
3933: --OE_SCH_CONC_REQUESTS.g_process_records
3934: -- := OE_SCH_CONC_REQUESTS.g_process_records + 1;
3935: END IF;
3936: END IF;
3937: END IF; -- 9108353
3938:

Line 4390: OE_SCH_CONC_REQUESTS.g_process_records := OE_SCH_CONC_REQUESTS.g_process_records + 1;

4386: x_atp_rec.Old_Demand_Class(I) :=
4387: l_smc_rec.Old_Demand_Class(J);
4388:
4389: -- Schords (R12 Project #6403)
4390: OE_SCH_CONC_REQUESTS.g_process_records := OE_SCH_CONC_REQUESTS.g_process_records + 1;
4391: IF l_debug_level > 0 THEN
4392: oe_debug_pub.add( 'INCLUDED TO PROCESSED : ' , 3 ) ;
4393: END IF;
4394:

Line 4990: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN

4986: THEN
4987:
4988: -- Schords (R12 Project #6403)
4989: --5166476
4990: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
4991: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_x_line_rec.line_id) := 'N';
4992: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(MOD(p_x_line_rec.line_id,G_BINARY_LIMIT)):='N';--7827737
4993: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
4994: END IF;

Line 4991: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_x_line_rec.line_id) := 'N';

4987:
4988: -- Schords (R12 Project #6403)
4989: --5166476
4990: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
4991: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_x_line_rec.line_id) := 'N';
4992: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(MOD(p_x_line_rec.line_id,G_BINARY_LIMIT)):='N';--7827737
4993: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
4994: END IF;
4995:

Line 4992: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(MOD(p_x_line_rec.line_id,G_BINARY_LIMIT)):='N';--7827737

4988: -- Schords (R12 Project #6403)
4989: --5166476
4990: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
4991: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_x_line_rec.line_id) := 'N';
4992: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(MOD(p_x_line_rec.line_id,G_BINARY_LIMIT)):='N';--7827737
4993: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
4994: END IF;
4995:
4996: IF l_debug_level > 0 THEN

Line 4993: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

4989: --5166476
4990: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
4991: --OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(p_x_line_rec.line_id) := 'N';
4992: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(MOD(p_x_line_rec.line_id,G_BINARY_LIMIT)):='N';--7827737
4993: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
4994: END IF;
4995:
4996: IF l_debug_level > 0 THEN
4997: oe_debug_pub.add( 'ERROR FROM MRP: ' || P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;

Line 18539: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN

18535: ( p_line_id => rec.line_id
18536: ,p_schedule_action_code => OESCH_ACT_UNSCHEDULE
18537: ,x_return_status => l_status);
18538: --8731703
18539: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
18540: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
18541: END IF;
18542: end if;
18543: end loop;

Line 18540: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';

18536: ,p_schedule_action_code => OESCH_ACT_UNSCHEDULE
18537: ,x_return_status => l_status);
18538: --8731703
18539: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
18540: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(rec.line_id) := 'N';
18541: END IF;
18542: end if;
18543: end loop;
18544: