APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_EXT_RUN_DTLS

Line 6: g_he_ext_run_dtls igs_he_ext_run_dtls%ROWTYPE;

2: /* $Header: IGSHE9AB.pls 120.8 2006/05/02 22:39:01 jtmathew ship $ */
3:
4: -- Variables that will be accessed by any or all the procedures
5: -- Extract related records
6: g_he_ext_run_dtls igs_he_ext_run_dtls%ROWTYPE;
7: g_he_ext_run_except igs_he_ext_run_excp%ROWTYPE;
8: g_he_submsn_return igs_he_submsn_return%ROWTYPE;
9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
10:

Line 2178: (p_extract_run_id IN igs_he_ext_run_dtls.extract_run_id%TYPE)

2174: Parameters :
2175: p_extract_run_id IN The Extract Run Id
2176: ----------------------------------------------------------------------*/
2177: PROCEDURE get_marked_rows
2178: (p_extract_run_id IN igs_he_ext_run_dtls.extract_run_id%TYPE)
2179:
2180: IS
2181: /***************************************************************
2182: Created By : Bidisha S

Line 2342: p_extract_run_id IN igs_he_ext_run_dtls.extract_run_id%TYPE,

2338: ----------------------------------------------------------------------*/
2339: PROCEDURE extract_main
2340: (errbuf IN OUT NOCOPY VARCHAR2,
2341: retcode IN OUT NOCOPY NUMBER,
2342: p_extract_run_id IN igs_he_ext_run_dtls.extract_run_id%TYPE,
2343: p_module_called_from IN VARCHAR2,
2344: p_new_run_flag IN VARCHAR2)
2345: IS
2346: /***************************************************************

Line 2384: FROM igs_he_ext_run_dtls a,

2380: c.offset_days ,
2381: c.validation_country ,
2382: Nvl(c.apply_to_atmpt_st_dt,'N') apply_to_atmpt_st_dt,
2383: Nvl(c.apply_to_inst_st_dt,'N') apply_to_inst_st_dt
2384: FROM igs_he_ext_run_dtls a,
2385: igs_he_submsn_return b,
2386: igs_he_submsn_header c
2387: WHERE a.extract_run_id = p_extract_run_id
2388: AND a.submission_name = b.submission_name

Line 2626: igs_he_ext_run_dtls_pkg.update_row

2622: END IF; -- records found check
2623:
2624: -- Mark Process as completed
2625: -- smaddali populating conc_request_id and date for bug 2483376
2626: igs_he_ext_run_dtls_pkg.update_row
2627: (X_rowid => l_ext_run_dtl_rowid,
2628: X_extract_run_id => p_extract_run_id,
2629: X_submission_name => g_he_ext_run_dtls.submission_name,
2630: X_user_return_subclass => g_he_ext_run_dtls.user_return_subclass,

Line 2687: igs_he_ext_run_dtls_pkg.update_row

2683: END IF;
2684:
2685: -- Mark Process as Errored
2686: -- smaddali populating conc_request_id and date for bug 2483376
2687: igs_he_ext_run_dtls_pkg.update_row
2688: (X_rowid => l_ext_run_dtl_rowid,
2689: X_extract_run_id => p_extract_run_id,
2690: X_submission_name => g_he_ext_run_dtls.submission_name,
2691: X_user_return_subclass => g_he_ext_run_dtls.user_return_subclass,