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.IGS_OR_INST_IMP_002 dependencies on IGS_PE_HZ_PARTIES_PKG

Line 10: | In call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW if the local_ind and os_ind are null

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
11: | then put the default value of 'N'. In call to IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW if
12: | local_ind and os_ind are null then substitute them with database older values
13: | OI_LOCAL_INSTITUTION_IND and OI_OS_IND
14: | pkpatel 31-JUL-2002 Bug No: 2461744

Line 11: | then put the default value of 'N'. In call to IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW if

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
11: | then put the default value of 'N'. In call to IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW if
12: | local_ind and os_ind are null then substitute them with database older values
13: | OI_LOCAL_INSTITUTION_IND and OI_OS_IND
14: | pkpatel 31-JUL-2002 Bug No: 2461744
15: | Removed the UPPER check for INSTITUTION_CD

Line 17: | Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg

13: | OI_LOCAL_INSTITUTION_IND and OI_OS_IND
14: | pkpatel 31-JUL-2002 Bug No: 2461744
15: | Removed the UPPER check for INSTITUTION_CD
16: | pkpatel 25-OCT-2002 Bug No: 2613704
17: | Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
18: | npalanis 27-OCT-2002 Bug No: 2613704
19: | Modified create_alternate_id
20: | pkpatel 2-DEC-2002 Bug No: 2599109
21: | Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg

Line 21: | Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg

17: | Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
18: | npalanis 27-OCT-2002 Bug No: 2613704
19: | Modified create_alternate_id
20: | pkpatel 2-DEC-2002 Bug No: 2599109
21: | Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
22: | ssawhney 30-APR-2003 V2API - OVN implementation , create/update_institution procs modified
23: | vrathi 28-MAY-2003 Bug No: 2961982 Replaced update_row with add_row
24: | ssaleem 25-SEP-2003 IGS.L patch the following changes are made
25: | 1. Logging mechanism introduced, FND_FILE.PUT_LINE replaced with methods

Line 32: | IGS_OR_GEN_012_PKG.UPDATE_ORGANIZATION and igs_pe_hz_parties_pkg.ADD_row

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 (

Line 52: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW calls

48: Know limitations, enhancements or remarks
49: Change History
50: Who When What
51: SMVK 05-Feb-2002 Added Fund Authorization to
52: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW calls
53: as per enhancement bug no.2191470.
54: kumma 14-JUN-2002 Uncommented the call to message IGS_OR_INST_CRT_FAIL,
55: IGS_OR_AUTOGEN_FAIL, 2410165
56: kumma 26-JUN-2002 Passed NULL for values INSITUTION_CD AND OU_START_DT

Line 57: Inside call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW AND UPDATE_ROW, Bug 2425349

53: as per enhancement bug no.2191470.
54: kumma 14-JUN-2002 Uncommented the call to message IGS_OR_INST_CRT_FAIL,
55: IGS_OR_AUTOGEN_FAIL, 2410165
56: kumma 26-JUN-2002 Passed NULL for values INSITUTION_CD AND OU_START_DT
57: Inside call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW AND UPDATE_ROW, Bug 2425349
58: kumma 28-jun-2002 set the error indicator to 'Y' inside exception handling code
59: kumma 15-JUL-2002 In call to CREATE_ORGANIZATION converted the NEW_INSTITUTION_CD to upper.
60: In call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW if the local_ind and os_ind are null
61: then put the default value of 'N'. Bug 2446067

Line 60: In call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW if the local_ind and os_ind are null

56: kumma 26-JUN-2002 Passed NULL for values INSITUTION_CD AND OU_START_DT
57: Inside call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW AND UPDATE_ROW, Bug 2425349
58: kumma 28-jun-2002 set the error indicator to 'Y' inside exception handling code
59: kumma 15-JUL-2002 In call to CREATE_ORGANIZATION converted the NEW_INSTITUTION_CD to upper.
60: In call to IGS_PE_HZ_PARTIES_PKG.INSERT_ROW if the local_ind and os_ind are null
61: then put the default value of 'N'. Bug 2446067
62: pkpatel 31-JUL-2002 Bug No: 2461744
63: Removed the UPPER check for INSTITUTION_CD
64: pkpatel 25-OCT-2002 Bug No: 2613704

Line 65: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg

61: then put the default value of 'N'. Bug 2446067
62: pkpatel 31-JUL-2002 Bug No: 2461744
63: Removed the UPPER check for INSTITUTION_CD
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: ***************************************************************/

Line 150: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW (

146: OPEN c_inst_code(l_party_id);
147: FETCH c_inst_code INTO p_instcode;
148: CLOSE c_inst_code;
149: BEGIN
150: IGS_PE_HZ_PARTIES_PKG.INSERT_ROW (
151: x_rowid => l_rowid,
152: x_mode => 'R',
153: x_party_id => l_party_id,
154: x_deceased_ind => NULL,

Line 450: IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW calls

446: Know limitations, enhancements or remarks
447: Change History
448: Who When What
449: SMVK 05-Feb-2002 Added Fund Authorization to
450: IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW calls
451: as per enhancement bug no.2191470.
452: kumma 14-JUN-2002 Uncommented the call to message IGS_OR_INST_UPD_FAIL, 2410165
453: kumma 15-JUL-2002 In call to UPDATE_ORGANIZATION ,
454: converted the INSTITUTION_CD to upper.

Line 455: In call to IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW if the local_ind and os_ind are null

451: as per enhancement bug no.2191470.
452: kumma 14-JUN-2002 Uncommented the call to message IGS_OR_INST_UPD_FAIL, 2410165
453: kumma 15-JUL-2002 In call to UPDATE_ORGANIZATION ,
454: converted the INSTITUTION_CD to upper.
455: In call to IGS_PE_HZ_PARTIES_PKG.UPDATE_ROW if the local_ind and os_ind are null
456: then substituted them witholder values of database. Bug 2446067
457: pkpatel 31-JUL-2002 Bug No: 2461744
458: Removed the UPPER check for INSTITUTION_CD
459: pkpatel 25-OCT-2002 Bug No: 2613704

Line 460: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg

456: then substituted them witholder values of database. Bug 2446067
457: pkpatel 31-JUL-2002 Bug No: 2461744
458: Removed the UPPER check for INSTITUTION_CD
459: pkpatel 25-OCT-2002 Bug No: 2613704
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,

Line 464: IGS_OR_GEN_012_PKG.UPDATE_ORGANIZATION and igs_pe_hz_parties_pkg.ADD_row,

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

Line 555: igs_pe_hz_parties_pkg.ADD_row (

551: FETCH c_getrow INTO l_getrow_rec;
552: CLOSE c_getrow;
553: BEGIN
554:
555: igs_pe_hz_parties_pkg.ADD_row (
556: x_mode => 'R',
557: x_rowid => l_rowid,
558: x_party_id => l_party_rec.party_id,
559: x_deceased_ind => l_getrow_rec.DECEASED_IND,