APPS.PA_INVOICE_CURRENCY dependencies on PA_LOOKUPS

Line 44: l_error_message pa_lookups.meaning%TYPE;

40: P_Invoice_Set_ID in number,
41: P_Lookup_Type in varchar2,
42: P_Error_Message_Code in varchar2) is
43:
44: l_error_message pa_lookups.meaning%TYPE;
45:
46: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
47:
48: BEGIN

Line 53: FROM PA_Lookups

49:
50: BEGIN
51: SELECT Meaning
52: INTO l_error_message
53: FROM PA_Lookups
54: WHERE Lookup_Type = P_Lookup_Type
55: AND Lookup_Code = P_Error_Message_Code;
56:
57: EXCEPTION

Line 114: l_error_message pa_lookups.meaning%TYPE;

110:
111:
112: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
113:
114: l_error_message pa_lookups.meaning%TYPE;
115:
116: cursor get_std_lines
117: is
118: select dii.rowid row_id, /** Bug 2324299 **/

Line 790: l_error_message pa_lookups.meaning%TYPE;

786: X_Inv_rate_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
787: X_Inv_exchange_rate OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
788: IS
789:
790: l_error_message pa_lookups.meaning%TYPE;
791:
792: Cursor get_info
793: is
794: select Inv_Currency_code,

Line 867: l_error_message pa_lookups.meaning%TYPE;

863: PROCEDURE get_proj_curr_info ( P_Project_Id IN NUMBER,
864: X_Inv_curr_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
865: IS
866:
867: l_error_message pa_lookups.meaning%TYPE;
868:
869: /* Earlier this was referring to project_currency_code because PFC and PC are same.
870: This procedure has to return PFC */
871: cursor get_proj_cur

Line 901: l_error_message pa_lookups.meaning%TYPE;

897: IS
898:
899: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
900:
901: l_error_message pa_lookups.meaning%TYPE;
902:
903: cursor get_orig_amt
904: is
905: select sum(dii.amount),

Line 1485: l_error_message pa_lookups.meaning%TYPE;

1481: IS
1482:
1483: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1484:
1485: l_error_message pa_lookups.meaning%TYPE;
1486:
1487: /* Cursor for Select All Unapproved invoices created in This Run */
1488: /* Bug 5413168: skip invoices without any invoice line. generation_
1489: error_flag not stamped yet for this case until paicnl */

Line 1593: transfer_rejection_reason= (SELECT meaning FROM pa_lookups

1589: PA_MCB_INVOICE_PKG.log_message ('recalculATE: ' || 'Invoice Generation Error is set....'||l_out_status);
1590: END IF;
1591: UPDATE pa_draft_invoices_all
1592: SET generation_error_flag='Y',
1593: transfer_rejection_reason= (SELECT meaning FROM pa_lookups
1594: WHERE lookup_type='INVOICE_CURRENCY'
1595: AND lookup_code=l_out_status)
1596: WHERE project_id=l_Project_ID
1597: AND draft_invoice_num=l_Draft_Invoice_Num;