DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_TBL_DATE

Line 19: p_expiration_date_tbl IN po_tbl_date,

15: -- Expiration date on the line cannot be earlier than the header effective start date and
16: -- cannot be later than header effective end date
17: -------------------------------------------------------------------------
18: PROCEDURE expiration_date_blanket(p_id_tbl IN po_tbl_number,
19: p_expiration_date_tbl IN po_tbl_date,
20: p_header_start_date_tbl IN po_tbl_date,
21: p_header_end_date_tbl IN po_tbl_date,
22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
23: x_result_type OUT NOCOPY VARCHAR2);

Line 20: p_header_start_date_tbl IN po_tbl_date,

16: -- cannot be later than header effective end date
17: -------------------------------------------------------------------------
18: PROCEDURE expiration_date_blanket(p_id_tbl IN po_tbl_number,
19: p_expiration_date_tbl IN po_tbl_date,
20: p_header_start_date_tbl IN po_tbl_date,
21: p_header_end_date_tbl IN po_tbl_date,
22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
23: x_result_type OUT NOCOPY VARCHAR2);
24:

Line 21: p_header_end_date_tbl IN po_tbl_date,

17: -------------------------------------------------------------------------
18: PROCEDURE expiration_date_blanket(p_id_tbl IN po_tbl_number,
19: p_expiration_date_tbl IN po_tbl_date,
20: p_header_start_date_tbl IN po_tbl_date,
21: p_header_end_date_tbl IN po_tbl_date,
22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
23: x_result_type OUT NOCOPY VARCHAR2);
24:
25: -------------------------------------------------------------------------

Line 293: p_start_date_tbl IN PO_TBL_DATE,

289: --Expiration date if provided should be later than the start date
290: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
291: -------------------------------------------------------------------------
292: PROCEDURE start_date_standard(p_id_tbl IN PO_TBL_NUMBER,
293: p_start_date_tbl IN PO_TBL_DATE,
294: p_expiration_date_tbl IN PO_TBL_DATE,
295: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,
296: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
297: x_result_type OUT NOCOPY VARCHAR2);

Line 294: p_expiration_date_tbl IN PO_TBL_DATE,

290: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
291: -------------------------------------------------------------------------
292: PROCEDURE start_date_standard(p_id_tbl IN PO_TBL_NUMBER,
293: p_start_date_tbl IN PO_TBL_DATE,
294: p_expiration_date_tbl IN PO_TBL_DATE,
295: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,
296: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
297: x_result_type OUT NOCOPY VARCHAR2);
298: