APPS.AHL_RA_ANALYSER_PVT dependencies on DUAL

Line 353: -- Dummy PLSql table to fetch dummy forecast associations for population MRP with residual of 100% Probability.

349: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
350: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
351: l_session_id NUMBER;
352:
353: -- Dummy PLSql table to fetch dummy forecast associations for population MRP with residual of 100% Probability.
354: l_dummy_fct_desg_tbl Varchar10TabType;
355: l_incl_in_rpt_flag_tbl Varchar1TabType;
356:
357: l_mrp_api_return_flag BOOLEAN := FALSE;

Line 1175: -- They have to be derived individually for each position path id mapped to the

1171: l_prob_attrib_d := 0; -- Number of installed serviceable items per position with current counter values > A
1172: l_prob_value_tmp := 0;
1173:
1174: -- Note for B and C
1175: -- They have to be derived individually for each position path id mapped to the
1176: -- postion reference and then summed up to get the final values.
1177:
1178: l_prob_attrib_a := l_active_ctr_value_tbl(p);
1179:

Line 1593: from dual;

1589: l_atp_rec.override_flag := Mrp_Atp_Pub.char1_arr('N');
1590:
1591: SELECT mrp_atp_schedule_temp_s.NEXTVAL
1592: INTO l_dummy_identifier
1593: from dual;
1594:
1595: l_atp_rec.Identifier := Mrp_Atp_Pub.number_arr(l_dummy_identifier);
1596:
1597: IF (p_concurrent_flag = 'Y') THEN