APPS.AP_WEB_EXPENSE_WF dependencies on FND_LOOKUPS

Line 108: C_YES_NO FND_LOOKUPS.LOOKUP_TYPE%type := 'YES_NO';

104: SWMILES_TO_KILOMETERS CONSTANT NUMBER := 10.0;
105: C_THRESHOLD_TOLERANCE CONSTANT NUMBER := 1;
106:
107: -- Constants for YES_NO lookup
108: C_YES_NO FND_LOOKUPS.LOOKUP_TYPE%type := 'YES_NO';
109: C_Y FND_LOOKUPS.LOOKUP_CODE%type := 'Y';
110: C_N FND_LOOKUPS.LOOKUP_CODE%type := 'N';
111:
112: -- Constants for notification type

Line 109: C_Y FND_LOOKUPS.LOOKUP_CODE%type := 'Y';

105: C_THRESHOLD_TOLERANCE CONSTANT NUMBER := 1;
106:
107: -- Constants for YES_NO lookup
108: C_YES_NO FND_LOOKUPS.LOOKUP_TYPE%type := 'YES_NO';
109: C_Y FND_LOOKUPS.LOOKUP_CODE%type := 'Y';
110: C_N FND_LOOKUPS.LOOKUP_CODE%type := 'N';
111:
112: -- Constants for notification type
113: C_EMP CONSTANT VARCHAR2(3) := 'EMP';

Line 110: C_N FND_LOOKUPS.LOOKUP_CODE%type := 'N';

106:
107: -- Constants for YES_NO lookup
108: C_YES_NO FND_LOOKUPS.LOOKUP_TYPE%type := 'YES_NO';
109: C_Y FND_LOOKUPS.LOOKUP_CODE%type := 'Y';
110: C_N FND_LOOKUPS.LOOKUP_CODE%type := 'N';
111:
112: -- Constants for notification type
113: C_EMP CONSTANT VARCHAR2(3) := 'EMP';
114: C_OTHER CONSTANT VARCHAR2(5) := 'OTHER';

Line 1627: FROM FND_LOOKUPS fndl

1623: if (l_emp_cost_center = l_doc_cost_center) then
1624:
1625: SELECT fndl.meaning
1626: INTO l_yes
1627: FROM FND_LOOKUPS fndl
1628: WHERE fndl.LOOKUP_TYPE = C_YES_NO
1629: AND fndl.LOOKUP_CODE = C_Y;
1630:
1631: WF_ENGINE.SetItemAttrText(p_item_type,

Line 1639: FROM FND_LOOKUPS fndl

1635: else
1636:
1637: SELECT fndl.meaning
1638: INTO l_no
1639: FROM FND_LOOKUPS fndl
1640: WHERE fndl.LOOKUP_TYPE = C_YES_NO
1641: AND fndl.LOOKUP_CODE = C_N;
1642:
1643: WF_ENGINE.SetItemAttrText(p_item_type,

Line 2505: FROM FND_LOOKUPS fndl

2501: if (l_is_projects_report) then
2502:
2503: SELECT fndl.meaning
2504: INTO l_yes
2505: FROM FND_LOOKUPS fndl
2506: WHERE fndl.LOOKUP_TYPE = C_YES_NO
2507: AND fndl.LOOKUP_CODE = C_Y;
2508:
2509: WF_ENGINE.SetItemAttrText(p_item_type,

Line 2516: FROM FND_LOOKUPS fndl

2512: l_yes);
2513: else
2514: SELECT fndl.meaning
2515: INTO l_no
2516: FROM FND_LOOKUPS fndl
2517: WHERE fndl.LOOKUP_TYPE = C_YES_NO
2518: AND fndl.LOOKUP_CODE = C_N;
2519:
2520: WF_ENGINE.SetItemAttrText(p_item_type,

Line 16126: select decode(nvl(preparer_modified_flag, 'N'), 'Y', AP_WEB_FND_LOOKUPS_PKG.getYesNoMeaning('Y'), null)

16122: BEGIN
16123:
16124: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start IsExpAccountsUpdated');
16125:
16126: select decode(nvl(preparer_modified_flag, 'N'), 'Y', AP_WEB_FND_LOOKUPS_PKG.getYesNoMeaning('Y'), null)
16127: into l_ExpAccountsUpdated
16128: from ap_exp_report_dists
16129: where report_line_id = p_report_line_id
16130: and rownum = 1;