PACKAGE: APPS.WSH_SHIP_CONFIRM_RULES_PVT

Source

1 PACKAGE  WSH_SHIP_CONFIRM_RULES_PVT AS
2 /* $Header: WSHSCTHS.pls 120.1 2005/07/29 19:23:27 wrudge noship $ */
3 
4 TYPE ship_confirm_rule_rectype IS RECORD (
5  SHIP_CONFIRM_RULE_ID                     NUMBER,
6  EFFECTIVE_START_DATE                     DATE,
7  NAME                                     VARCHAR2(30),
8  EFFECTIVE_END_DATE                       DATE,
9  ACTION_FLAG                              VARCHAR2(1),
10  STAGE_DEL_FLAG                           VARCHAR2(1),
11  SHIP_METHOD_DEFAULT_FLAG                 VARCHAR2(1),
12  SHIP_METHOD_CODE                         VARCHAR2(30),
13  AC_ACTUAL_DEP_DATE_DEFAULT               VARCHAR2(30),
14  AC_INTRANSIT_FLAG                        VARCHAR2(1),
15  AC_CLOSE_TRIP_FLAG                       VARCHAR2(1),
16  AC_BOL_FLAG                              VARCHAR2(1),
17  AC_DEFER_INTERFACE_FLAG                  VARCHAR2(1),
18  MC_INTRANSIT_FLAG                        VARCHAR2(1),
19  MC_CLOSE_TRIP_FLAG                       VARCHAR2(1),
20  MC_DEFER_INTERFACE_FLAG                  VARCHAR2(1),
21  MC_BOL_FLAG		                  VARCHAR2(1),
22  REPORT_SET_ID                            NUMBER,
23  SEND_945_FLAG                            VARCHAR2(1),
24  CREATION_DATE                            DATE,
25  CREATED_BY                               NUMBER,
26  LAST_UPDATED_BY                          NUMBER,
27  LAST_UPDATE_DATE                         DATE);
28 
29 
30 PROCEDURE Insert_Row (
31   p_ship_confirm_rule_info    IN  ship_confirm_rule_rectype,
32   x_rule_id                   OUT NOCOPY NUMBER,
33   x_row_id                    OUT NOCOPY VARCHAR2,
34   x_return_status             OUT NOCOPY VARCHAR2);
35 
36 PROCEDURE Update_Row (
37   p_ship_confirm_rule_info    IN  ship_confirm_rule_rectype,
38   x_return_status             OUT NOCOPY VARCHAR2);
39 
40 PROCEDURE Lock_Row(
41     p_rowid                  IN   VARCHAR2,
42     p_ship_confirm_rule_info IN   ship_confirm_rule_rectype) ;
43 
44 PROCEDURE Delete_Row(
45         p_rowid         IN  VARCHAR2,
46         x_return_status OUT NOCOPY VARCHAR2);
47 
48 END WSH_SHIP_CONFIRM_RULES_PVT;