APPS.IBE_ACTIVE_QUOTES_ALL_PKG dependencies on IBE_ACTIVE_QUOTES_ALL

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 200: end IBE_ACTIVE_QUOTES_ALL_PKG;

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