27:
28: IF (X_RECORD_TYPE NOT IN ('CART','ORDER')) Then
29: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
30: FND_MSG_PUB.ADD;
31: RAISE FND_API.G_EXC_ERROR;
32: END IF;
33:
34: IF (X_RECORD_TYPE = 'CART')
35: THEN
32: END IF;
33:
34: IF (X_RECORD_TYPE = 'CART')
35: THEN
36: IF ((X_PARTY_ID is null OR X_PARTY_ID =FND_API.G_MISS_NUM)
37: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM))
38: THEN
39: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
40: FND_MSG_PUB.ADD;
33:
34: IF (X_RECORD_TYPE = 'CART')
35: THEN
36: IF ((X_PARTY_ID is null OR X_PARTY_ID =FND_API.G_MISS_NUM)
37: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM))
38: THEN
39: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
40: FND_MSG_PUB.ADD;
41: RAISE FND_API.G_EXC_ERROR;
37: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM))
38: THEN
39: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
40: FND_MSG_PUB.ADD;
41: RAISE FND_API.G_EXC_ERROR;
42: END IF;
43: END IF;
44:
45: if (X_RECORD_TYPE = 'ORDER')
43: END IF;
44:
45: if (X_RECORD_TYPE = 'ORDER')
46: then
47: if ((X_PARTY_ID is null OR X_PARTY_ID =FND_API.G_MISS_NUM)
48: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM)
49: OR (X_CURRENCY_CODE is null OR X_CURRENCY_CODE = FND_API.G_MISS_CHAR))
50: then
51: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
44:
45: if (X_RECORD_TYPE = 'ORDER')
46: then
47: if ((X_PARTY_ID is null OR X_PARTY_ID =FND_API.G_MISS_NUM)
48: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM)
49: OR (X_CURRENCY_CODE is null OR X_CURRENCY_CODE = FND_API.G_MISS_CHAR))
50: then
51: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
52: FND_MSG_PUB.ADD;
45: if (X_RECORD_TYPE = 'ORDER')
46: then
47: if ((X_PARTY_ID is null OR X_PARTY_ID =FND_API.G_MISS_NUM)
48: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM)
49: OR (X_CURRENCY_CODE is null OR X_CURRENCY_CODE = FND_API.G_MISS_CHAR))
50: then
51: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
49: OR (X_CURRENCY_CODE is null OR X_CURRENCY_CODE = FND_API.G_MISS_CHAR))
50: then
51: FND_MESSAGE.Set_Name('IBE','IBE_PRMT_REQUIRED_MISSING_G');
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
54: end if;
55: end if;
56:
57: l_last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
54: end if;
55: end if;
56:
57: l_last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
58: IF ((x_org_id is null ) or (x_org_id = FND_API.G_MISS_NUM)) THEN
59: l_org_id := MO_GLOBAL.get_current_org_id();
60: ELSE
61: l_org_id := x_org_id;
62: END IF;
83: CURRENCY_CODE,
84: ORG_ID
85: )
86: VALUES(
87: DECODE(L_ACTIVE_QUOTE_ID ,FND_API.G_MISS_NUM,NULL,L_ACTIVE_QUOTE_ID),
88: /*DECODE(x_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_APPLICATION_ID),
89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
84: ORG_ID
85: )
86: VALUES(
87: DECODE(L_ACTIVE_QUOTE_ID ,FND_API.G_MISS_NUM,NULL,L_ACTIVE_QUOTE_ID),
88: /*DECODE(x_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_APPLICATION_ID),
89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
85: )
86: VALUES(
87: DECODE(L_ACTIVE_QUOTE_ID ,FND_API.G_MISS_NUM,NULL,L_ACTIVE_QUOTE_ID),
88: /*DECODE(x_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_APPLICATION_ID),
89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
86: VALUES(
87: DECODE(L_ACTIVE_QUOTE_ID ,FND_API.G_MISS_NUM,NULL,L_ACTIVE_QUOTE_ID),
88: /*DECODE(x_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_APPLICATION_ID),
89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
87: DECODE(L_ACTIVE_QUOTE_ID ,FND_API.G_MISS_NUM,NULL,L_ACTIVE_QUOTE_ID),
88: /*DECODE(x_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_APPLICATION_ID),
89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
88: /*DECODE(x_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_APPLICATION_ID),
89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_DATE),*/
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),
94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),
102: DECODE(x_CURRENCY_CODE ,FND_API.G_MISS_CHAR,NULL,x_CURRENCY_CODE),
95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),
102: DECODE(x_CURRENCY_CODE ,FND_API.G_MISS_CHAR,NULL,x_CURRENCY_CODE),
103: DECODE(l_ORG_ID ,FND_API.G_MISS_NUM,NULL,l_ORG_ID));
96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),
102: DECODE(x_CURRENCY_CODE ,FND_API.G_MISS_CHAR,NULL,x_CURRENCY_CODE),
103: DECODE(l_ORG_ID ,FND_API.G_MISS_NUM,NULL,l_ORG_ID));
104:
97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),
102: DECODE(x_CURRENCY_CODE ,FND_API.G_MISS_CHAR,NULL,x_CURRENCY_CODE),
103: DECODE(l_ORG_ID ,FND_API.G_MISS_NUM,NULL,l_ORG_ID));
104:
105: end INSERT_ROW;
98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),
102: DECODE(x_CURRENCY_CODE ,FND_API.G_MISS_CHAR,NULL,x_CURRENCY_CODE),
103: DECODE(l_ORG_ID ,FND_API.G_MISS_NUM,NULL,l_ORG_ID));
104:
105: end INSERT_ROW;
106:
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),
100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),
101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),
102: DECODE(x_CURRENCY_CODE ,FND_API.G_MISS_CHAR,NULL,x_CURRENCY_CODE),
103: DECODE(l_ORG_ID ,FND_API.G_MISS_NUM,NULL,l_ORG_ID));
104:
105: end INSERT_ROW;
106:
107: procedure UPDATE_ROW (
127: then
128:
129: update IBE_ACTIVE_QUOTES_ALL set
130: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
131: QUOTE_HEADER_ID = DECODE(X_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_QUOTE_HEADER_ID),
132: ORDER_HEADER_ID = DECODE(X_ORDER_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_ORDER_HEADER_ID),
133: PARTY_ID = X_PARTY_ID,
134: CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID,
135: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
128:
129: update IBE_ACTIVE_QUOTES_ALL set
130: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
131: QUOTE_HEADER_ID = DECODE(X_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_QUOTE_HEADER_ID),
132: ORDER_HEADER_ID = DECODE(X_ORDER_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_ORDER_HEADER_ID),
133: PARTY_ID = X_PARTY_ID,
134: CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID,
135: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
136: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
143: elsif (X_RECORD_TYPE='ORDER') then
144:
145: update IBE_ACTIVE_QUOTES_ALL set
146: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
147: QUOTE_HEADER_ID = DECODE(X_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_QUOTE_HEADER_ID),
148: ORDER_HEADER_ID = DECODE(X_ORDER_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_ORDER_HEADER_ID),
149: PARTY_ID = X_PARTY_ID,
150: CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID,
151: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
144:
145: update IBE_ACTIVE_QUOTES_ALL set
146: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
147: QUOTE_HEADER_ID = DECODE(X_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_QUOTE_HEADER_ID),
148: ORDER_HEADER_ID = DECODE(X_ORDER_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_ORDER_HEADER_ID),
149: PARTY_ID = X_PARTY_ID,
150: CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID,
151: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
152: LAST_UPDATED_BY = X_LAST_UPDATED_BY,