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 HZ_PARTIES

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 33: | mmkumar 18-Jul-2005 modified calls to igs_pe_hz_parties insert_row and add row

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 (
37: p_inst_rec IN IGS_OR_INST_INT%ROWTYPE,

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 74: l_party_id hz_parties.party_id%TYPE;

70: l_return_status VARCHAR2(1);
71: l_msg_data VARCHAR2(2000);
72: l_msg_dt VARCHAR2(2000);
73: l_rowid VARCHAR2(25);
74: l_party_id hz_parties.party_id%TYPE;
75: l_success VARCHAR2(1);
76: l_ovn hz_parties.object_version_number%TYPE;
77: l_err_cd igs_or_inst_int.error_code%TYPE;
78:

Line 76: l_ovn hz_parties.object_version_number%TYPE;

72: l_msg_dt VARCHAR2(2000);
73: l_rowid VARCHAR2(25);
74: l_party_id hz_parties.party_id%TYPE;
75: l_success VARCHAR2(1);
76: l_ovn hz_parties.object_version_number%TYPE;
77: l_err_cd igs_or_inst_int.error_code%TYPE;
78:
79:
80: CURSOR c_inst_code(cp_party_id NUMBER) IS

Line 82: FROM hz_parties

78:
79:
80: CURSOR c_inst_code(cp_party_id NUMBER) IS
81: SELECT party_number
82: FROM hz_parties
83: WHERE party_id = cp_party_id;
84:
85:
86: BEGIN

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 377: --mmkumar, party number impact, changed the following cursor to resolve the foreign key via igs_pe_hz_parties

373: AND org_structure_id = cp_instcd
374: AND org_structure_type = cp_structure_type
375: AND ( SYSDATE BETWEEN start_date AND NVL(end_date,TO_DATE(cp_end_date,'YYYY/MM/DD')) );
376:
377: --mmkumar, party number impact, changed the following cursor to resolve the foreign key via igs_pe_hz_parties
378: CURSOR c_partyid (cp_instcd VARCHAR2) IS
379: SELECT hp.party_id
380: FROM HZ_PARTIES hp, igs_pe_hz_parties ihp
381: WHERE ihp.oss_org_unit_cd = cp_instcd and

Line 380: FROM HZ_PARTIES hp, igs_pe_hz_parties ihp

376:
377: --mmkumar, party number impact, changed the following cursor to resolve the foreign key via igs_pe_hz_parties
378: CURSOR c_partyid (cp_instcd VARCHAR2) IS
379: SELECT hp.party_id
380: FROM HZ_PARTIES hp, igs_pe_hz_parties ihp
381: WHERE ihp.oss_org_unit_cd = cp_instcd and
382: ihp.party_id = hp.party_id;
383:
384: l_rowid VARCHAR2(25);

Line 385: l_partyid hz_parties.party_id%TYPE;

381: WHERE ihp.oss_org_unit_cd = cp_instcd and
382: ihp.party_id = hp.party_id;
383:
384: l_rowid VARCHAR2(25);
385: l_partyid hz_parties.party_id%TYPE;
386: l_org_alternate_id igs_or_org_alt_ids.org_alternate_id%TYPE;
387:
388: BEGIN
389: p_error_code := 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 472: FROM HZ_PARTIES HP, igs_pe_hz_parties ihp

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
473: WHERE ihp.oss_org_unit_cd = cp_instcd and
474: hp.party_id = ihp.party_id;
475:
476: CURSOR c_getrow (cp_partyid NUMBER) IS

Line 478: FROM IGS_PE_HZ_PARTIES PP

474: hp.party_id = ihp.party_id;
475:
476: CURSOR c_getrow (cp_partyid NUMBER) IS
477: SELECT rowid ,PP.*
478: FROM IGS_PE_HZ_PARTIES PP
479: WHERE party_id = cp_partyid;
480:
481:
482: l_msg_data VARCHAR2(2000);

Line 485: l_ovn hz_parties.object_version_number%TYPE;

481:
482: l_msg_data VARCHAR2(2000);
483: l_return_status VARCHAR2(1);
484: l_rowid VARCHAR2(25);
485: l_ovn hz_parties.object_version_number%TYPE;
486: l_party_rec c_partyid%ROWTYPE;
487: l_getrow_rec c_getrow%ROWTYPE;
488:
489: BEGIN

Line 549: -- Call the Update of Igs_Pe_Hz_Parties Table

545: p_errind := 'Y';
546: return;
547: ELSE
548: p_errind := 'N';
549: -- Call the Update of Igs_Pe_Hz_Parties Table
550: OPEN c_getrow(l_party_rec.party_id);
551: FETCH c_getrow INTO l_getrow_rec;
552: CLOSE c_getrow;
553: BEGIN

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,