APPS.IGS_AD_IMP_007 dependencies on IGS_PE_MIL_SERVICES_PKG

Line 134: IGS_PE_MIL_SERVICES_pkg.INSERT_ROW (

130: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
131: END IF;
132:
133: l_org_id := igs_ge_gen_003.get_org_id;
134: IGS_PE_MIL_SERVICES_pkg.INSERT_ROW (
135: X_ROWID => l_rowid,
136: X_Org_Id => l_org_id,
137: x_MILIT_SERVICE_ID => l_milt_id,
138: x_PERSON_ID => MILITARY_REC.PERSON_ID ,

Line 471: igs_pe_mil_services_pkg.update_row(

467: CLOSE chk_dup_milit;
468: IF dup_milit_rec.military_type_cd IS NOT NULL THEN
469: IF l_rule = 'I' THEN
470: BEGIN
471: igs_pe_mil_services_pkg.update_row(
472: x_rowid=> dup_milit_rec.rowid,
473: x_milit_service_id=> dup_milit_rec.milit_service_id,
474: x_person_id=> dup_milit_rec.person_id,
475: x_start_date=> NVL(TRUNC(military_rec.start_date),dup_milit_rec.start_date),

Line 540: igs_pe_mil_services_pkg.update_row(

536: END;
537: ELSIF l_rule = 'R' THEN
538: IF MILITARY_REC.match_ind = cst_mi_val_21 THEN
539: BEGIN
540: igs_pe_mil_services_pkg.update_row(
541: x_rowid=> dup_milit_rec.rowid,
542: x_milit_service_id=> dup_milit_rec.milit_service_id,
543: x_person_id=>dup_milit_rec.person_id,
544: x_start_date=> NVL(TRUNC(military_rec.start_date),dup_milit_rec.start_date),