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

Line 142: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,

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

Line 143: p_person_id IN igs_sv_btch_summary.person_id%TYPE,

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

Line 144: p_action_code IN igs_sv_btch_summary.action_code%TYPE,

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

Line 145: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,

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

Line 146: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,

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

Line 147: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,

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

Line 148: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE

144: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
145: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
146: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
147: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
148: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
149: );
150:
151: PROCEDURE compose_log_file;
152: PROCEDURE xml_log_file (p_batch_id IN igs_sv_btch_summary.batch_id%TYPE);

Line 152: PROCEDURE xml_log_file (p_batch_id IN igs_sv_btch_summary.batch_id%TYPE);

148: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
149: );
150:
151: PROCEDURE compose_log_file;
152: PROCEDURE xml_log_file (p_batch_id IN igs_sv_btch_summary.batch_id%TYPE);
153: /*****************************************************************/
154: PROCEDURE Submit_Event (
155: p_batch_type IN VARCHAR2,
156: p_batch_id IN IGS_SV_BATCHES.BATCH_ID%TYPE

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

426: Who When What
427: ------------------------------------------------------------------------
428:
429: ******************************************************************/
430: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,
431: p_person_id igs_sv_btch_summary.person_id%TYPE,
432: p_action igs_sv_btch_summary.action_code%TYPE,
433: p_tag_code igs_sv_btch_summary.tag_code%TYPE
434: )

Line 431: p_person_id igs_sv_btch_summary.person_id%TYPE,

427: ------------------------------------------------------------------------
428:
429: ******************************************************************/
430: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,
431: p_person_id igs_sv_btch_summary.person_id%TYPE,
432: p_action igs_sv_btch_summary.action_code%TYPE,
433: p_tag_code igs_sv_btch_summary.tag_code%TYPE
434: )
435: RETURN NUMBER

Line 432: p_action igs_sv_btch_summary.action_code%TYPE,

428:
429: ******************************************************************/
430: FUNCTION chk_mut_exclusive(p_batch_id igs_sv_btch_summary.batch_id%TYPE,
431: p_person_id igs_sv_btch_summary.person_id%TYPE,
432: p_action igs_sv_btch_summary.action_code%TYPE,
433: p_tag_code igs_sv_btch_summary.tag_code%TYPE
434: )
435: RETURN NUMBER
436: IS

Line 433: p_tag_code igs_sv_btch_summary.tag_code%TYPE

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

Line 11306: 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

11302: DELETE FROM igs_sv_prgms_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11303:
11304: DELETE FROM igs_sv_persons WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
11305:
11306: 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
11307:
11308: /* Debug */
11309: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11310: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Remove_Person_Data';

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

13352: Created By : prbhardw
13353:
13354: Date Created By : Dec 30, 2005
13355:
13356: Purpose : Insert batch summary into igs_sv_btch_summary before inserting in interface tables.
13357:
13358: Change History
13359: Who When What
13360: ------------------------------------------------------------------------

Line 13364: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,

13360: ------------------------------------------------------------------------
13361:
13362: ******************************************************************/
13363: PROCEDURE Insert_Summary_Info(
13364: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
13365: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,

Line 13365: p_person_id IN igs_sv_btch_summary.person_id%TYPE,

13361:
13362: ******************************************************************/
13363: PROCEDURE Insert_Summary_Info(
13364: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
13365: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
13369: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,

Line 13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,

13362: ******************************************************************/
13363: PROCEDURE Insert_Summary_Info(
13364: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
13365: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
13369: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
13370: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE

Line 13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,

13363: PROCEDURE Insert_Summary_Info(
13364: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
13365: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
13369: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
13370: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
13371: )

Line 13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,

13364: p_batch_id IN igs_sv_btch_summary.batch_id%TYPE,
13365: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
13369: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
13370: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
13371: )
13372: IS

Line 13369: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,

13365: p_person_id IN igs_sv_btch_summary.person_id%TYPE,
13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
13369: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
13370: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
13371: )
13372: IS
13373: l_api_name CONSTANT VARCHAR(30) := 'Insert_Summary_Info';

Line 13370: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE

13366: p_action_code IN igs_sv_btch_summary.action_code%TYPE,
13367: p_tag_code IN igs_sv_btch_summary.tag_code%TYPE,
13368: p_adm_action IN igs_sv_btch_summary.adm_action_code%TYPE,
13369: p_owner_table_name IN igs_sv_btch_summary.owner_table_name%TYPE,
13370: p_owner_table_id IN igs_sv_btch_summary.OWNER_TABLE_IDENTIFIER%TYPE
13371: )
13372: IS
13373: l_api_name CONSTANT VARCHAR(30) := 'Insert_Summary_Info';
13374: l_count NUMBER;

Line 13376: SELECT max(batch_id) FROM IGS_SV_BTCH_SUMMARY;

13372: IS
13373: l_api_name CONSTANT VARCHAR(30) := 'Insert_Summary_Info';
13374: l_count NUMBER;
13375: CURSOR c_test IS
13376: SELECT max(batch_id) FROM IGS_SV_BTCH_SUMMARY;
13377: l_batch NUMBER(20) := 0;
13378: BEGIN
13379: /* Debug */
13380: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 13386: INSERT INTO IGS_SV_BTCH_SUMMARY (

13382: l_debug_str := 'Entering Insert_Summary_Info. p_data_rec.person_id is '||p_person_id|| ' and batch_id is '||p_batch_id;
13383: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13384: END IF;
13385:
13386: INSERT INTO IGS_SV_BTCH_SUMMARY (
13387: summary_id ,
13388: batch_id ,
13389: person_id ,
13390: action_code ,

Line 13513: PROCEDURE xml_log_file(p_batch_id IN igs_sv_btch_summary.batch_id%TYPE)

13509: Who When What
13510: ------------------------------------------------------------------------
13511:
13512: ******************************************************************/
13513: PROCEDURE xml_log_file(p_batch_id IN igs_sv_btch_summary.batch_id%TYPE)
13514: IS
13515:
13516: l_api_name CONSTANT VARCHAR(30) := 'xml_log_file';
13517: l_per_count NUMBER(5) := 0;

Line 13521: CURSOR c_updated_pers(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)

13517: l_per_count NUMBER(5) := 0;
13518: l_person_num hz_parties.party_number%TYPE;
13519: l_info_meaning igs_lookup_values.meaning%TYPE;
13520:
13521: CURSOR c_updated_pers(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13522: IS
13523: SELECT summ.person_id, summ.tag_code
13524: FROM igs_sv_btch_summary summ
13525: WHERE summ.batch_id = cp_batch_id AND

Line 13524: FROM igs_sv_btch_summary summ

13520:
13521: CURSOR c_updated_pers(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13522: IS
13523: SELECT summ.person_id, summ.tag_code
13524: FROM igs_sv_btch_summary summ
13525: WHERE summ.batch_id = cp_batch_id AND
13526: summ.adm_action_code ='HOLD' AND
13527: EXISTS (SELECT 1 FROM igs_sv_persons pers
13528: WHERE pers.person_id = summ.person_id AND

Line 13532: CURSOR c_new_pers(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)

13528: WHERE pers.person_id = summ.person_id AND
13529: pers.batch_id = summ.batch_id AND
13530: pers.record_status = 'C' );
13531:
13532: CURSOR c_new_pers(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13533: IS
13534: SELECT distinct person_number
13535: FROM igs_sv_persons pers
13536: WHERE pers.batch_id = cp_batch_id AND record_status = 'N'

Line 13538: FROM igs_sv_btch_summary summ

13534: SELECT distinct person_number
13535: FROM igs_sv_persons pers
13536: WHERE pers.batch_id = cp_batch_id AND record_status = 'N'
13537: AND EXISTS (SELECT 1
13538: FROM igs_sv_btch_summary summ
13539: WHERE summ.person_id = pers.person_id AND
13540: summ.batch_id=pers.batch_id AND
13541: summ.adm_action_code ='HOLD' AND
13542: summ.batch_id = pers.batch_id);

Line 13549: CURSOR c_get_info(cp_tag_code igs_sv_btch_summary.tag_code%TYPE)

13545: SELECT party_number
13546: FROM hz_parties
13547: WHERE party_id = cp_party_id;
13548:
13549: CURSOR c_get_info(cp_tag_code igs_sv_btch_summary.tag_code%TYPE)
13550: IS
13551: SELECT lkp.meaning info
13552: FROM igs_lookup_values lkp
13553: WHERE lkp.lookup_code = cp_tag_code

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

13632: l_api_name CONSTANT VARCHAR(30) := 'compose_log_file';
13633: l_batch_count NUMBER(5) := 1;
13634: l_per_count NUMBER(5) := 0;
13635:
13636: CURSOR c_persons_per_batch(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13637: IS
13638: SELECT COUNT(DISTINCT person_id)
13639: FROM igs_sv_btch_summary
13640: WHERE batch_id = cp_batch_id;

Line 13639: FROM igs_sv_btch_summary

13635:
13636: CURSOR c_persons_per_batch(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13637: IS
13638: SELECT COUNT(DISTINCT person_id)
13639: FROM igs_sv_btch_summary
13640: WHERE batch_id = cp_batch_id;
13641:
13642: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13643: IS

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

13638: SELECT COUNT(DISTINCT person_id)
13639: FROM igs_sv_btch_summary
13640: WHERE batch_id = cp_batch_id;
13641:
13642: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13643: IS
13644: SELECT hz.party_number prsn_num, lkp.meaning info
13645: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13646: WHERE svbs.batch_id = cp_batch_id

Line 13645: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers

13641:
13642: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13643: IS
13644: SELECT hz.party_number prsn_num, lkp.meaning info
13645: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13646: WHERE svbs.batch_id = cp_batch_id
13647: AND svbs.person_id = hz.party_id
13648: AND svbs.tag_code = lkp.lookup_code
13649: AND lkp.lookup_type ='IGS_SV_COMP_TREE'

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

13651: AND svbs.person_id = pers.person_id
13652: AND svbs.batch_id = pers.batch_id
13653: AND pers.record_status = 'N';
13654:
13655: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13656: IS
13657: SELECT hz.party_number prsn_num, lkp.meaning info
13658: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13659: WHERE svbs.batch_id = cp_batch_id

Line 13658: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers

13654:
13655: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13656: IS
13657: SELECT hz.party_number prsn_num, lkp.meaning info
13658: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13659: WHERE svbs.batch_id = cp_batch_id
13660: AND svbs.person_id = hz.party_id
13661: AND svbs.tag_code = lkp.lookup_code
13662: AND lkp.lookup_type ='IGS_SV_COMP_TREE'