eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_ACTIVE_QUOTES_ALL_PKG dependencies on FND_API

Line 31: RAISE FND_API.G_EXC_ERROR;

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

Line 36: IF ((X_PARTY_ID is null OR X_PARTY_ID =FND_API.G_MISS_NUM)

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;

Line 37: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM))

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;

Line 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')

Line 47: if ((X_PARTY_ID is null OR X_PARTY_ID =FND_API.G_MISS_NUM)

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');

Line 48: OR (X_CUST_ACCOUNT_ID is null OR X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM)

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;

Line 49: OR (X_CURRENCY_CODE is null OR X_CURRENCY_CODE = FND_API.G_MISS_CHAR))

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;

Line 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;

Line 58: IF ((x_org_id is null ) or (x_org_id = FND_API.G_MISS_NUM)) THEN

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;

Line 87: DECODE(L_ACTIVE_QUOTE_ID ,FND_API.G_MISS_NUM,NULL,L_ACTIVE_QUOTE_ID),

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

Line 88: /*DECODE(x_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_APPLICATION_ID),

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

Line 89: DECODE(x_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,x_PROGRAM_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),
93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),

Line 90: DECODE(x_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_PROGRAM_UPDATE_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),

Line 91: DECODE(x_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,x_OBJECT_VERSION_NUMBER),

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

Line 92: DECODE(x_CREATED_BY ,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),

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

Line 93: DECODE(x_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),

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

Line 94: DECODE(x_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),

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

Line 95: DECODE(x_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,x_LAST_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),
99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),

Line 96: DECODE(x_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),

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

Line 97: DECODE(x_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_QUOTE_HEADER_ID),

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

Line 98: DECODE(x_PARTY_ID ,FND_API.G_MISS_NUM,NULL,x_PARTY_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),

Line 99: DECODE(x_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,x_CUST_ACCOUNT_ID),

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

Line 100: DECODE(x_RECORD_TYPE ,FND_API.G_MISS_CHAR,NULL,x_RECORD_TYPE),

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:

Line 101: DECODE(x_ORDER_HEADER_ID ,FND_API.G_MISS_NUM,NULL,x_ORDER_HEADER_ID),

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;

Line 102: DECODE(x_CURRENCY_CODE ,FND_API.G_MISS_CHAR,NULL,x_CURRENCY_CODE),

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:

Line 103: DECODE(l_ORG_ID ,FND_API.G_MISS_NUM,NULL,l_ORG_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:
107: procedure UPDATE_ROW (

Line 131: QUOTE_HEADER_ID = DECODE(X_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_QUOTE_HEADER_ID),

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,

Line 132: ORDER_HEADER_ID = DECODE(X_ORDER_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_ORDER_HEADER_ID),

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,

Line 147: QUOTE_HEADER_ID = DECODE(X_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_QUOTE_HEADER_ID),

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,

Line 148: ORDER_HEADER_ID = DECODE(X_ORDER_HEADER_ID,FND_API.G_MISS_NUM,NULL,X_ORDER_HEADER_ID),

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,