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:
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,
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,
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: );
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,
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
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: );