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 1720: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

Line 1721: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1717: x_return_status => l_return_status,
1718: p_user_name => WF_ENGINE.context_text,
1719: p_permission_name => 'JTF_REG_APPROVAL');
1720: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1721: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1722: end if;
1723:
1724: if (l_permission_flag = 0) then
1725: -- Not a SYSADMIN, check if the user is a Primary User

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_PRIMARY_USER_SUMMARY');
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_PRIMARY_USER_SUMMARY');
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 1743: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1739: x_flag => l_permission_flag,
1740: x_return_status => l_return_status,
1741: p_user_name => WF_ENGINE.context_text,
1742: p_permission_name => 'JTF_APPROVER');
1743: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1744: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1745: end if;
1746: end if;
1747:

Line 1744: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1740: x_return_status => l_return_status,
1741: p_user_name => WF_ENGINE.context_text,
1742: p_permission_name => 'JTF_APPROVER');
1743: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1744: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1745: end if;
1746: end if;
1747:
1748: if (l_permission_flag = 0) then

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

1896: select USER_NAME
1897: from FND_USER
1898: where USER_ID = requesterUserID
1899: and (nvl(END_DATE,sysdate) >= sysdate OR
1900: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
1901:
1902: enrollAppRegRow enrollmentApprovalCursor%ROWTYPE;
1903: enrollNoAppRegRow enrollmentNoApprovalCursor%ROWTYPE;
1904:

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

2198: Into userStartDate,userEndDate,requesterUsername,l_customer_id,l_person_party_id
2199: From FND_USER
2200: Where user_id = requesterUserID;
2201:
2202: If to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
2203: And to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
2204: -- release user
2205: FND_USER_PKG.RemovePendingUser(requesterUsername);
2206: End If;

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

2199: From FND_USER
2200: Where user_id = requesterUserID;
2201:
2202: If to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
2203: And to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
2204: -- release user
2205: FND_USER_PKG.RemovePendingUser(requesterUsername);
2206: End If;
2207:

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

2323: cursor getFNDUserID is
2324: select user_id
2325: from fnd_user
2326: where (nvl (end_date, sysdate + 1) > sysdate
2327: OR to_char(END_DATE) = to_char(FND_API.G_MISS_DATE))
2328:
2329: and user_name = l_approver_username;
2330: --
2331: begin