DBA Data[Home] [Help]

APPS.IGS_AD_IMP_025 dependencies on IGS_PE_HEARING_DTLS_PKG

Line 1100: Igs_Pe_Hearing_Dtls_Pkg.insert_row (

1096: l_debug_str, NULL,
1097: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1098: END IF;
1099:
1100: Igs_Pe_Hearing_Dtls_Pkg.insert_row (
1101: x_rowid => l_rowid ,
1102: x_hearing_details_id=> l_hearing_details_id,
1103: x_person_id => p_hearing_dtls_rec.person_id,
1104: x_description => p_hearing_dtls_rec.description,

Line 1312: igs_pe_hearing_dtls_pkg.update_row(

1308: IF dup_chk_rec.hearing_details_id IS NOT NULL THEN
1309: --If its a duplicate record find the source category rule for that Source Category.
1310: IF l_rule = 'I' THEN
1311: BEGIN
1312: igs_pe_hearing_dtls_pkg.update_row(
1313: x_rowid => dup_chk_rec.rowid,
1314: x_hearing_details_id=>dup_chk_rec.hearing_details_id,
1315: x_person_id => NVL(hearing_dtls_rec.person_id,dup_chk_rec.person_id),
1316: x_description => hearing_dtls_rec.description,

Line 1376: igs_pe_hearing_dtls_pkg.update_row(

1372: END;
1373: ELSIF l_rule = 'R' THEN
1374: IF hearing_dtls_rec.match_ind = '21' THEN
1375: BEGIN
1376: igs_pe_hearing_dtls_pkg.update_row(
1377: x_rowid => dup_chk_rec.rowid,
1378: x_hearing_details_id=>dup_chk_rec.hearing_details_id,
1379: x_person_id => NVL(hearing_dtls_rec.person_id,dup_chk_rec.person_id),
1380: x_description => hearing_dtls_rec.description,