DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_TBL_DATE

Line 48: p_need_by_date_tbl IN po_tbl_date,

44: -------------------------------------------------------------------------
45: PROCEDURE need_by_date(
46: p_id_tbl IN po_tbl_number,
47: p_purchase_basis_tbl IN po_tbl_varchar30,
48: p_need_by_date_tbl IN po_tbl_date,
49: x_results IN OUT NOCOPY po_validation_results_type,
50: x_result_type OUT NOCOPY VARCHAR2)
51: IS
52: d_mod CONSTANT VARCHAR2(100) := d_need_by_date;

Line 99: p_promised_date_tbl IN po_tbl_date,

95: -------------------------------------------------------------------------
96: PROCEDURE promised_date(
97: p_id_tbl IN po_tbl_number,
98: p_purchase_basis_tbl IN po_tbl_varchar30,
99: p_promised_date_tbl IN po_tbl_date,
100: x_results IN OUT NOCOPY po_validation_results_type,
101: x_result_type OUT NOCOPY VARCHAR2)
102: IS
103: d_mod CONSTANT VARCHAR2(100) := d_promised_date;

Line 1107: p_from_date_tbl IN po_tbl_date,

1103: -- validate price break attributes
1104: -------------------------------------------------------------------------
1105: PROCEDURE price_break_attributes(
1106: p_id_tbl IN po_tbl_number,
1107: p_from_date_tbl IN po_tbl_date,
1108: p_to_date_tbl IN po_tbl_date,
1109: p_quantity_tbl IN po_tbl_number,
1110: p_ship_to_org_id_tbl IN po_tbl_number,
1111: p_ship_to_location_id_tbl IN po_tbl_number,

Line 1108: p_to_date_tbl IN po_tbl_date,

1104: -------------------------------------------------------------------------
1105: PROCEDURE price_break_attributes(
1106: p_id_tbl IN po_tbl_number,
1107: p_from_date_tbl IN po_tbl_date,
1108: p_to_date_tbl IN po_tbl_date,
1109: p_quantity_tbl IN po_tbl_number,
1110: p_ship_to_org_id_tbl IN po_tbl_number,
1111: p_ship_to_location_id_tbl IN po_tbl_number,
1112: x_results IN OUT NOCOPY po_validation_results_type,

Line 1166: p_line_expiration_date_tbl IN po_tbl_date,

1162: -- validate_effective_dates
1163: -------------------------------------------------------------------------
1164: PROCEDURE effective_dates(
1165: p_id_tbl IN po_tbl_number,
1166: p_line_expiration_date_tbl IN po_tbl_date,
1167: p_to_date_tbl IN po_tbl_date,
1168: p_from_date_tbl IN po_tbl_date,
1169: p_header_start_date_tbl IN po_tbl_date,
1170: p_header_end_date_tbl IN po_tbl_date,

Line 1167: p_to_date_tbl IN po_tbl_date,

1163: -------------------------------------------------------------------------
1164: PROCEDURE effective_dates(
1165: p_id_tbl IN po_tbl_number,
1166: p_line_expiration_date_tbl IN po_tbl_date,
1167: p_to_date_tbl IN po_tbl_date,
1168: p_from_date_tbl IN po_tbl_date,
1169: p_header_start_date_tbl IN po_tbl_date,
1170: p_header_end_date_tbl IN po_tbl_date,
1171: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163

Line 1168: p_from_date_tbl IN po_tbl_date,

1164: PROCEDURE effective_dates(
1165: p_id_tbl IN po_tbl_number,
1166: p_line_expiration_date_tbl IN po_tbl_date,
1167: p_to_date_tbl IN po_tbl_date,
1168: p_from_date_tbl IN po_tbl_date,
1169: p_header_start_date_tbl IN po_tbl_date,
1170: p_header_end_date_tbl IN po_tbl_date,
1171: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
1172: x_results IN OUT NOCOPY po_validation_results_type,

Line 1169: p_header_start_date_tbl IN po_tbl_date,

1165: p_id_tbl IN po_tbl_number,
1166: p_line_expiration_date_tbl IN po_tbl_date,
1167: p_to_date_tbl IN po_tbl_date,
1168: p_from_date_tbl IN po_tbl_date,
1169: p_header_start_date_tbl IN po_tbl_date,
1170: p_header_end_date_tbl IN po_tbl_date,
1171: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
1172: x_results IN OUT NOCOPY po_validation_results_type,
1173: x_result_type OUT NOCOPY VARCHAR2)

Line 1170: p_header_end_date_tbl IN po_tbl_date,

1166: p_line_expiration_date_tbl IN po_tbl_date,
1167: p_to_date_tbl IN po_tbl_date,
1168: p_from_date_tbl IN po_tbl_date,
1169: p_header_start_date_tbl IN po_tbl_date,
1170: p_header_end_date_tbl IN po_tbl_date,
1171: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
1172: x_results IN OUT NOCOPY po_validation_results_type,
1173: x_result_type OUT NOCOPY VARCHAR2)
1174: IS

Line 1996: p_need_by_date_tbl IN po_tbl_date,

1992: PROCEDURE tax_name(
1993: p_id_tbl IN po_tbl_number,
1994: p_tax_name_tbl IN po_tbl_varchar30,
1995: p_tax_code_id_tbl IN po_tbl_number,
1996: p_need_by_date_tbl IN po_tbl_date,
1997: p_allow_tax_code_override IN VARCHAR2,
1998: p_operating_unit IN NUMBER,
1999: x_result_set_id IN OUT NOCOPY NUMBER,
2000: x_result_type OUT NOCOPY VARCHAR2)