1: PACKAGE PO_PRICE_ADJUSTMENTS_PKG AUTHID CURRENT_USER AS
2: -- $Header: PO_PRICE_ADJUSTMENTS_PKG.pls 120.0.12010000.4 2009/07/01 01:32:31 ababujan noship $
3:
4: ---------------------------------------------------------------
5: -- Global constants and types.
1: PACKAGE PO_PRICE_ADJUSTMENTS_PKG AUTHID CURRENT_USER AS
2: -- $Header: PO_PRICE_ADJUSTMENTS_PKG.pls 120.0.12010000.4 2009/07/01 01:32:31 ababujan noship $
3:
4: ---------------------------------------------------------------
5: -- Global constants and types.
6: ---------------------------------------------------------------
76: ,x_return_status OUT NOCOPY VARCHAR2
77: );
78:
79: PROCEDURE copy_line_adjustments
80: ( p_src_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
81: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS.po_header_id%TYPE
82: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
83: , p_mode IN VARCHAR2
84: , x_return_status_text OUT NOCOPY VARCHAR2
77: );
78:
79: PROCEDURE copy_line_adjustments
80: ( p_src_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
81: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS.po_header_id%TYPE
82: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
83: , p_mode IN VARCHAR2
84: , x_return_status_text OUT NOCOPY VARCHAR2
85: , x_return_status OUT NOCOPY VARCHAR2
78:
79: PROCEDURE copy_line_adjustments
80: ( p_src_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
81: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS.po_header_id%TYPE
82: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE
83: , p_mode IN VARCHAR2
84: , x_return_status_text OUT NOCOPY VARCHAR2
85: , x_return_status OUT NOCOPY VARCHAR2
86: );
85: , x_return_status OUT NOCOPY VARCHAR2
86: );
87:
88: PROCEDURE copy_draft_line_adjustments
89: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
90: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
91: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
92: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
93: , p_mode IN VARCHAR2
86: );
87:
88: PROCEDURE copy_draft_line_adjustments
89: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
90: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
91: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
92: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
93: , p_mode IN VARCHAR2
94: , x_return_status_text OUT NOCOPY VARCHAR2
87:
88: PROCEDURE copy_draft_line_adjustments
89: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
90: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
91: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
92: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
93: , p_mode IN VARCHAR2
94: , x_return_status_text OUT NOCOPY VARCHAR2
95: , x_return_status OUT NOCOPY VARCHAR2
88: PROCEDURE copy_draft_line_adjustments
89: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
90: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
91: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
92: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
93: , p_mode IN VARCHAR2
94: , x_return_status_text OUT NOCOPY VARCHAR2
95: , x_return_status OUT NOCOPY VARCHAR2
96: );
95: , x_return_status OUT NOCOPY VARCHAR2
96: );
97:
98: PROCEDURE delete_price_adjustments
99: ( p_po_header_id IN PO_PRICE_ADJUSTMENTS.po_header_id%TYPE
100: , p_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE DEFAULT NULL
101: );
102:
103: PROCEDURE delete_adjustment
96: );
97:
98: PROCEDURE delete_price_adjustments
99: ( p_po_header_id IN PO_PRICE_ADJUSTMENTS.po_header_id%TYPE
100: , p_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE DEFAULT NULL
101: );
102:
103: PROCEDURE delete_adjustment
104: ( p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS.price_adjustment_id%TYPE );
100: , p_po_line_id IN PO_PRICE_ADJUSTMENTS.po_line_id%TYPE DEFAULT NULL
101: );
102:
103: PROCEDURE delete_adjustment
104: ( p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS.price_adjustment_id%TYPE );
105: /*
106: PROCEDURE delete_adjustment_dependants
107: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
108: , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE );
103: PROCEDURE delete_adjustment
104: ( p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS.price_adjustment_id%TYPE );
105: /*
106: PROCEDURE delete_adjustment_dependants
107: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
108: , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE );
109: */
110:
111: END PO_PRICE_ADJUSTMENTS_PKG;
104: ( p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS.price_adjustment_id%TYPE );
105: /*
106: PROCEDURE delete_adjustment_dependants
107: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
108: , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE );
109: */
110:
111: END PO_PRICE_ADJUSTMENTS_PKG;
107: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
108: , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE );
109: */
110:
111: END PO_PRICE_ADJUSTMENTS_PKG;