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:

Line 1590: FROM pa_implementations imp,

1586: /* Bug 9459594 */
1587: l_intercompany_flag VARCHAR2(1) := 'N';
1588: CURSOR overapplication_csr IS
1589: SELECT NVL(typ.allow_overapplication_flag,'N')
1590: FROM pa_implementations imp,
1591: ra_batch_sources bs,
1592: ra_cust_trx_types typ
1593: WHERE decode(l_intercompany_flag,'N',imp.invoice_batch_source_id,
1594: imp.cc_ic_ar_batch_source_id) = bs.batch_source_id

Line 1607: FROM PA_IMPLEMENTATIONS;

1603: AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE;
1604:
1605: CURSOR get_centralized_flag_csr IS
1606: SELECT DECODE(CENTRALIZED_INVOICING_FLAG, 'N', 'Y', 'N')
1607: FROM PA_IMPLEMENTATIONS;
1608: l_use_inv_org_flag VARCHAR2(1) := 'N';
1609:
1610: CURSOR get_misc_details_csr IS
1611: SELECT IMP.business_group_id,

Line 1616: FROM pa_implementations IMP,

1612: IMP.proj_org_structure_version_id,
1613: BASELANG.language_code,
1614: INV.invoice_date,
1615: PROJ.Carrying_Out_Organization_ID
1616: FROM pa_implementations IMP,
1617: fnd_languages BASELANG,
1618: pa_draft_invoices_all INV,
1619: pa_projects PROJ
1620: WHERE INV.project_id = p_project_id

Line 1624: l_business_group_id pa_implementations.business_group_id%TYPE;

1620: WHERE INV.project_id = p_project_id
1621: AND INV.draft_invoice_num = p_draft_invoice_num
1622: AND BASELANG.installed_flag = 'B'
1623: AND PROJ.project_id = p_project_id;
1624: l_business_group_id pa_implementations.business_group_id%TYPE;
1625: l_org_st_ver_id pa_implementations.proj_org_structure_version_id%TYPE;
1626: l_base_language fnd_languages.language_code%TYPE;
1627: l_invoice_date pa_draft_invoices_all.invoice_date%TYPE;
1628: l_carry_out_org_id pa_projects.Carrying_Out_Organization_ID%TYPE;

Line 1625: l_org_st_ver_id pa_implementations.proj_org_structure_version_id%TYPE;

1621: AND INV.draft_invoice_num = p_draft_invoice_num
1622: AND BASELANG.installed_flag = 'B'
1623: AND PROJ.project_id = p_project_id;
1624: l_business_group_id pa_implementations.business_group_id%TYPE;
1625: l_org_st_ver_id pa_implementations.proj_org_structure_version_id%TYPE;
1626: l_base_language fnd_languages.language_code%TYPE;
1627: l_invoice_date pa_draft_invoices_all.invoice_date%TYPE;
1628: l_carry_out_org_id pa_projects.Carrying_Out_Organization_ID%TYPE;
1629: