APPS.PO_HXC_INTERFACE_PVT dependencies on PO_LINES_ALL

Line 81: PO_LINES_ALL LINE

77: sign(count(*))
78: INTO
79: l_exists_flag
80: FROM
81: PO_LINES_ALL LINE
82: WHERE
83: LINE.PO_HEADER_ID = p_field_value
84: AND LINE.ORDER_TYPE_LOOKUP_CODE = c_RATE;
85:

Line 92: PO_LINES_ALL LINE

88: sign(count(*))
89: INTO
90: l_exists_flag
91: FROM
92: PO_LINES_ALL LINE
93: WHERE
94: LINE.PO_LINE_ID = p_field_value
95: AND LINE.order_type_lookup_code = c_RATE;
96:

Line 158: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

154: -------------------------------------------------------------------------------
155: PROCEDURE get_timecard_amount (
156: p_api_version IN NUMBER,
157: x_return_status OUT NOCOPY VARCHAR2,
158: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
159: x_amount OUT NOCOPY NUMBER
160: ) IS
161: l_api_name CONSTANT VARCHAR2(30) := 'GET_TIMECARD_AMOUNT';
162: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 284: p_end_date IN PO_LINES_ALL.expiration_date%TYPE,

280: p_api_version IN NUMBER,
281: x_return_status OUT NOCOPY VARCHAR2,
282: p_field_name IN VARCHAR2,
283: p_field_value IN VARCHAR2,
284: p_end_date IN PO_LINES_ALL.expiration_date%TYPE,
285: x_timecard_exists OUT NOCOPY BOOLEAN
286: ) IS
287: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_TIMECARD_EXISTS';
288: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 514: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

510: -------------------------------------------------------------------------------
511: PROCEDURE get_pa_timecard_amount (
512: p_api_version IN NUMBER,
513: x_return_status OUT NOCOPY VARCHAR2,
514: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
515: p_project_id IN PO_DISTRIBUTIONS_ALL.project_id%TYPE ,
516: p_task_id IN PO_DISTRIBUTIONS_ALL.task_id%TYPE,
517: x_amount OUT NOCOPY NUMBER
518: ) IS