APPS.MSC_ATP_DB_UTILS dependencies on FND_PRODUCT_INSTALLATIONS

Line 87: /* Design : read the patch_level in fnd_product_installations.

83: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'ODS based ATP, Add into MSC_SALES Orders');
84: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'p_atp_rec.original_request_ship_date: ' ||p_atp_rec.original_request_ship_date);
85: END IF;
86: --bug#12973673 -- enable the triple checkin for MSCDATPB.pls file
87: /* Design : read the patch_level in fnd_product_installations.
88: If it is MSC.A --> We are in MSC120. If it is not null and some other value --> It is other than MSC120.
89: In case it is null --> Try to read the row_type --> It caught with exception --> We are in MSC120 */
90:
91: BEGIN

Line 94: FROM fnd_product_installations

90:
91: BEGIN
92: SELECT substr(PATCH_LEVEL,1,9)
93: INTO lv_apps_ver
94: FROM fnd_product_installations
95: WHERE APPLICATION_ID = 724;
96: EXCEPTION
97: WHEN others THEN
98: lv_apps_ver := null;