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 1644: FROM FND_LOOKUPS fndl

1640: if (l_emp_cost_center = l_doc_cost_center) then
1641:
1642: SELECT fndl.meaning
1643: INTO l_yes
1644: FROM FND_LOOKUPS fndl
1645: WHERE fndl.LOOKUP_TYPE = C_YES_NO
1646: AND fndl.LOOKUP_CODE = C_Y;
1647:
1648: WF_ENGINE.SetItemAttrText(p_item_type,

Line 1656: FROM FND_LOOKUPS fndl

1652: else
1653:
1654: SELECT fndl.meaning
1655: INTO l_no
1656: FROM FND_LOOKUPS fndl
1657: WHERE fndl.LOOKUP_TYPE = C_YES_NO
1658: AND fndl.LOOKUP_CODE = C_N;
1659:
1660: WF_ENGINE.SetItemAttrText(p_item_type,

Line 2522: FROM FND_LOOKUPS fndl

2518: if (l_is_projects_report) then
2519:
2520: SELECT fndl.meaning
2521: INTO l_yes
2522: FROM FND_LOOKUPS fndl
2523: WHERE fndl.LOOKUP_TYPE = C_YES_NO
2524: AND fndl.LOOKUP_CODE = C_Y;
2525:
2526: WF_ENGINE.SetItemAttrText(p_item_type,

Line 2533: FROM FND_LOOKUPS fndl

2529: l_yes);
2530: else
2531: SELECT fndl.meaning
2532: INTO l_no
2533: FROM FND_LOOKUPS fndl
2534: WHERE fndl.LOOKUP_TYPE = C_YES_NO
2535: AND fndl.LOOKUP_CODE = C_N;
2536:
2537: WF_ENGINE.SetItemAttrText(p_item_type,

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

17221: BEGIN
17222:
17223: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start IsExpAccountsUpdated');
17224:
17225: select decode(nvl(preparer_modified_flag, 'N'), 'Y', AP_WEB_FND_LOOKUPS_PKG.getYesNoMeaning('Y'), null)
17226: into l_ExpAccountsUpdated
17227: from ap_exp_report_dists
17228: where report_line_id = p_report_line_id
17229: and rownum = 1;