DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_TBL_DATE

Line 142: p_expiration_date_tbl IN po_tbl_date,

138: -- cannot be later than header effective end date
139: -------------------------------------------------------------------------
140: PROCEDURE expiration_date_blanket(
141: p_id_tbl IN po_tbl_number,
142: p_expiration_date_tbl IN po_tbl_date,
143: p_header_start_date_tbl IN po_tbl_date,
144: p_header_end_date_tbl IN po_tbl_date,
145: x_results IN OUT NOCOPY po_validation_results_type,
146: x_result_type OUT NOCOPY VARCHAR2)

Line 143: p_header_start_date_tbl IN po_tbl_date,

139: -------------------------------------------------------------------------
140: PROCEDURE expiration_date_blanket(
141: p_id_tbl IN po_tbl_number,
142: p_expiration_date_tbl IN po_tbl_date,
143: p_header_start_date_tbl IN po_tbl_date,
144: p_header_end_date_tbl IN po_tbl_date,
145: x_results IN OUT NOCOPY po_validation_results_type,
146: x_result_type OUT NOCOPY VARCHAR2)
147: IS

Line 144: p_header_end_date_tbl IN po_tbl_date,

140: PROCEDURE expiration_date_blanket(
141: p_id_tbl IN po_tbl_number,
142: p_expiration_date_tbl IN po_tbl_date,
143: p_header_start_date_tbl IN po_tbl_date,
144: p_header_end_date_tbl IN po_tbl_date,
145: x_results IN OUT NOCOPY po_validation_results_type,
146: x_result_type OUT NOCOPY VARCHAR2)
147: IS
148: d_mod CONSTANT VARCHAR2(100) := d_expiration_date_blanket;

Line 2679: p_start_date_tbl IN po_tbl_date,

2675: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2676: -------------------------------------------------------------------------
2677: PROCEDURE start_date_standard(
2678: p_id_tbl IN po_tbl_number,
2679: p_start_date_tbl IN po_tbl_date,
2680: p_expiration_date_tbl IN po_tbl_date,
2681: p_purchase_basis_tbl IN po_tbl_varchar30,
2682: x_results IN OUT NOCOPY po_validation_results_type,
2683: x_result_type OUT NOCOPY VARCHAR2)

Line 2680: p_expiration_date_tbl IN po_tbl_date,

2676: -------------------------------------------------------------------------
2677: PROCEDURE start_date_standard(
2678: p_id_tbl IN po_tbl_number,
2679: p_start_date_tbl IN po_tbl_date,
2680: p_expiration_date_tbl IN po_tbl_date,
2681: p_purchase_basis_tbl IN po_tbl_varchar30,
2682: x_results IN OUT NOCOPY po_validation_results_type,
2683: x_result_type OUT NOCOPY VARCHAR2)
2684: IS