APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_AD_TST_RSLT_DTLS

Line 1965: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%TYPE;

1961: P_MSG_DATA OUT NOCOPY VARCHAR2
1962: )
1963: IS
1964: l_rowid ROWID;
1965: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%TYPE;
1966: l_action VARCHAR2(30);
1967:
1968: CURSOR record_info_cur (cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE,
1969: cp_test_segment_id igs_ad_tst_rslt_dtls.test_segment_id%TYPE)

Line 1968: CURSOR record_info_cur (cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE,

1964: l_rowid ROWID;
1965: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%TYPE;
1966: l_action VARCHAR2(30);
1967:
1968: CURSOR record_info_cur (cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE,
1969: cp_test_segment_id igs_ad_tst_rslt_dtls.test_segment_id%TYPE)
1970: IS
1971: SELECT rowid, rslt_dtl.*
1972: FROM igs_ad_tst_rslt_dtls rslt_dtl

Line 1969: cp_test_segment_id igs_ad_tst_rslt_dtls.test_segment_id%TYPE)

1965: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%TYPE;
1966: l_action VARCHAR2(30);
1967:
1968: CURSOR record_info_cur (cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE,
1969: cp_test_segment_id igs_ad_tst_rslt_dtls.test_segment_id%TYPE)
1970: IS
1971: SELECT rowid, rslt_dtl.*
1972: FROM igs_ad_tst_rslt_dtls rslt_dtl
1973: WHERE rslt_dtl.test_results_id = cp_test_results_id AND

Line 1972: FROM igs_ad_tst_rslt_dtls rslt_dtl

1968: CURSOR record_info_cur (cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE,
1969: cp_test_segment_id igs_ad_tst_rslt_dtls.test_segment_id%TYPE)
1970: IS
1971: SELECT rowid, rslt_dtl.*
1972: FROM igs_ad_tst_rslt_dtls rslt_dtl
1973: WHERE rslt_dtl.test_results_id = cp_test_results_id AND
1974: rslt_dtl.test_segment_id = cp_test_segment_id;
1975:
1976: CURSOR parent_cur(cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE)

Line 1976: CURSOR parent_cur(cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE)

1972: FROM igs_ad_tst_rslt_dtls rslt_dtl
1973: WHERE rslt_dtl.test_results_id = cp_test_results_id AND
1974: rslt_dtl.test_segment_id = cp_test_segment_id;
1975:
1976: CURSOR parent_cur(cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE)
1977: IS
1978: SELECT test_date
1979: FROM igs_ad_test_results
1980: WHERE test_results_id = cp_test_results_id;

Line 2030: igs_ad_tst_rslt_dtls_pkg.insert_row(

2026: IGS_GE_MSG_STACK.ADD;
2027: App_Exception.Raise_Exception;
2028: END IF;
2029:
2030: igs_ad_tst_rslt_dtls_pkg.insert_row(
2031: X_ROWID => l_rowid,
2032: X_TST_RSLT_DTLS_ID => l_tst_rslt_dtls_id,
2033: X_TEST_RESULTS_ID => P_TEST_RESULT_ID,
2034: X_TEST_SEGMENT_ID => P_TEST_SEGMENT_ID,

Line 2068: igs_ad_tst_rslt_dtls_pkg.update_row(

2064: );
2065:
2066: ELSIF l_action = 'UPDATE' THEN
2067:
2068: igs_ad_tst_rslt_dtls_pkg.update_row(
2069: X_ROWID => record_info_rec.ROWID,
2070: X_TST_RSLT_DTLS_ID => record_info_rec.TST_RSLT_DTLS_ID,
2071: X_TEST_RESULTS_ID => record_info_rec.TEST_RESULTS_ID,
2072: X_TEST_SEGMENT_ID => record_info_rec.TEST_SEGMENT_ID,

Line 2106: igs_ad_tst_rslt_dtls_pkg.delete_row(

2102: );
2103:
2104: ELSIF l_action = 'DELETE' THEN
2105:
2106: igs_ad_tst_rslt_dtls_pkg.delete_row(
2107: x_rowid => record_info_rec.ROWID
2108: );
2109: END IF;
2110: