DBA Data[Home] [Help]

APPS.AHL_RA_ANALYSER_PVT dependencies on MRP_FORECAST_INTERFACE_PK

Line 332: -- Plsql Table of rec type MRP_FORECAST_INTERFACE_PK.rec_forecast_interface

328: -- This is used for each item instance to indicate if MTBF Data is defined or not
329: l_mtbf_data_defined VARCHAR2(1) := 'N';
330: l_mtbf_value_exceeds VARCHAR2(1) := 'N';
331:
332: -- Plsql Table of rec type MRP_FORECAST_INTERFACE_PK.rec_forecast_interface
333: l_forecast_interface_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_interface;
334: l_forecast_designator_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_designator;
335: l_forecast_org_code_tbl Varchar3TabType;
336: l_forecast_srl_no_tbl Varchar30TabType;

Line 333: l_forecast_interface_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_interface;

329: l_mtbf_data_defined VARCHAR2(1) := 'N';
330: l_mtbf_value_exceeds VARCHAR2(1) := 'N';
331:
332: -- Plsql Table of rec type MRP_FORECAST_INTERFACE_PK.rec_forecast_interface
333: l_forecast_interface_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_interface;
334: l_forecast_designator_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_designator;
335: l_forecast_org_code_tbl Varchar3TabType;
336: l_forecast_srl_no_tbl Varchar30TabType;
337: l_forecast_item_name_tbl Varchar40TabType;

Line 334: l_forecast_designator_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_designator;

330: l_mtbf_value_exceeds VARCHAR2(1) := 'N';
331:
332: -- Plsql Table of rec type MRP_FORECAST_INTERFACE_PK.rec_forecast_interface
333: l_forecast_interface_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_interface;
334: l_forecast_designator_tbl MRP_FORECAST_INTERFACE_PK.t_forecast_designator;
335: l_forecast_org_code_tbl Varchar3TabType;
336: l_forecast_srl_no_tbl Varchar30TabType;
337: l_forecast_item_name_tbl Varchar40TabType;
338: l_forecast_onhand_qty_tbl NumTabType;

Line 2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');

2007: END IF; -- l_since_new_ctr_id_tbl.COUNT = 0
2008:
2009: IF l_forecast_interface_tbl.COUNT > 0 THEN
2010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');
2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');
2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);

Line 2039: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before -- ');

2035: END LOOP;
2036: END IF;
2037: END IF;
2038: IF (p_concurrent_flag = 'Y') THEN
2039: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before -- ');
2040: END IF;
2041:
2042: IF (MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE
2043: (l_forecast_interface_tbl,

Line 2042: IF (MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE

2038: IF (p_concurrent_flag = 'Y') THEN
2039: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before -- ');
2040: END IF;
2041:
2042: IF (MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE
2043: (l_forecast_interface_tbl,
2044: l_forecast_designator_tbl)) THEN
2045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2046: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After');

Line 2046: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After');

2042: IF (MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE
2043: (l_forecast_interface_tbl,
2044: l_forecast_designator_tbl)) THEN
2045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2046: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After');
2047: END IF;
2048: IF (p_concurrent_flag = 'Y') THEN
2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');
2050: END IF;

Line 2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');

2045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2046: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After');
2047: END IF;
2048: IF (p_concurrent_flag = 'Y') THEN
2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');
2050: END IF;
2051: ELSE
2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string(fnd_log.level_statement,l_full_name,'Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- ');

Line 2053: fnd_log.string(fnd_log.level_statement,l_full_name,'Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- ');

2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');
2050: END IF;
2051: ELSE
2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string(fnd_log.level_statement,l_full_name,'Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- ');
2054: END IF;
2055: IF (p_concurrent_flag = 'Y') THEN
2056: fnd_file.put_line(fnd_file.log, ' -- Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE ---- ');
2057: END IF;

Line 2056: fnd_file.put_line(fnd_file.log, ' -- Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE ---- ');

2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string(fnd_log.level_statement,l_full_name,'Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- ');
2054: END IF;
2055: IF (p_concurrent_flag = 'Y') THEN
2056: fnd_file.put_line(fnd_file.log, ' -- Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE ---- ');
2057: END IF;
2058: END IF;
2059:
2060: ELSE

Line 2062: fnd_log.string(fnd_log.level_statement,l_full_name,'MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called');

2058: END IF;
2059:
2060: ELSE
2061: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2062: fnd_log.string(fnd_log.level_statement,l_full_name,'MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called');
2063: END IF;
2064: IF (p_concurrent_flag = 'Y') THEN
2065: fnd_file.put_line(fnd_file.log, ' -- MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called ---- ');
2066: END IF;

Line 2065: fnd_file.put_line(fnd_file.log, ' -- MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called ---- ');

2061: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2062: fnd_log.string(fnd_log.level_statement,l_full_name,'MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called');
2063: END IF;
2064: IF (p_concurrent_flag = 'Y') THEN
2065: fnd_file.put_line(fnd_file.log, ' -- MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called ---- ');
2066: END IF;
2067: END IF;
2068:
2069: -- Open a temporary lob for merging the contents.