DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_LOOKUPS

Line 120: l_error_message pa_lookups.meaning%TYPE;

116: P_Request_ID in number,
117: P_Invoice_Set_ID in number,
118: P_Error_Message_Code in varchar2) is
119:
120: l_error_message pa_lookups.meaning%TYPE;
121:
122: BEGIN
123:
124: BEGIN

Line 127: FROM PA_Lookups

123:
124: BEGIN
125: SELECT Meaning
126: INTO l_error_message
127: FROM PA_Lookups
128: WHERE Lookup_Type = 'BILLING EXTENSION MESSAGES'
129: AND Lookup_Code = P_Error_Message_Code;
130:
131: EXCEPTION

Line 1633: x_error_message PA_LOOKUPS.DESCRIPTION%TYPE;

1629:
1630: x_trx_type VARCHAR2(10);
1631: x_cm_trx_type VARCHAR2(10);
1632: x_error_status NUMBER;
1633: x_error_message PA_LOOKUPS.DESCRIPTION%TYPE;
1634:
1635: CURSOR overapplication_csr_2 IS
1636: SELECT NVL(typ.allow_overapplication_flag,'N')
1637: FROM ra_cust_trx_types typ