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_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_SV_BTCH_SUMMARY

Line 141: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,

137: p_batch_type IN VARCHAR2 -- Batch type E(ev), I(international)
138: ) ;
139:
140: PROCEDURE Insert_Summary_Info(
141: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
142: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,

Line 142: p_person_id IN igs_sv_btch_summary.person_id%TYPE,

138: ) ;
139:
140: PROCEDURE Insert_Summary_Info(
141: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
142: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
146: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,

Line 143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,

139:
140: PROCEDURE Insert_Summary_Info(
141: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
142: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
146: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
147: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE

Line 144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,

140: PROCEDURE Insert_Summary_Info(
141: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
142: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
146: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
147: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
148: );

Line 145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,

141: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
142: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
146: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
147: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
148: );
149:

Line 146: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,

142: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
146: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
147: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
148: );
149:
150: PROCEDURE compose_log_file;

Line 147: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE

143: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
144: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
145: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
146: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
147: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
148: );
149:
150: PROCEDURE compose_log_file;
151: /*****************************************************************/

Line 426: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,

422: Who When What
423: ------------------------------------------------------------------------
424:
425: ******************************************************************/
426: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,
427: p_person_id igs_sv_btch_summary.person_id%TYPE,
428: p_action igs_sv_btch_summary.action_code%TYPE,
429: p_tag_code igs_sv_btch_summary.tag_code%TYPE
430: )

Line 427: p_person_id igs_sv_btch_summary.person_id%TYPE,

423: ------------------------------------------------------------------------
424:
425: ******************************************************************/
426: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,
427: p_person_id igs_sv_btch_summary.person_id%TYPE,
428: p_action igs_sv_btch_summary.action_code%TYPE,
429: p_tag_code igs_sv_btch_summary.tag_code%TYPE
430: )
431: RETURN NUMBER

Line 428: p_action igs_sv_btch_summary.action_code%TYPE,

424:
425: ******************************************************************/
426: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,
427: p_person_id igs_sv_btch_summary.person_id%TYPE,
428: p_action igs_sv_btch_summary.action_code%TYPE,
429: p_tag_code igs_sv_btch_summary.tag_code%TYPE
430: )
431: RETURN NUMBER
432: IS

Line 429: p_tag_code igs_sv_btch_summary.tag_code%TYPE

425: ******************************************************************/
426: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,
427: p_person_id igs_sv_btch_summary.person_id%TYPE,
428: p_action igs_sv_btch_summary.action_code%TYPE,
429: p_tag_code igs_sv_btch_summary.tag_code%TYPE
430: )
431: RETURN NUMBER
432: IS
433: l_is_mut_excl BOOLEAN := TRUE;

Line 10167: DELETE FROM igs_sv_btch_summary WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw

10163: DELETE FROM igs_sv_persons WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10164:
10165: DELETE FROM igs_sv_persons WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10166:
10167: DELETE FROM igs_sv_btch_summary WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw
10168:
10169: DELETE FROM igs_sv_btch_summary WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw
10170: /* Debug */
10171: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 10169: DELETE FROM igs_sv_btch_summary WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw

10165: DELETE FROM igs_sv_persons WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10166:
10167: DELETE FROM igs_sv_btch_summary WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw
10168:
10169: DELETE FROM igs_sv_btch_summary WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw
10170: /* Debug */
10171: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10172: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Remove_Person_Data';
10173: l_debug_str := 'Exiting Remove_Person_Data.';

Line 12179: Purpose : Insert batch summary into igs_sv_btch_summary before inserting in interface tables.

12175: Created By : prbhardw
12176:
12177: Date Created By : Dec 30, 2005
12178:
12179: Purpose : Insert batch summary into igs_sv_btch_summary before inserting in interface tables.
12180:
12181: Change History
12182: Who When What
12183: ------------------------------------------------------------------------

Line 12187: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,

12183: ------------------------------------------------------------------------
12184:
12185: ******************************************************************/
12186: PROCEDURE Insert_Summary_Info(
12187: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
12188: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,

Line 12188: p_person_id IN igs_sv_btch_summary.person_id%TYPE,

12184:
12185: ******************************************************************/
12186: PROCEDURE Insert_Summary_Info(
12187: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
12188: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
12192: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,

Line 12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,

12185: ******************************************************************/
12186: PROCEDURE Insert_Summary_Info(
12187: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
12188: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
12192: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
12193: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE

Line 12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,

12186: PROCEDURE Insert_Summary_Info(
12187: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
12188: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
12192: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
12193: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
12194: )

Line 12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,

12187: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
12188: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
12192: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
12193: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
12194: )
12195: IS

Line 12192: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,

12188: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
12192: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
12193: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
12194: )
12195: IS
12196: l_api_name CONSTANT VARCHAR(30) := 'Insert_Summary_Info';

Line 12193: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE

12189: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
12190: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
12191: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
12192: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
12193: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
12194: )
12195: IS
12196: l_api_name CONSTANT VARCHAR(30) := 'Insert_Summary_Info';
12197: l_count NUMBER;

Line 12199: SELECT max(batch_id) FROM IGS_SV_BTCH_SUMMARY;

12195: IS
12196: l_api_name CONSTANT VARCHAR(30) := 'Insert_Summary_Info';
12197: l_count NUMBER;
12198: CURSOR c_test IS
12199: SELECT max(batch_id) FROM IGS_SV_BTCH_SUMMARY;
12200: l_batch NUMBER(20) := 0;
12201: BEGIN
12202: /* Debug */
12203: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 12209: INSERT INTO IGS_SV_BTCH_SUMMARY (

12205: l_debug_str := 'Entering Insert_Summary_Info. p_data_rec.person_id is '||p_person_id|| ' and batch_id is '||p_batch_id;
12206: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12207: END IF;
12208:
12209: INSERT INTO IGS_SV_BTCH_SUMMARY (
12210: summary_id ,
12211: batch_id ,
12212: person_id ,
12213: action_code ,

Line 12327: CURSOR c_persons_per_batch(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)

12323: l_api_name CONSTANT VARCHAR(30) := 'compose_log_file';
12324: l_batch_count NUMBER(5) := 1;
12325: l_per_count NUMBER(5) := 0;
12326:
12327: CURSOR c_persons_per_batch(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12328: IS
12329: SELECT COUNT(DISTINCT person_id)
12330: FROM igs_sv_btch_summary
12331: WHERE batch_id = cp_batch_id;

Line 12330: FROM igs_sv_btch_summary

12326:
12327: CURSOR c_persons_per_batch(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12328: IS
12329: SELECT COUNT(DISTINCT person_id)
12330: FROM igs_sv_btch_summary
12331: WHERE batch_id = cp_batch_id;
12332:
12333: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12334: IS

Line 12333: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)

12329: SELECT COUNT(DISTINCT person_id)
12330: FROM igs_sv_btch_summary
12331: WHERE batch_id = cp_batch_id;
12332:
12333: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12334: IS
12335: SELECT hz.party_number prsn_num, lkp.meaning info
12336: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12337: WHERE svbs.batch_id = cp_batch_id

Line 12336: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp

12332:
12333: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12334: IS
12335: SELECT hz.party_number prsn_num, lkp.meaning info
12336: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12337: WHERE svbs.batch_id = cp_batch_id
12338: AND svbs.action_code = 'NEW'
12339: AND svbs.person_id = hz.party_id
12340: AND svbs.TAG_CODE = lkp.lookup_code

Line 12343: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)

12339: AND svbs.person_id = hz.party_id
12340: AND svbs.TAG_CODE = lkp.lookup_code
12341: AND lkp.lookup_type ='IGS_SV_COMP_TREE';
12342:
12343: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12344: IS
12345: SELECT hz.party_number prsn_num, lkp.meaning info
12346: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12347: WHERE svbs.batch_id = cp_batch_id

Line 12346: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp

12342:
12343: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12344: IS
12345: SELECT hz.party_number prsn_num, lkp.meaning info
12346: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12347: WHERE svbs.batch_id = cp_batch_id
12348: AND svbs.action_code <> 'NEW'
12349: AND svbs.person_id = hz.party_id
12350: AND svbs.TAG_CODE = lkp.lookup_code