DBA Data[Home] [Help]

APPS.PO_HXC_INTERFACE_PVT dependencies on PO_HXC_INTERFACE_PVT

Line 1: PACKAGE BODY PO_HXC_INTERFACE_PVT AS

1: PACKAGE BODY PO_HXC_INTERFACE_PVT AS
2: /* $Header: POXVIHXB.pls 120.2.12020000.2 2013/02/10 19:05:50 vegajula ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HXC_INTERFACE_PVT';
5: g_log_head CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HXC_INTERFACE_PVT';

1: PACKAGE BODY PO_HXC_INTERFACE_PVT AS
2: /* $Header: POXVIHXB.pls 120.2.12020000.2 2013/02/10 19:05:50 vegajula ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HXC_INTERFACE_PVT';
5: g_log_head CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
6: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8:

Line 75: IF PO_HXC_INTERFACE_PVT.field_PO_HEADER_ID = p_field_name THEN

71: ||' field_name: '||p_field_name
72: ||' field_value: '||p_field_value);
73: END IF;
74:
75: IF PO_HXC_INTERFACE_PVT.field_PO_HEADER_ID = p_field_name THEN
76: SELECT
77: sign(count(*))
78: INTO
79: l_exists_flag

Line 86: ELSIF PO_HXC_INTERFACE_PVT.field_PO_LINE_ID = p_field_name THEN

82: WHERE
83: LINE.PO_HEADER_ID = p_field_value
84: AND LINE.ORDER_TYPE_LOOKUP_CODE = c_RATE;
85:
86: ELSIF PO_HXC_INTERFACE_PVT.field_PO_LINE_ID = p_field_name THEN
87: SELECT
88: sign(count(*))
89: INTO
90: l_exists_flag

Line 191: p_field_name => PO_HXC_INTERFACE_PVT.field_PO_LINE_ID(),

187:
188: --
189: check_if_line_rate_based (p_api_version => p_api_version,
190: x_return_status => l_return_status,
191: p_field_name => PO_HXC_INTERFACE_PVT.field_PO_LINE_ID(),
192: p_field_value => p_po_line_id,
193: x_line_rate_based => l_line_rate_based);
194: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 549: p_field_name => PO_HXC_INTERFACE_PVT.field_PO_LINE_ID(),

545:
546: --
547: check_if_line_rate_based (p_api_version => p_api_version,
548: x_return_status => l_return_status,
549: p_field_name => PO_HXC_INTERFACE_PVT.field_PO_LINE_ID(),
550: p_field_value => p_po_line_id,
551: x_line_rate_based => l_line_rate_based);
552:
553: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 616: END PO_HXC_INTERFACE_PVT;

612: PO_DEBUG.debug_exc(l_log_head, l_progress);
613: END IF;
614: END get_pa_timecard_amount;
615:
616: END PO_HXC_INTERFACE_PVT;