APPS.JTF_UM_WF_APPROVAL dependencies on FND_API

Line 111: or to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

107: select USER_NAME
108: from FND_USER
109: where USER_ID = userID
110: and (nvl (END_DATE, sysdate + 1) > sysdate
111: or to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
112: -- Bug Fix: 4741111: Added the clause to look for pending users
113:
114: begin
115:

Line 142: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

138: select user_id
139: from FND_USER
140: where USER_NAME = username
141: and (nvl (END_DATE, sysdate + 1) > sysdate OR
142: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
143:
144: begin
145:
146: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getUserID (' ||

Line 1708: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1704: x_flag => l_permission_flag,
1705: x_return_status => l_return_status,
1706: p_user_name => WF_ENGINE.context_text,
1707: p_permission_name => 'JTF_REG_APPROVAL');
1708: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1709: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1710: end if;
1711:
1712: if (l_permission_flag = 0) then

Line 1709: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1705: x_return_status => l_return_status,
1706: p_user_name => WF_ENGINE.context_text,
1707: p_permission_name => 'JTF_REG_APPROVAL');
1708: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1709: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1710: end if;
1711:
1712: if (l_permission_flag = 0) then
1713: -- Not a SYSADMIN, check if the user is a Primary User

Line 1719: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1715: x_flag => l_permission_flag,
1716: x_return_status => l_return_status,
1717: p_user_name => WF_ENGINE.context_text,
1718: p_permission_name => 'JTF_PRIMARY_USER_SUMMARY');
1719: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1720: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1721: end if;
1722: end if;
1723:

Line 1720: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1716: x_return_status => l_return_status,
1717: p_user_name => WF_ENGINE.context_text,
1718: p_permission_name => 'JTF_PRIMARY_USER_SUMMARY');
1719: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1720: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1721: end if;
1722: end if;
1723:
1724: if (l_permission_flag = 0) then

Line 1731: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1727: x_flag => l_permission_flag,
1728: x_return_status => l_return_status,
1729: p_user_name => WF_ENGINE.context_text,
1730: p_permission_name => 'JTF_APPROVER');
1731: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1732: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1733: end if;
1734: end if;
1735:

Line 1732: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1728: x_return_status => l_return_status,
1729: p_user_name => WF_ENGINE.context_text,
1730: p_permission_name => 'JTF_APPROVER');
1731: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1732: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1733: end if;
1734: end if;
1735:
1736: if (l_permission_flag = 0) then

Line 1885: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

1881: select USER_NAME
1882: from FND_USER
1883: where USER_ID = requesterUserID
1884: and (nvl(END_DATE,sysdate) >= sysdate OR
1885: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
1886:
1887: enrollAppRegRow enrollmentApprovalCursor%ROWTYPE;
1888: enrollNoAppRegRow enrollmentNoApprovalCursor%ROWTYPE;
1889:

Line 2176: If to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)

2172: Into userStartDate,userEndDate,requesterUsername,l_customer_id,l_person_party_id
2173: From FND_USER
2174: Where user_id = requesterUserID;
2175:
2176: If to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
2177: And to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
2178: -- release user
2179: FND_USER_PKG.RemovePendingUser(requesterUsername);
2180: End If;

Line 2177: And to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then

2173: From FND_USER
2174: Where user_id = requesterUserID;
2175:
2176: If to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
2177: And to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
2178: -- release user
2179: FND_USER_PKG.RemovePendingUser(requesterUsername);
2180: End If;
2181:

Line 2301: OR to_char(END_DATE) = to_char(FND_API.G_MISS_DATE))

2297: cursor getFNDUserID is
2298: select user_id
2299: from fnd_user
2300: where (nvl (end_date, sysdate + 1) > sysdate
2301: OR to_char(END_DATE) = to_char(FND_API.G_MISS_DATE))
2302:
2303: and user_name = l_approver_username;
2304: --
2305: begin