DBA Data[Home] [Help]

APPS.RG_ROW_ORDERS_PKG dependencies on RG_ROW_ORDERS

Line 1: PACKAGE BODY rg_row_orders_pkg AS

1: PACKAGE BODY rg_row_orders_pkg AS
2: /* $Header: rgirordb.pls 120.1 2003/04/29 01:29:22 djogg ship $ */
3: FUNCTION new_row_order_id
4: RETURN NUMBER
5: IS

Line 8: SELECT rg_row_orders_s.nextval

4: RETURN NUMBER
5: IS
6: new_sequence_number NUMBER;
7: BEGIN
8: SELECT rg_row_orders_s.nextval
9: INTO new_sequence_number
10: FROM dual;
11:
12: RETURN(new_sequence_number);

Line 34: FROM rg_row_orders

30: rec_returned NUMBER;
31: BEGIN
32: SELECT count(*)
33: INTO rec_returned
34: FROM rg_row_orders
35: WHERE row_order_id <> cur_row_order_id
36: AND name = new_name
37: AND application_id = cur_application_id;
38:

Line 63: END rg_row_orders_pkg;

59: FND_MESSAGE.set_token('OBJECT', 'RG_ROW_ORDER', TRUE);
60: APP_EXCEPTION.raise_exception;
61: END check_references;
62:
63: END rg_row_orders_pkg;