APPS.PA_INVOICE_ACTIONS dependencies on PA_IMPLEMENTATIONS

Line 178: l_Credit_memo_Reason_flag pa_implementations.credit_Memo_Reason_Flag%TYPE :='N';

174: P_Draft_Invoice_Num in number,
175: P_RA_Invoice_Date in date,
176: P_Credit_Memo_Reason_Code in out NOCOPY varchar2, --File.Sql.39 bug 4440895
177: X_Error_Message_Code out NOCOPY varchar2) is --File.Sql.39 bug 4440895
178: l_Credit_memo_Reason_flag pa_implementations.credit_Memo_Reason_Flag%TYPE :='N';
179: l_credit_memo_exist VARCHAR2(1):='N';
180: l_credit_memo_reason_valid VARCHAR2(1):='N';
181: Cursor Credit_Memo_Reason_Flag is
182: SELECT Credit_Memo_Reason_Flag

Line 183: FROM pa_implementations;

179: l_credit_memo_exist VARCHAR2(1):='N';
180: l_credit_memo_reason_valid VARCHAR2(1):='N';
181: Cursor Credit_Memo_Reason_Flag is
182: SELECT Credit_Memo_Reason_Flag
183: FROM pa_implementations;
184:
185: Cursor Credit_Memo_exist is
186: SELECT 'Y'
187: FROM dual

Line 395: l_entry_method pa_implementations.user_defined_invoice_num_code%TYPE;

391: P_Credit_Memo_Reason_Code in out NOCOPY varchar2, --File.Sql.39 bug 4440895
392: X_RA_Invoice_Num out NOCOPY varchar2, --File.Sql.39 bug 4440895
393: X_Error_Message_Code out NOCOPY varchar2) is --File.Sql.39 bug 4440895
394:
395: l_entry_method pa_implementations.user_defined_invoice_num_code%TYPE;
396: l_num_type pa_implementations.manual_invoice_num_type%TYPE;
397:
398: l_dummy number;
399: l_customer_id number;

Line 396: l_num_type pa_implementations.manual_invoice_num_type%TYPE;

392: X_RA_Invoice_Num out NOCOPY varchar2, --File.Sql.39 bug 4440895
393: X_Error_Message_Code out NOCOPY varchar2) is --File.Sql.39 bug 4440895
394:
395: l_entry_method pa_implementations.user_defined_invoice_num_code%TYPE;
396: l_num_type pa_implementations.manual_invoice_num_type%TYPE;
397:
398: l_dummy number;
399: l_customer_id number;
400: l_err_msg_code varchar2(30);

Line 411: FROM pa_implementations;

407: l_invoice_category pa_draft_invoices_v.invoice_category%TYPE;
408: l_bill_ship_to_customer_id number; /*Added for customer account relation enhancement*/
409: Cursor Imp_Cur is
410: SELECT user_defined_invoice_num_code, manual_invoice_num_type
411: FROM pa_implementations;
412:
413: Cursor Imp_Cur_Inter is
414: SELECT CC_MANUAL_INVOICE_NUM_CODE, CC_MANUAL_INVOICE_NUM_TYPE
415: FROM pa_implementations;

Line 415: FROM pa_implementations;

411: FROM pa_implementations;
412:
413: Cursor Imp_Cur_Inter is
414: SELECT CC_MANUAL_INVOICE_NUM_CODE, CC_MANUAL_INVOICE_NUM_TYPE
415: FROM pa_implementations;
416:
417: /* Added for Bug 2941112 */
418: l_draft_inv_num_cr number;
419: