1 package IBE_ACTIVE_QUOTES_ALL_PKG AUTHID CURRENT_USER as
2 /*$Header: IBEVAQRS.pls 120.1 2005/08/24 21:53:54 appldev ship $ */
3 procedure INSERT_ROW (
4 X_OBJECT_VERSION_NUMBER in NUMBER,
5 /*X_PROGRAM_APPLICATION_ID in NUMBER,
6 X_PROGRAM_ID in NUMBER,
7 X_PROGRAM_UPDATE_DATE in DATE,*/
8 X_QUOTE_HEADER_ID in NUMBER := FND_API.G_MISS_NUM,
9 X_PARTY_ID in NUMBER,
10 X_CUST_ACCOUNT_ID in NUMBER,
11 X_LAST_UPDATE_DATE in DATE,
12 X_CREATION_DATE in DATE,
13 X_CREATED_BY in NUMBER,
14 X_LAST_UPDATED_BY in NUMBER,
15 X_LAST_UPDATE_LOGIN in NUMBER,
16 X_RECORD_TYPE in VARCHAR2,
17 X_ORDER_HEADER_ID in NUMBER := FND_API.G_MISS_NUM,
18 X_CURRENCY_CODE in VARCHAR2,
19 X_ORG_ID in NUMBER := MO_GLOBAL.get_current_org_id()
20 );
21
22 -- For QUOTES flow
23 -- Combination is: party_id, cust_acct_id, org_id, record_type
24 -- currency_code - should be sent as G_MISS_CHAR
25
26 -- For RETURNS flow
27 -- Combination is: party_id, cust_acct_id, org_id, record_type, currency_code.
28
29 procedure UPDATE_ROW (
30 X_OBJECT_VERSION_NUMBER in NUMBER,
31 X_QUOTE_HEADER_ID in NUMBER := FND_API.G_MISS_NUM,
32 X_PARTY_ID in NUMBER,
33 X_CUST_ACCOUNT_ID in NUMBER,
34 X_ORDER_HEADER_ID in NUMBER := FND_API.G_MISS_NUM,
35 X_RECORD_TYPE in VARCHAR2,
36 X_CURRENCY_CODE in VARCHAR2 := FND_API.G_MISS_CHAR,
37 X_LAST_UPDATE_DATE in DATE,
38 X_LAST_UPDATED_BY in NUMBER,
39 X_LAST_UPDATE_LOGIN in NUMBER
40 );
41
42 procedure DELETE_ROW (
43 X_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
44 X_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
45 X_ORDER_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
46 X_CURRENCY_CODE IN VARCHAR2,
47 X_RECORD_TYPE IN VARCHAR2,
48 X_CUST_ACCOUNT_ID IN NUMBER
49 );
50
51 End IBE_ACTIVE_QUOTES_ALL_PKG;