APPS.PA_FIN_PLAN_UTILS dependencies on PA_LOOKUPS

Line 25: (p_lookup_type pa_lookups.lookup_type%TYPE,

21:
22: G_Chg_Reason varchar2(80);
23:
24: function get_lookup_value
25: (p_lookup_type pa_lookups.lookup_type%TYPE,
26: p_lookup_code pa_lookups.lookup_code%TYPE) return VARCHAR2
27: is
28: l_return_value VARCHAR2(80);
29: begin

Line 26: p_lookup_code pa_lookups.lookup_code%TYPE) return VARCHAR2

22: G_Chg_Reason varchar2(80);
23:
24: function get_lookup_value
25: (p_lookup_type pa_lookups.lookup_type%TYPE,
26: p_lookup_code pa_lookups.lookup_code%TYPE) return VARCHAR2
27: is
28: l_return_value VARCHAR2(80);
29: begin
30: select meaning

Line 32: from pa_lookups

28: l_return_value VARCHAR2(80);
29: begin
30: select meaning
31: into l_return_value
32: from pa_lookups
33: where lookup_type = p_lookup_type and
34: lookup_code = p_lookup_code;
35: return l_return_value;
36: exception

Line 6243: FROM pa_lookups

6239: SELECT 'Y'
6240: INTO l_exists
6241: FROM dual
6242: WHERE EXISTS (SELECT 'X'
6243: FROM pa_lookups
6244: WHERE lookup_type='PA_FP_RATE_DATE_TYPE'
6245: AND ((p_project_cost_rate_date_typ IS NULL
6246: OR p_project_cost_rate_date_typ=lookup_code) OR
6247:

Line 6253: FROM pa_lookups

6249: ,p_projfunc_currency_code))
6250: AND rownum=1)
6251:
6252: AND EXISTS (SELECT 'X'
6253: FROM pa_lookups
6254: WHERE lookup_type='PA_FP_RATE_DATE_TYPE'
6255: AND ((p_projfunc_cost_rate_date_typ IS NULL
6256: OR p_projfunc_cost_rate_date_typ=lookup_code) OR
6257:

Line 6262: FROM pa_lookups

6258: p_projfunc_currency_code = p_txn_currency_code )
6259: AND rownum=1)
6260:
6261: AND EXISTS (SELECT 'X'
6262: FROM pa_lookups
6263: WHERE lookup_type='PA_FP_RATE_DATE_TYPE'
6264: AND ((p_project_rev_rate_date_typ IS NULL
6265: OR p_project_rev_rate_date_typ=lookup_code) OR
6266:

Line 6272: FROM pa_lookups

6268: ,p_projfunc_currency_code))
6269: AND rownum=1)
6270:
6271: AND EXISTS (SELECT 'X'
6272: FROM pa_lookups
6273: WHERE lookup_type='PA_FP_RATE_DATE_TYPE'
6274: AND ((p_projfunc_rev_rate_date_typ IS NULL
6275: OR p_projfunc_rev_rate_date_typ=lookup_code) OR
6276:

Line 7547: p_lookup_type IN pa_lookups.lookup_type%TYPE

7543: ==================================================================*/
7544:
7545: PROCEDURE GET_LOOKUP_CODE
7546: (
7547: p_lookup_type IN pa_lookups.lookup_type%TYPE
7548: ,p_lookup_meaning IN pa_lookups.meaning%TYPE
7549: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
7550: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7551: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7548: ,p_lookup_meaning IN pa_lookups.meaning%TYPE

7544:
7545: PROCEDURE GET_LOOKUP_CODE
7546: (
7547: p_lookup_type IN pa_lookups.lookup_type%TYPE
7548: ,p_lookup_meaning IN pa_lookups.meaning%TYPE
7549: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
7550: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7551: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7552: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7549: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

7545: PROCEDURE GET_LOOKUP_CODE
7546: (
7547: p_lookup_type IN pa_lookups.lookup_type%TYPE
7548: ,p_lookup_meaning IN pa_lookups.meaning%TYPE
7549: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
7550: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7551: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7552: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7553: )

Line 7564: from pa_lookups

7560: l_debug_mode VARCHAR2(1);
7561:
7562: cursor lookups_cur is
7563: select lookup_code
7564: from pa_lookups
7565: where lookup_type = p_lookup_type
7566: and meaning = p_lookup_meaning;
7567:
7568: BEGIN

Line 13568: from pa_lookups

13564: If p_time_phased_code <> 'N' Then
13565: If G_Chg_Reason is null Then
13566: select meaning
13567: into G_Chg_Reason
13568: from pa_lookups
13569: where lookup_type = 'BUDGET CHANGE REASON'
13570: and lookup_code = 'MULTIPLE';
13571: End if;
13572: return G_Chg_Reason;

Line 13584: from pa_lookups

13580:
13581: IF l_chg_rsn_code is not null Then
13582: select meaning
13583: into l_chg_rsn
13584: from pa_lookups
13585: where lookup_type = 'BUDGET CHANGE REASON'
13586: and lookup_code = l_chg_rsn_code;
13587: End If;
13588: