APPS.IBE_ACTIVE_QUOTES_ALL_PKG dependencies on IBE_ACTIVE_QUOTES

Line 1: package body IBE_ACTIVE_QUOTES_ALL_PKG as

1: package body IBE_ACTIVE_QUOTES_ALL_PKG as
2: /*$Header: IBEVAQRB.pls 120.1 2005/08/24 21:56:03 appldev ship $ */
3: procedure INSERT_ROW (
4: X_OBJECT_VERSION_NUMBER in NUMBER,
5: /*X_PROGRAM_APPLICATION_ID in NUMBER,

Line 64: select nvl(IBE_ACTIVE_QUOTES_ALL_S1.nextval,0) into l_active_quote_id

60: ELSE
61: l_org_id := x_org_id;
62: END IF;
63:
64: select nvl(IBE_ACTIVE_QUOTES_ALL_S1.nextval,0) into l_active_quote_id
65: from dual;
66:
67: insert into IBE_ACTIVE_QUOTES_ALL (
68: ACTIVE_QUOTE_ID,

Line 67: insert into IBE_ACTIVE_QUOTES_ALL (

63:
64: select nvl(IBE_ACTIVE_QUOTES_ALL_S1.nextval,0) into l_active_quote_id
65: from dual;
66:
67: insert into IBE_ACTIVE_QUOTES_ALL (
68: ACTIVE_QUOTE_ID,
69: /*PROGRAM_APPLICATION_ID,
70: PROGRAM_ID,
71: PROGRAM_UPDATE_DATE,*/

Line 129: update IBE_ACTIVE_QUOTES_ALL set

125: --$$GET THE ORG_ID HERE$$
126: if (X_RECORD_TYPE = 'CART')
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,

Line 145: update IBE_ACTIVE_QUOTES_ALL set

141: AND RECORD_TYPE = X_RECORD_TYPE;
142:
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,

Line 178: delete from IBE_ACTIVE_QUOTES

174: begin
175:
176: IF (X_RECORD_TYPE = 'CART')
177: THEN
178: delete from IBE_ACTIVE_QUOTES
179: where quote_header_id = x_quote_header_id
180: and party_id = x_party_id
181: and cust_account_id = x_cust_account_id
182: and record_type = x_record_type;

Line 186: delete from IBE_ACTIVE_QUOTES

182: and record_type = x_record_type;
183:
184: ELSIF (X_RECORD_TYPE = 'ORDER')
185: THEN
186: delete from IBE_ACTIVE_QUOTES
187: where order_header_id = x_order_header_id
188: and party_id = x_party_id
189: and cust_account_id = x_cust_account_id
190: and record_type = x_record_type

Line 200: end IBE_ACTIVE_QUOTES_ALL_PKG;

196: end if;
197:
198: end DELETE_ROW;
199:
200: end IBE_ACTIVE_QUOTES_ALL_PKG;