APPS.OE_REASONS_UTIL dependencies on OE_REASONS

Line 1: PACKAGE BODY OE_Reasons_Util AS

1: PACKAGE BODY OE_Reasons_Util AS
2: /* $Header: OEXURSNB.pls 120.0 2005/06/01 00:52:06 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Reasons_Util';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Reasons_Util';

1: PACKAGE BODY OE_Reasons_Util AS
2: /* $Header: OEXURSNB.pls 120.0 2005/06/01 00:52:06 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Reasons_Util';
5:
6: /*
7: Valid entity codes matches with OE_GLOBALS.G_ENTITY_%
8: HEADER

Line 94: SELECT OE_REASONS_S.NEXTVAL INTO x_reason_id FROM dual;

90:
91: l_version_number := 0;
92: END IF;
93:
94: SELECT OE_REASONS_S.NEXTVAL INTO x_reason_id FROM dual;
95:
96: INSERT INTO OE_REASONS
97: (reason_id,
98: entity_code,

Line 96: INSERT INTO OE_REASONS

92: END IF;
93:
94: SELECT OE_REASONS_S.NEXTVAL INTO x_reason_id FROM dual;
95:
96: INSERT INTO OE_REASONS
97: (reason_id,
98: entity_code,
99: entity_id,
100: header_id,

Line 159: FROM OE_REASONS

155: IF p_reason_id IS NOT NULL THEN
156:
157: SELECT reason_type, reason_code, comments
158: INTO x_reason_type, x_reason_code, x_reason_comments
159: FROM OE_REASONS
160: WHERE REASON_ID = p_reason_id;
161:
162: ELSE
163:

Line 166: FROM OE_REASONS

162: ELSE
163:
164: SELECT reason_type, reason_code, comments
165: INTO x_reason_type, x_reason_code, x_reason_comments
166: FROM OE_REASONS
167: WHERE entity_code = p_entity_code
168: AND entity_id = p_entity_id
169: AND version_number = p_version_number;
170:

Line 189: END OE_Reasons_Util;

185:
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END Get_Reason;
188:
189: END OE_Reasons_Util;