DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_TBL_DATE

Line 147: p_expiration_date_tbl IN po_tbl_date,

143: -- cannot be later than header effective end date
144: -------------------------------------------------------------------------
145: PROCEDURE expiration_date_blanket(
146: p_id_tbl IN po_tbl_number,
147: p_expiration_date_tbl IN po_tbl_date,
148: p_header_start_date_tbl IN po_tbl_date,
149: p_header_end_date_tbl IN po_tbl_date,
150: x_results IN OUT NOCOPY po_validation_results_type,
151: x_result_type OUT NOCOPY VARCHAR2)

Line 148: p_header_start_date_tbl IN po_tbl_date,

144: -------------------------------------------------------------------------
145: PROCEDURE expiration_date_blanket(
146: p_id_tbl IN po_tbl_number,
147: p_expiration_date_tbl IN po_tbl_date,
148: p_header_start_date_tbl IN po_tbl_date,
149: p_header_end_date_tbl IN po_tbl_date,
150: x_results IN OUT NOCOPY po_validation_results_type,
151: x_result_type OUT NOCOPY VARCHAR2)
152: IS

Line 149: p_header_end_date_tbl IN po_tbl_date,

145: PROCEDURE expiration_date_blanket(
146: p_id_tbl IN po_tbl_number,
147: p_expiration_date_tbl IN po_tbl_date,
148: p_header_start_date_tbl IN po_tbl_date,
149: p_header_end_date_tbl IN po_tbl_date,
150: x_results IN OUT NOCOPY po_validation_results_type,
151: x_result_type OUT NOCOPY VARCHAR2)
152: IS
153: d_mod CONSTANT VARCHAR2(100) := d_expiration_date_blanket;

Line 2740: p_start_date_tbl IN po_tbl_date,

2736: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2737: -------------------------------------------------------------------------
2738: PROCEDURE start_date_standard(
2739: p_id_tbl IN po_tbl_number,
2740: p_start_date_tbl IN po_tbl_date,
2741: p_expiration_date_tbl IN po_tbl_date,
2742: p_purchase_basis_tbl IN po_tbl_varchar30,
2743: x_results IN OUT NOCOPY po_validation_results_type,
2744: x_result_type OUT NOCOPY VARCHAR2)

Line 2741: p_expiration_date_tbl IN po_tbl_date,

2737: -------------------------------------------------------------------------
2738: PROCEDURE start_date_standard(
2739: p_id_tbl IN po_tbl_number,
2740: p_start_date_tbl IN po_tbl_date,
2741: p_expiration_date_tbl IN po_tbl_date,
2742: p_purchase_basis_tbl IN po_tbl_varchar30,
2743: x_results IN OUT NOCOPY po_validation_results_type,
2744: x_result_type OUT NOCOPY VARCHAR2)
2745: IS