eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WICTPG dependencies on WIP_PERIOD_BALANCES

Line 1068: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');

1064: x_purge_rec.line_code := p_purge_request.line_code;
1065:
1066:
1067: -- verify no period balance activity
1068: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1069: x_purge_rec.info := fnd_message.get;
1070: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1071:
1072: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because

Line 1070: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';

1066:
1067: -- verify no period balance activity
1068: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1069: x_purge_rec.info := fnd_message.get;
1070: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1071:
1072: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because
1073: the checking should be done to see whether the sum of (IN - OUT NOCOPY - VAR) of each cost
1074: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the

Line 1074: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the

1070: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1071:
1072: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because
1073: the checking should be done to see whether the sum of (IN - OUT NOCOPY - VAR) of each cost
1074: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the
1075: individula cost columns in WIP_PERIOD_BALANCES is zero as it was in the earlier sql.
1076: */
1077:
1078: select count(*)

Line 1075: individula cost columns in WIP_PERIOD_BALANCES is zero as it was in the earlier sql.

1071:
1072: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because
1073: the checking should be done to see whether the sum of (IN - OUT NOCOPY - VAR) of each cost
1074: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the
1075: individula cost columns in WIP_PERIOD_BALANCES is zero as it was in the earlier sql.
1076: */
1077:
1078: select count(*)
1079: into x_records_returned

Line 1092: from WIP_PERIOD_BALANCES

1088: sum(NVL(PL_MATERIAL_OVERHEAD_IN, 0) - NVL(PL_MATERIAL_OVERHEAD_OUT, 0) - NVL(PL_MATERIAL_OVERHEAD_VAR,0)),
1089: sum(NVL(PL_RESOURCE_IN, 0) - NVL(PL_RESOURCE_OUT, 0) - NVL(PL_RESOURCE_VAR,0)),
1090: sum(NVL(PL_OVERHEAD_IN, 0) - NVL(PL_OVERHEAD_OUT, 0) - NVL(PL_OVERHEAD_VAR,0)),
1091: sum(NVL(PL_OUTSIDE_PROCESSING_IN, 0) - NVL(PL_OUTSIDE_PROCESSING_OUT, 0) - NVL(PL_OUTSIDE_PROCESSING_VAR,0))
1092: from WIP_PERIOD_BALANCES
1093: where WIP_ENTITY_ID = x_purge_rec.wip_entity_id);
1094:
1095: x_records_found := x_records_found OR (x_records_returned > 0);
1096:

Line 1900: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';

1896: end if;
1897:
1898:
1899:
1900: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1901:
1902: if (p_option = REPORT_ONLY) then
1903: SELECT COUNT(*) INTO x_num_rows
1904: FROM WIP_PERIOD_BALANCES

Line 1904: FROM WIP_PERIOD_BALANCES

1900: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1901:
1902: if (p_option = REPORT_ONLY) then
1903: SELECT COUNT(*) INTO x_num_rows
1904: FROM WIP_PERIOD_BALANCES
1905: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1906: else
1907: DELETE FROM WIP_PERIOD_BALANCES
1908: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 1907: DELETE FROM WIP_PERIOD_BALANCES

1903: SELECT COUNT(*) INTO x_num_rows
1904: FROM WIP_PERIOD_BALANCES
1905: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1906: else
1907: DELETE FROM WIP_PERIOD_BALANCES
1908: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1909: x_num_rows := SQL%ROWCOUNT ;
1910: end if ;
1911:

Line 1995: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');

1991: x_purge_rec.entity_name := p_purge_request.wip_entity_name;
1992: x_purge_rec.line_code := p_purge_request.line_code;
1993:
1994: -- set message; verify no period balance activity
1995: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1996: x_purge_rec.info := fnd_message.get;
1997:
1998: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1999:

Line 1998: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';

1994: -- set message; verify no period balance activity
1995: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1996: x_purge_rec.info := fnd_message.get;
1997:
1998: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1999:
2000: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because
2001: the checking should be done to see whether the sum of (IN - OUT NOCOPY - VAR) of each cost
2002: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the

Line 2002: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the

1998: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1999:
2000: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because
2001: the checking should be done to see whether the sum of (IN - OUT NOCOPY - VAR) of each cost
2002: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the
2003: individula cost columns in WIP_PERIOD_BALANCES is zero as it was in the earlier sql.
2004: */
2005:
2006: select count(*) into l_num_rows

Line 2003: individula cost columns in WIP_PERIOD_BALANCES is zero as it was in the earlier sql.

1999:
2000: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because
2001: the checking should be done to see whether the sum of (IN - OUT NOCOPY - VAR) of each cost
2002: component is zero over all accounting periods in WIP_PERIOD_BALANCES, not each of the
2003: individula cost columns in WIP_PERIOD_BALANCES is zero as it was in the earlier sql.
2004: */
2005:
2006: select count(*) into l_num_rows
2007: from sys.dual

Line 2028: from WIP_PERIOD_BALANCES

2024: sum(NVL(PL_OVERHEAD_IN, 0) - NVL(PL_OVERHEAD_OUT, 0)
2025: - NVL(PL_OVERHEAD_VAR,0)),
2026: sum(NVL(PL_OUTSIDE_PROCESSING_IN, 0) - NVL(PL_OUTSIDE_PROCESSING_OUT, 0)
2027: - NVL(PL_OUTSIDE_PROCESSING_VAR,0))
2028: from WIP_PERIOD_BALANCES
2029: where WIP_ENTITY_ID = x_purge_rec.wip_entity_id
2030: and REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id);
2031: x_records_found := x_records_found OR (l_num_rows > 0);
2032: if ( l_num_rows > 0 ) then

Line 2226: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';

2222: ' WHERE REPETITIVE_SCHEDULE_ID = ' || to_char(x_purge_rec.schedule_id));
2223:
2224: ----------------------------------------------------------------------------*/
2225:
2226: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
2227:
2228: if (p_option = REPORT_ONLY) then
2229: SELECT COUNT(*) INTO x_num_rows
2230: FROM WIP_PERIOD_BALANCES

Line 2230: FROM WIP_PERIOD_BALANCES

2226: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
2227:
2228: if (p_option = REPORT_ONLY) then
2229: SELECT COUNT(*) INTO x_num_rows
2230: FROM WIP_PERIOD_BALANCES
2231: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2232: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2233: else
2234: DELETE FROM WIP_PERIOD_BALANCES

Line 2234: DELETE FROM WIP_PERIOD_BALANCES

2230: FROM WIP_PERIOD_BALANCES
2231: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2232: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2233: else
2234: DELETE FROM WIP_PERIOD_BALANCES
2235: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2236: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2237: x_num_rows := SQL%ROWCOUNT ;
2238: end if ;