PACKAGE: APPS.PO_CHANGE_ORDER_TOLERANCES_PKG

Source

1 package PO_CHANGE_ORDER_TOLERANCES_PKG as
2 /* $Header: PO_CHANGE_ORDER_TOLERANCES_PKG.pls 120.1 2005/12/02 16:26:16 dreddy noship $ */
3 
4 ------------------------------------------------------------------------------
5 --Start of Comments
6 --Name: INSERT_ROW
7 --Pre-reqs:
8 --  None
9 --Modifies:
10 --  None
11 --Locks:
12 --  None
13 --Function:
14 --   1. inserts a record into PO_CHANGE_ORDER_TOLERANCES_ALL table
15 --Parameters:
16 --IN:
17 --   X_CHANGE_ORDER_TYPE Change Order Type
18 --   X_TOLERANCE_NAME    Tolerance name
19 --   X_ORG_ID            Operating Unit Id
20 --   X_SEQUENCE_NUMBER   Tolerance sequence number
21 --   X_MAXIMUM_INCREMENT maximum increment value
22 --   X_MAXIMUM_DECREMENT minimum increment value
23 --   X_ROUTING_FLAG      approval routing flag
24 --   X_CREATION_DATE     creation date (Standard Who Column)
25 --   X_CREATED_BY        created date (Standard Who Column)
26 --   X_LAST_UPDATE_DATE  last update date (Standard Who Column)
27 --   X_LAST_UPDATED_BY   last updated by (Standard Who Column)
28 --   X_LAST_UPDATE_LOGIN last update login (Standard Who Column)
29 --OUT:
30 --  None
31 --End of Comment
32 -------------------------------------------------------------------------------
33 procedure INSERT_ROW (
34   X_CHANGE_ORDER_TYPE in VARCHAR2,
35   X_TOLERANCE_NAME in VARCHAR2,
36   X_ORG_ID in NUMBER,
37   X_SEQUENCE_NUMBER in NUMBER,
38   X_MAXIMUM_INCREMENT in NUMBER,
39   X_MAXIMUM_DECREMENT in NUMBER,
40   X_ROUTING_FLAG in VARCHAR2,
41   X_CREATION_DATE in DATE,
42   X_CREATED_BY in NUMBER,
43   X_LAST_UPDATE_DATE in DATE,
44   X_LAST_UPDATED_BY in NUMBER,
45   X_LAST_UPDATE_LOGIN in NUMBER);
46 
47 ------------------------------------------------------------------------------
48 --Start of Comments
49 --Name: LOAD_ROW
50 --Pre-reqs:
51 --  None
52 --Modifies:
53 --  None
54 --Locks:
55 --  None
56 --Function:
57 --   1. Load the row into PO_CHANGE_ORDER_TOLERANCES_ALL table
58 --Parameters:
59 --IN:
60 --   X_CHANGE_ORDER_TYPE Change Order Type
61 --   X_TOLERANCE_NAME    Tolerance name
62 --   X_ORG_ID            Operating Unit Id
63 --   X_SEQUENCE_NUMBER   Tolerance sequence number
64 --   X_MAXIMUM_INCREMENT maximum increment value
65 --   X_MAXIMUM_DECREMENT minimum increment value
66 --   X_ROUTING_FLAG      approval routing flag
67 --OUT:
68 --  None
69 --End of Comment
70 -------------------------------------------------------------------------------
71 procedure LOAD_ROW (
72   X_CHANGE_ORDER_TYPE in VARCHAR2,
73   X_TOLERANCE_NAME in VARCHAR2,
74   X_ORG_ID in NUMBER,
75   X_OWNER in VARCHAR2,
76   X_SEQUENCE_NUMBER in NUMBER,
77   X_LAST_UPDATE_DATE in DATE,
78   X_MAXIMUM_INCREMENT in NUMBER,
79   X_MAXIMUM_DECREMENT in NUMBER,
80   X_ROUTING_FLAG in VARCHAR2,
81   X_CUSTOM_MODE in VARCHAR2);
82 
83 end PO_CHANGE_ORDER_TOLERANCES_PKG;