APPS.JTF_EXCEPTIONS_PKG dependencies on FND_API

Line 46: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

42: OPPORTUNITY_ID,
43: ORG_ID
44: ) VALUES (
45: x_EXCEPTIONS_ID,
46: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
47: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

Line 47: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

43: ORG_ID
44: ) VALUES (
45: x_EXCEPTIONS_ID,
46: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
47: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),

Line 48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

44: ) VALUES (
45: x_EXCEPTIONS_ID,
46: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
47: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),

Line 49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

45: x_EXCEPTIONS_ID,
46: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
47: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),

Line 50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

46: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
47: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),

Line 51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),

47: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),
55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),

Line 52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),

48: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),
55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),
56: decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL,x_OPPORTUNITY_ID),

Line 53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),

49: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),
55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),
56: decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL,x_OPPORTUNITY_ID),
57: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));

Line 54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),

50: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),
55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),
56: decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL,x_OPPORTUNITY_ID),
57: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
58: OPEN C;

Line 55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),

51: decode( x_TERR_ID, FND_API.G_MISS_NUM, NULL,x_TERR_ID),
52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),
55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),
56: decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL,x_OPPORTUNITY_ID),
57: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
58: OPEN C;
59: FETCH C INTO x_Rowid;

Line 56: decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL,x_OPPORTUNITY_ID),

52: decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,x_RESOURCE_ID),
53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),
55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),
56: decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL,x_OPPORTUNITY_ID),
57: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
58: OPEN C;
59: FETCH C INTO x_Rowid;
60: If (C%NOTFOUND) then

Line 57: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));

53: decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,x_CUSTOMER_ID),
54: decode( x_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,x_ADDRESS_ID),
55: decode( x_LEAD_ID, FND_API.G_MISS_NUM, NULL,x_LEAD_ID),
56: decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL,x_OPPORTUNITY_ID),
57: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
58: OPEN C;
59: FETCH C INTO x_Rowid;
60: If (C%NOTFOUND) then
61: CLOSE C;

Line 99: EXCEPTIONS_ID = decode( x_EXCEPTIONS_ID, FND_API.G_MISS_NUM,EXCEPTIONS_ID,x_EXCEPTIONS_ID),

95: ) IS
96: BEGIN
97: Update JTF_EXCEPTIONS
98: SET
99: EXCEPTIONS_ID = decode( x_EXCEPTIONS_ID, FND_API.G_MISS_NUM,EXCEPTIONS_ID,x_EXCEPTIONS_ID),
100: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

Line 100: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

96: BEGIN
97: Update JTF_EXCEPTIONS
98: SET
99: EXCEPTIONS_ID = decode( x_EXCEPTIONS_ID, FND_API.G_MISS_NUM,EXCEPTIONS_ID,x_EXCEPTIONS_ID),
100: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

Line 101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

97: Update JTF_EXCEPTIONS
98: SET
99: EXCEPTIONS_ID = decode( x_EXCEPTIONS_ID, FND_API.G_MISS_NUM,EXCEPTIONS_ID,x_EXCEPTIONS_ID),
100: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),

Line 102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

98: SET
99: EXCEPTIONS_ID = decode( x_EXCEPTIONS_ID, FND_API.G_MISS_NUM,EXCEPTIONS_ID,x_EXCEPTIONS_ID),
100: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),

Line 103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

99: EXCEPTIONS_ID = decode( x_EXCEPTIONS_ID, FND_API.G_MISS_NUM,EXCEPTIONS_ID,x_EXCEPTIONS_ID),
100: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),

Line 104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

100: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),

Line 105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),

101: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),
109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),

Line 106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),

102: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),
109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),
110: OPPORTUNITY_ID = decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM,OPPORTUNITY_ID,x_OPPORTUNITY_ID),

Line 107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),

103: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),
109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),
110: OPPORTUNITY_ID = decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM,OPPORTUNITY_ID,x_OPPORTUNITY_ID),
111: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

Line 108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),

104: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),
109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),
110: OPPORTUNITY_ID = decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM,OPPORTUNITY_ID,x_OPPORTUNITY_ID),
111: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
112: where rowid = X_RowId;

Line 109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),

105: TERR_ID = decode( x_TERR_ID, FND_API.G_MISS_NUM,TERR_ID,x_TERR_ID),
106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),
109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),
110: OPPORTUNITY_ID = decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM,OPPORTUNITY_ID,x_OPPORTUNITY_ID),
111: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
112: where rowid = X_RowId;
113:

Line 110: OPPORTUNITY_ID = decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM,OPPORTUNITY_ID,x_OPPORTUNITY_ID),

106: RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM,RESOURCE_ID,x_RESOURCE_ID),
107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),
109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),
110: OPPORTUNITY_ID = decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM,OPPORTUNITY_ID,x_OPPORTUNITY_ID),
111: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
112: where rowid = X_RowId;
113:
114: If (SQL%NOTFOUND) then

Line 111: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

107: CUSTOMER_ID = decode( x_CUSTOMER_ID, FND_API.G_MISS_NUM,CUSTOMER_ID,x_CUSTOMER_ID),
108: ADDRESS_ID = decode( x_ADDRESS_ID, FND_API.G_MISS_NUM,ADDRESS_ID,x_ADDRESS_ID),
109: LEAD_ID = decode( x_LEAD_ID, FND_API.G_MISS_NUM,LEAD_ID,x_LEAD_ID),
110: OPPORTUNITY_ID = decode( x_OPPORTUNITY_ID, FND_API.G_MISS_NUM,OPPORTUNITY_ID,x_OPPORTUNITY_ID),
111: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
112: where rowid = X_RowId;
113:
114: If (SQL%NOTFOUND) then
115: RAISE NO_DATA_FOUND;