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.CSD_RO_BULLETINS_PVT dependencies on CSD_RO_BULLETINS

Line 1: PACKAGE BODY CSD_RO_BULLETINS_PVT as

1: PACKAGE BODY CSD_RO_BULLETINS_PVT as
2: /* $Header: csdvrobb.pls 120.5.12010000.4 2008/11/18 20:46:49 swai ship $ */
3: -- Start of Comments
4: -- Package name : CSD_RO_BULLETINS_PVT
5: -- Purpose :

Line 4: -- Package name : CSD_RO_BULLETINS_PVT

1: PACKAGE BODY CSD_RO_BULLETINS_PVT as
2: /* $Header: csdvrobb.pls 120.5.12010000.4 2008/11/18 20:46:49 swai ship $ */
3: -- Start of Comments
4: -- Package name : CSD_RO_BULLETINS_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_BULLETINS_PVT';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_BULLETINS_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrobb.pls';
13:
14: -- Global variable for storing the debug level
15: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 81: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Insert_Row)

77:
78: --* logic starts here *--
79:
80:
81: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Insert_Row)
82: CSD_RO_BULLETINS_PKG.INSERT_ROW(
83: px_ro_bulletin_id => x_ro_bulletin_id
84: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
85: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id

Line 82: CSD_RO_BULLETINS_PKG.INSERT_ROW(

78: --* logic starts here *--
79:
80:
81: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Insert_Row)
82: CSD_RO_BULLETINS_PKG.INSERT_ROW(
83: px_ro_bulletin_id => x_ro_bulletin_id
84: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
85: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id
86: ,p_last_viewed_date => p_ro_bulletin_rec.last_viewed_date

Line 200: FROM csd_ro_bulletins

196: creation_date,
197: last_updated_by,
198: last_update_date,
199: last_update_login
200: FROM csd_ro_bulletins
201: WHERE ro_bulletin_id = p_ro_bulletin_id
202: FOR UPDATE NOWAIT;
203:
204: ---- local constants ----

Line 265: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Update_Row)

261:
262: --* NOTE: add validation logic here if needed
263:
264:
265: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Update_Row)
266: CSD_RO_BULLETINS_PKG.UPDATE_ROW(
267: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
268: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
269: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id

Line 266: CSD_RO_BULLETINS_PKG.UPDATE_ROW(

262: --* NOTE: add validation logic here if needed
263:
264:
265: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Update_Row)
266: CSD_RO_BULLETINS_PKG.UPDATE_ROW(
267: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
268: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
269: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id
270: ,p_last_viewed_date => p_ro_bulletin_rec.last_viewed_date

Line 393: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Delete_Row)

389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: --* logic starts here *--
392:
393: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Delete_Row)
394: CSD_RO_BULLETINS_PKG.DELETE_ROW(p_ro_bulletin_id => p_ro_bulletin_id);
395:
396:
397: -- logic ends here *--

Line 394: CSD_RO_BULLETINS_PKG.DELETE_ROW(p_ro_bulletin_id => p_ro_bulletin_id);

390:
391: --* logic starts here *--
392:
393: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Delete_Row)
394: CSD_RO_BULLETINS_PKG.DELETE_ROW(p_ro_bulletin_id => p_ro_bulletin_id);
395:
396:
397: -- logic ends here *--
398:

Line 507: -- Invoke table handler(CSD_RO_BULLETINS_PKG.Lock_Row)

503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: --* logic starts here *--
506:
507: -- Invoke table handler(CSD_RO_BULLETINS_PKG.Lock_Row)
508: CSD_RO_BULLETINS_PKG.LOCK_ROW(
509: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
510: ,p_object_version_number => p_ro_bulletin_rec.object_version_number);
511:

Line 508: CSD_RO_BULLETINS_PKG.LOCK_ROW(

504:
505: --* logic starts here *--
506:
507: -- Invoke table handler(CSD_RO_BULLETINS_PKG.Lock_Row)
508: CSD_RO_BULLETINS_PKG.LOCK_ROW(
509: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
510: ,p_object_version_number => p_ro_bulletin_rec.object_version_number);
511:
512: --* logic ends here *--

Line 682: * IF (NOT exists in csd_ro_bulletins check based on repair ) THEN

678: * x_msg_data => x_msg_data);
679: * (3) FOR EACH rule_results_rec in rule_results_tbl LOOP
680: * IF Bulletin is active and published THEN
681: * IF freq_code = ONE_REPAIR THEN
682: * IF (NOT exists in csd_ro_bulletins check based on repair ) THEN
683: * Call Create new link procecure
684: * END IF;
685: * ELSIF freq_code = ONE_INSTANCE THEN
686: * IF (NOT exists in csd_ro_bulletins check based on instance) THEN

Line 686: * IF (NOT exists in csd_ro_bulletins check based on instance) THEN

682: * IF (NOT exists in csd_ro_bulletins check based on repair ) THEN
683: * Call Create new link procecure
684: * END IF;
685: * ELSIF freq_code = ONE_INSTANCE THEN
686: * IF (NOT exists in csd_ro_bulletins check based on instance) THEN
687: * Call Create new link proceure
688: * END IF;
689: * END IF;
690: * END IF;

Line 693: * - adds a new rec in csd_ro_bulletins

689: * END IF;
690: * END IF;
691: * END LOOP;
692: * (4) Create new link procedure:
693: * - adds a new rec in csd_ro_bulletins
694: * - adds ro service codes id to ro services codes table
695: * - check if escalated, if yes, place holder for setting escalated on RO
696: * - check if work flow, if yes, place holder for launching workflow
697: * - add associated SCs to SC list

Line 919: --* returns ro_bulletin_id in csd_ro_bulletins *--

915: AND sysdate BETWEEN NVL(active_from,sysdate)
916: AND NVL(active_to, sysdate)
917: ; --* end CURSOR cur_get_bulletin_freq_code *--
918:
919: --* returns ro_bulletin_id in csd_ro_bulletins *--
920: --* based on repair_line_id *--
921: CURSOR cur_check_by_repair(p_repair_line_id NUMBER,
922: p_bulletin_id NUMBER) IS
923: SELECT a.ro_bulletin_id

Line 924: FROM csd_ro_bulletins a

920: --* based on repair_line_id *--
921: CURSOR cur_check_by_repair(p_repair_line_id NUMBER,
922: p_bulletin_id NUMBER) IS
923: SELECT a.ro_bulletin_id
924: FROM csd_ro_bulletins a
925: WHERE a.repair_line_id = p_repair_line_id
926: AND a.bulletin_id = p_bulletin_id
927: ; --* end CURSOR cur_check_by_repair *--
928:

Line 932: FROM csd_ro_bulletins a

928:
929: CURSOR cur_check_by_instance(p_instance_id NUMBER,
930: p_bulletin_id NUMBER) IS
931: SELECT a.ro_bulletin_id
932: FROM csd_ro_bulletins a
933: WHERE a.repair_line_id IN
934: (SELECT repair_line_id
935: FROM csd_repairs
936: WHERE customer_product_id = p_instance_id)

Line 1024: * (1) adds a new rec in csd_ro_bulletins

1020: END IF; --* end IF ( cur_get_bulletin_freq_code%NOTFOUND) *--
1021:
1022: --* logic starts here *--
1023: /* BEGIN: Algorithm
1024: * (1) adds a new rec in csd_ro_bulletins
1025: * create l_ro_bulletin_rec
1026: * create_ro_bulletin
1027: * (2) adds ro service codes id to ro services codes table
1028: * cur_get_ro_sc_ids(service_code_id, repair_line_id)

Line 1332: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletins_to_repairs_conc_prog';

1328: l_api_version CONSTANT NUMBER := 1.0;
1329:
1330: -- VARIABLES FOR FND LOG --
1331: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
1332: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletins_to_repairs_conc_prog';
1333:
1334: -- VARIABLES --
1335: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
1336: l_msg_count NUMBER;

Line 1472: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletin_for_rule';

1468: l_api_version CONSTANT NUMBER := 1.0;
1469:
1470: -- VARIABLES FOR FND LOG --
1471: l_error_level number := FND_LOG.LEVEL_ERROR;
1472: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletin_for_rule';
1473:
1474: --VARIABLES --
1475: l_sql_query VARCHAR2(32767) := null;
1476: l_repair_order_cursor REPAIR_ORDER_CURSOR;

Line 1528: l_sql_query := l_sql_query || ' AND not exists ( select ''X'' from csd_ro_bulletins bul'

1524: -- exclude any repair orders in closed state
1525: l_sql_query := l_sql_query || ' AND dra.status <> ''C''';
1526:
1527: -- exclude any repair orders that are already liked to the bulletin
1528: l_sql_query := l_sql_query || ' AND not exists ( select ''X'' from csd_ro_bulletins bul'
1529: || ' where bul.source_id = ' || p_bulletin_rule_id
1530: || ' and bul.repair_line_id = dra.repair_line_id )';
1531:
1532: -- Add on additional query criteria from concurrent program params --

Line 1752: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.apply_bulletin_scs_to_ro';

1748: l_api_version CONSTANT NUMBER := 1.0;
1749:
1750: -- VARIABLES FOR FND LOG --
1751: l_error_level number := FND_LOG.LEVEL_ERROR;
1752: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.apply_bulletin_scs_to_ro';
1753:
1754: -- VARIABLES --
1755: l_in_domain VARCHAR2(1);
1756: l_ro_service_code_rec CSD_RO_SERVICE_CODES_PVT.RO_SERVICE_CODE_REC_TYPE;

Line 1923: END CSD_RO_BULLETINS_PVT; /* Package body ends*/

1919: p_data => x_msg_data );
1920:
1921: END APPLY_BULLETIN_SCS_TO_RO;
1922:
1923: END CSD_RO_BULLETINS_PVT; /* Package body ends*/