[Home] [Help]
2: /* $Header: IGSOR15B.pls 120.2 2005/09/28 00:21:48 appldev ship $ */
3: /* Change History
4: | who when what
5:
6: | npalanis 15-feb-2002 Bug ID -2225917 : SWCR008 IGS_OR_GEN_012_PKG.CREATE_ACCOUNT call
7: | is removed .
8: | KUMMA 15-jul-2002 Bug 2446067: in call to CREATE_ORGANIZATION and UPDATE_ORGANIZATION ,
9: | converted the NEW_INSTITUTION_CD to upper.
10: | In call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW if the local_ind and os_ind are null
28: | cursor parameters. Respective changes have been made in the places where
29: | the cursors are opened
30: | 3. In the import process, it is made sure that NULL values does not replace
31: | existing values in the table. NULL check has been added while calling
32: | IGS_OR_GEN_012_PKG.UPDATE_ORGANIZATION and igs_pe_hz_parties_pkg.ADD_row
33: | mmkumar 18-Jul-2005 modified calls to igs_pe_hz_parties insert_row and add row
34: */
35:
36: PROCEDURE create_institution (
64: pkpatel 25-OCT-2002 Bug No: 2613704
65: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
66: ssawhney 30-APR-2003 V2API - OVN implementation.
67: skpandey 27-SEP-2005 Bug: 3663505
68: Description: Added ATTRIBUTES 21 TO 24 to store additional information in IGS_OR_GEN_012_PKG call
69: ***************************************************************/
70: l_return_status VARCHAR2(1);
71: l_msg_data VARCHAR2(2000);
72: l_msg_dt VARCHAR2(2000);
87: -- Call the Autogenerate Logic to check for the Profile Value of Hz_Generate_Party_Number
88: autoGenerateLogic(p_inst_rec, l_success,l_err_cd);
89: IF l_success = 'Y' THEN
90: -- Create Organization
91: IGS_OR_GEN_012_PKG.CREATE_ORGANIZATION (
92: p_institution_cd => p_inst_rec.NEW_INSTITUTION_CD,
93: p_name => p_inst_rec.NAME,
94: p_status => 'A',
95: p_attribute_category => p_inst_rec.ATTRIBUTE_CATEGORY,
460: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
461: ssawhney 30-APR-2003 V2API - OVN implementation.
462: vrathi 28-MAY-2003 Bug No: 2961982 Replaced update_row with add_row
463: ssaleem 26-SEP-2003 NULL check has been added while calling
464: IGS_OR_GEN_012_PKG.UPDATE_ORGANIZATION and igs_pe_hz_parties_pkg.ADD_row,
465: it is made sure that NULL values does not replace
466: existing values in the table.
467: skpandey 27-SEP-2005 Bug: 3663505
468: Description: Added ATTRIBUTES 21 TO 24 to store additional information in IGS_OR_GEN_012_PKG call
464: IGS_OR_GEN_012_PKG.UPDATE_ORGANIZATION and igs_pe_hz_parties_pkg.ADD_row,
465: it is made sure that NULL values does not replace
466: existing values in the table.
467: skpandey 27-SEP-2005 Bug: 3663505
468: Description: Added ATTRIBUTES 21 TO 24 to store additional information in IGS_OR_GEN_012_PKG call
469: ***************************************************************/
470: CURSOR c_partyid (cp_instcd VARCHAR2) IS
471: SELECT hp.*
472: FROM HZ_PARTIES HP, igs_pe_hz_parties ihp
493: CLOSE c_partyid;
494:
495: l_ovn := l_party_rec.object_version_number;
496:
497: IGS_OR_GEN_012_PKG.UPDATE_ORGANIZATION (
498: p_party_id => l_party_rec.party_id,
499: p_institution_cd => p_instcd,
500: p_name => NVL(p_instrec.NAME,l_party_rec.party_name),
501: p_status => l_party_rec.status,