APPS.JE_ES_MODELO_190_ALL_UPGRADE dependencies on JE_ES_MODELO_190_ALL

Line 1: PACKAGE BODY je_es_modelo_190_all_upgrade AS

1: PACKAGE BODY je_es_modelo_190_all_upgrade AS
2: /* $Header: jeesupgb.pls 120.0 2006/05/19 17:59:58 rjreddy noship $ */
3:
4: PROCEDURE upgrade_main (errbuf OUT NOCOPY varchar2,
5: retcode OUT NOCOPY number) IS

Line 41: UPDATE je_es_modelo_190_all

37: IF l_return_status IS NULL THEN
38:
39: IF (l_legal_entity_id IS NOT NULL) THEN
40:
41: UPDATE je_es_modelo_190_all
42: SET legal_entity_id = l_legal_entity_id
43: WHERE legal_entity_id IS NULL
44: AND org_id IS NULL;
45:

Line 46: l_message := 'Updated '||SQL%ROWCOUNT||' rows in table JE_ES_MODELO_190_ALL with legal entity id: '||l_legal_entity_id;

42: SET legal_entity_id = l_legal_entity_id
43: WHERE legal_entity_id IS NULL
44: AND org_id IS NULL;
45:
46: l_message := 'Updated '||SQL%ROWCOUNT||' rows in table JE_ES_MODELO_190_ALL with legal entity id: '||l_legal_entity_id;
47: fnd_file.put_line(fnd_file.log,l_message);
48:
49: ELSE
50: -- IF legal entity id is null.

Line 51: l_message := 'Unable to Update Legal Entities for the table je_es_modelo_190_all

47: fnd_file.put_line(fnd_file.log,l_message);
48:
49: ELSE
50: -- IF legal entity id is null.
51: l_message := 'Unable to Update Legal Entities for the table je_es_modelo_190_all
52: because no Legal Entity was found.';
53: fnd_file.put_line(fnd_file.log,l_message);
54:
55: ROLLBACK;

Line 86: END je_es_modelo_190_all_upgrade;

82: fnd_file.put_line(fnd_file.log, l_message);
83:
84: END upgrade_main;
85:
86: END je_es_modelo_190_all_upgrade;
87: