eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_DB_EXPRPT_PKG

Line 303: l_ResubmitReport := AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(

299: p_employee_id,
300: FND_PROFILE.VALUE('USER_ID'),
301: l_employee_project_enabled);
302:
303: l_ResubmitReport := AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(
304: p_workflow_flag);
305:
306: -- Grants Integration
307: IF (GMS_OIE_INT_PKG.IsGrantsEnabled()) THEN

Line 447: if p_workflow_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW then

443: -------------------------------------------------
444: l_debug_info := 'Update Withdraw Message';
445: -------------------------------------------------
446: --ER 1552747 - withdraw expense report
447: if p_workflow_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW then
448: FND_MESSAGE.SET_NAME('SQLAP','OIE_WITHDRAW_WARNING');
449: l_mess := FND_MESSAGE.GET;
450: WF_ENGINE.SetItemAttrText(l_item_type,
451: l_item_key,

Line 578: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(p_report_header_id,l_textValArr(iText))) THEN

574: --------------------------------------------------------------
575: iText := iText + 1;
576: l_textNameArr(iText) := 'PAYMENT_DUE_FROM';
577:
578: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(p_report_header_id,l_textValArr(iText))) THEN
579: l_debug_info := 'Could not set workflow attribute Payment_Due_From';
580: END IF;
581:
582: -------------------------------------------------------------

Line 827: AP_WEB_DB_EXPRPT_PKG.clearAuditReturnReasonInstr(p_report_header_id);

823:
824: ------------------------------------------------------------
825: l_debug_info := 'clear the header/line level return/audit reason/instructions in AERH/AERL';
826: ------------------------------------------------------------
827: AP_WEB_DB_EXPRPT_PKG.clearAuditReturnReasonInstr(p_report_header_id);
828: AP_WEB_DB_EXPLINE_PKG.clearAuditReturnReasonInstr(p_report_header_id);
829:
830: ----------------------------------------------------------
831: l_debug_info := 'clear Item Attribute AUDIT_RETURN_REASON';

Line 919: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

915: l_item_type VARCHAR2(7);
916: l_item_key VARCHAR2(15);
917:
918: l_currency VARCHAR2(50);
919: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
920: l_num_lines NUMBER := 0;
921:
922: l_n_org_id Number;
923:

Line 1179: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

1175: when others then
1176: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
1177: -- ORG_ID item attribute doesn't exist, need to add it
1178: WF_ENGINE.AddItemAttr(l_item_type, l_item_key, 'ORG_ID');
1179: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(
1180: to_number(l_item_key),
1181: l_n_org_id) <> TRUE ) THEN
1182: l_n_org_id := NULL;
1183: END IF;

Line 1205: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(to_number(l_item_key), l_n_org_id) <> TRUE ) THEN

1201: else
1202: -- Report was submitted before org_id being added, hence org_id
1203: -- item attributes hasn't been set yet. Need to get it from
1204: -- report header
1205: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(to_number(l_item_key), l_n_org_id) <> TRUE ) THEN
1206: l_n_org_id := NULL;
1207: END IF;
1208:
1209: IF (l_n_org_id is not null) then

Line 1515: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

1511: p_actid IN NUMBER,
1512: p_funmode IN VARCHAR2,
1513: p_result OUT NOCOPY VARCHAR2) IS
1514: ------------------------------------------------------------------------
1515: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
1516:
1517: l_emp_cost_center VARCHAR2(240);
1518: l_doc_cost_center VARCHAR2(240);
1519:

Line 1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

1854: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1862: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;

Line 1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;

1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1862: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1863: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;

Line 1868: l_employee_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;

1864: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;
1865: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1866: l_id_flex_structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE;
1867:
1868: l_employee_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;
1869: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;

Line 1869: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;

1865: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1866: l_id_flex_structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE;
1867:
1868: l_employee_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;
1869: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

Line 1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;

1868: l_employee_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;
1869: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1874: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1875: exchange_rate_exception EXCEPTION;
1876: l_available_prepays NUMBER;

Line 1906: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;

1902: V_UserName VARCHAR2(30);
1903: V_VendorID AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
1904: V_IsSessionProjectEnabled VARCHAR2(1);
1905:
1906: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;
1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;
1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;

Line 1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;

1903: V_VendorID AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
1904: V_IsSessionProjectEnabled VARCHAR2(1);
1905:
1906: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;
1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;
1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;

Line 1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;

1904: V_IsSessionProjectEnabled VARCHAR2(1);
1905:
1906: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;
1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;
1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;

Line 1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;

1905:
1906: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;
1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;
1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;

Line 1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;

1906: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;
1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;
1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;

Line 1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;

1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;
1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;
1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;

Line 1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;

1908: V_HeaderAttributeCategory AP_WEB_DB_EXPRPT_PKG.expHdr_attrCategory;
1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;

Line 1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;

1909: V_HeaderAttribute1 AP_WEB_DB_EXPRPT_PKG.expHdr_attr1;
1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;

Line 1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;

1910: V_HeaderAttribute2 AP_WEB_DB_EXPRPT_PKG.expHdr_attr2;
1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;

Line 1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;

1911: V_HeaderAttribute3 AP_WEB_DB_EXPRPT_PKG.expHdr_attr3;
1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;

Line 1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;

1912: V_HeaderAttribute4 AP_WEB_DB_EXPRPT_PKG.expHdr_attr4;
1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;

Line 1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;

1913: V_HeaderAttribute5 AP_WEB_DB_EXPRPT_PKG.expHdr_attr5;
1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;
1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;

Line 1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;

1914: V_HeaderAttribute6 AP_WEB_DB_EXPRPT_PKG.expHdr_attr6;
1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;
1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;
1922: V_HeaderAttribute14 AP_WEB_DB_EXPRPT_PKG.expHdr_attr14;

Line 1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;

1915: V_HeaderAttribute7 AP_WEB_DB_EXPRPT_PKG.expHdr_attr7;
1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;
1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;
1922: V_HeaderAttribute14 AP_WEB_DB_EXPRPT_PKG.expHdr_attr14;
1923: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;

Line 1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;

1916: V_HeaderAttribute8 AP_WEB_DB_EXPRPT_PKG.expHdr_attr8;
1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;
1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;
1922: V_HeaderAttribute14 AP_WEB_DB_EXPRPT_PKG.expHdr_attr14;
1923: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;
1924:

Line 1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;

1917: V_HeaderAttribute9 AP_WEB_DB_EXPRPT_PKG.expHdr_attr9;
1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;
1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;
1922: V_HeaderAttribute14 AP_WEB_DB_EXPRPT_PKG.expHdr_attr14;
1923: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;
1924:
1925: ExpenseReportLinesCursor AP_WEB_DB_EXPLINE_PKG.XpenseLineAcctCursor;

Line 1922: V_HeaderAttribute14 AP_WEB_DB_EXPRPT_PKG.expHdr_attr14;

1918: V_HeaderAttribute10 AP_WEB_DB_EXPRPT_PKG.expHdr_attr10;
1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;
1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;
1922: V_HeaderAttribute14 AP_WEB_DB_EXPRPT_PKG.expHdr_attr14;
1923: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;
1924:
1925: ExpenseReportLinesCursor AP_WEB_DB_EXPLINE_PKG.XpenseLineAcctCursor;
1926: l_dist_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;

Line 1923: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;

1919: V_HeaderAttribute11 AP_WEB_DB_EXPRPT_PKG.expHdr_attr11;
1920: V_HeaderAttribute12 AP_WEB_DB_EXPRPT_PKG.expHdr_attr12;
1921: V_HeaderAttribute13 AP_WEB_DB_EXPRPT_PKG.expHdr_attr13;
1922: V_HeaderAttribute14 AP_WEB_DB_EXPRPT_PKG.expHdr_attr14;
1923: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;
1924:
1925: ExpenseReportLinesCursor AP_WEB_DB_EXPLINE_PKG.XpenseLineAcctCursor;
1926: l_dist_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1927: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;

Line 2008: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetAccountingInfo(

2004:
2005: --------------------------------------------------------------------
2006: l_debug_info := 'Retrieve values from system parameters, employees';
2007: --------------------------------------------------------------------
2008: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetAccountingInfo(
2009: p_report_header_id,
2010: l_sys_apply_advances_default,
2011: l_sys_allow_awt_flag,
2012: l_sys_default_xrate_type,

Line 2043: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetChartOfAccountsID(

2039:
2040: -----------------------------------------------------
2041: l_debug_info := 'Get the Employee Chart of Accounts ID';
2042: -----------------------------------------------------
2043: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetChartOfAccountsID(
2044: p_employee_id => l_employee_id,
2045: p_chart_of_accounts_id => l_chart_of_accounts_id)) THEN
2046: NULL;
2047: END IF;

Line 2556: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetDefaultExchRateType(p_report_header_id, l_sys_default_xrate_type)) THEN

2552: ----------------------------------------------
2553: IF ((l_sys_default_xrate_type = 'User') AND
2554: (l_sys_make_rate_mandatory = 'Y')) THEN
2555:
2556: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetDefaultExchRateType(p_report_header_id, l_sys_default_xrate_type)) THEN
2557: NULL;
2558: END IF; /* SetDefaultExchRateType */
2559:
2560: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_USER_EXCH_RATE_REQD');

Line 2604: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetExpenseHeaderInfo(p_report_header_id,

2600:
2601: ---------------------------------------------------
2602: l_debug_info := 'Update ap_expense_report_headers';
2603: ---------------------------------------------------
2604: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetExpenseHeaderInfo(p_report_header_id,
2605: l_exp_check_address_flag,
2606: 'WebExpense',
2607: '', -- clear out potentially-rejected/returned status
2608: l_sys_apply_advances_default,

Line 2825: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

2821: p_actid IN NUMBER,
2822: p_funmode IN VARCHAR2,
2823: p_result OUT NOCOPY VARCHAR2) IS
2824: ----------------------------------------------------------------------
2825: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
2826: l_debug_info VARCHAR2(200);
2827: BEGIN
2828:
2829: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start ManagerApproved');

Line 2844: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlag(l_report_header_id)) THEN

2840:
2841: ----------------------------------------------------------------
2842: l_debug_info := 'Update the Expense Report as Manager Approved';
2843: ----------------------------------------------------------------
2844: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlag(l_report_header_id)) THEN
2845: NULL;
2846: END IF;
2847:
2848: ----------------------------------------------------------

Line 3291: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

3287: p_actid IN NUMBER,
3288: p_funmode IN VARCHAR2,
3289: p_result OUT NOCOPY VARCHAR2) IS
3290: ----------------------------------------------------------------------
3291: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
3292: l_ap_review_status AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;
3293: l_debug_info VARCHAR2(200);
3294:
3295: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;

Line 3292: l_ap_review_status AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;

3288: p_funmode IN VARCHAR2,
3289: p_result OUT NOCOPY VARCHAR2) IS
3290: ----------------------------------------------------------------------
3291: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
3292: l_ap_review_status AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;
3293: l_debug_info VARCHAR2(200);
3294:
3295: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
3296: C_WF_Version NUMBER := 0;

Line 3295: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;

3291: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
3292: l_ap_review_status AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;
3293: l_debug_info VARCHAR2(200);
3294:
3295: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
3296: C_WF_Version NUMBER := 0;
3297: BEGIN
3298:
3299: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start APReviewComplete');

Line 3337: IF (AP_WEB_DB_EXPRPT_PKG.GetExpWorkflowInfo(l_report_header_id,

3333:
3334: -------------------------------------------------
3335: l_debug_info := 'Retrieve The AP Reviewed Flag';
3336: -------------------------------------------------
3337: IF (AP_WEB_DB_EXPRPT_PKG.GetExpWorkflowInfo(l_report_header_id,
3338: l_WorkflowRec)) THEN
3339: l_ap_review_status := nvl(l_WorkflowRec.workflow_flag, 'N');
3340: END IF;
3341:

Line 3347: l_ap_review_status = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED or -- already AP rejected

3343: l_debug_info := 'Check flag to determine if AP Review Complete and
3344: return Y if so, otherwise N';
3345: ------------------------------------------------------------------
3346: IF (l_ap_review_status = 'Y' or
3347: l_ap_review_status = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED or -- already AP rejected
3348: l_ap_review_status = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REQUEST) THEN -- already AP requests more info
3349: -- p_result := wf_engine.eng_null;
3350: -- dtong changed p_result for bug # 839208
3351: p_result := 'COMPLETE:Y';

Line 3348: l_ap_review_status = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REQUEST) THEN -- already AP requests more info

3344: return Y if so, otherwise N';
3345: ------------------------------------------------------------------
3346: IF (l_ap_review_status = 'Y' or
3347: l_ap_review_status = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED or -- already AP rejected
3348: l_ap_review_status = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REQUEST) THEN -- already AP requests more info
3349: -- p_result := wf_engine.eng_null;
3350: -- dtong changed p_result for bug # 839208
3351: p_result := 'COMPLETE:Y';
3352: ELSE

Line 3413: l_exp_report_amount AP_WEB_DB_EXPRPT_PKG.expHdr_total;

3409: p_result OUT NOCOPY VARCHAR2) IS
3410: ----------------------------------------------------------------------
3411: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
3412: l_orig_expe_report_amt NUMBER;
3413: l_exp_report_amount AP_WEB_DB_EXPRPT_PKG.expHdr_total;
3414: l_orig_exp_report_amt NUMBER;
3415: l_expense_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
3416: l_amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
3417: l_adjustment_reason AP_WEB_DB_EXPLINE_PKG.expLines_adjReason;

Line 3428: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCCardCompany;

3424: i INTEGER;
3425: j INTEGER;
3426: l_payment_due VARCHAR2(10) := C_IndividualPay;
3427: l_total NUMBER := 0;
3428: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCCardCompany;
3429: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
3430: C_CreditLineVersion CONSTANT NUMBER := 1;
3431: C_WF_Version NUMBER := 0;
3432:

Line 3429: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;

3425: j INTEGER;
3426: l_payment_due VARCHAR2(10) := C_IndividualPay;
3427: l_total NUMBER := 0;
3428: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCCardCompany;
3429: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
3430: C_CreditLineVersion CONSTANT NUMBER := 1;
3431: C_WF_Version NUMBER := 0;
3432:
3433: /* jrautiai ADJ Fix Start */

Line 3447: l_ExpRec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;

3443: l_policy_emp_amt NUMBER := 0;
3444: l_policy_shortpay_total NUMBER := 0;
3445: /* jrautiai ADJ Fix End */
3446:
3447: l_ExpRec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
3448: l_reimb_currency ap_expense_report_headers_all.payment_currency_code%type;
3449: BEGIN
3450:
3451: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AnyAPAdjustments');

Line 3530: IF (AP_WEB_DB_EXPRPT_PKG.GetReportInfo(l_report_header_id, l_ExpRec)) THEN

3526:
3527: --------------------------------------------------------
3528: l_debug_info := 'Retrieve Current Expense Report Total';
3529: --------------------------------------------------------
3530: IF (AP_WEB_DB_EXPRPT_PKG.GetReportInfo(l_report_header_id, l_ExpRec)) THEN
3531: l_exp_report_amount := l_ExpRec.total;
3532: ELSE
3533: l_exp_report_amount := 0;
3534: END IF;

Line 3564: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(

3560: ----------------------------------------------------------
3561: l_debug_info := 'Update the Headers table with the new Amt
3562: Dues and Total columns';
3563: ----------------------------------------------------------
3564: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(
3565: l_report_header_id,
3566: nvl(l_ccard_amt,0),
3567: nvl(l_emp_amt,0),
3568: l_total)) THEN

Line 3854: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

3850: p_actid IN NUMBER,
3851: p_funmode IN VARCHAR2,
3852: p_result OUT NOCOPY VARCHAR2) IS
3853: ----------------------------------------------------------------------
3854: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
3855: l_payment_due VARCHAR2(10) := C_IndividualPay;
3856: l_debug_info VARCHAR2(200);
3857: C_WF_Version NUMBER := 0;
3858: BEGIN

Line 3898: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(

3894: --SetStatusApproverAndDate, from oie.g expense_status_code is updated
3895: --at the end in SetStatusApproverAndDate
3896:
3897: IF (C_WF_Version >= AP_WEB_EXPENSE_WF.C_OIEJ_Version) THEN
3898: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(
3899: l_report_header_id, NULL, NULL)) THEN
3900: NULL;
3901: END IF;
3902: ELSE

Line 3903: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(

3899: l_report_header_id, NULL, NULL)) THEN
3900: NULL;
3901: END IF;
3902: ELSE
3903: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(
3904: l_report_header_id, NULL, 'SelfService')) THEN
3905: NULL;
3906: END IF;
3907: END IF;

Line 4242: PROCEDURE CreateShortPayExpReport(p_orig_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,

4238:
4239: END GetNewShortPayDocumentNum;
4240:
4241: ------------------------------------------------------------------------------
4242: PROCEDURE CreateShortPayExpReport(p_orig_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4243: p_new_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4244: p_new_expense_report_num IN AP_WEB_DB_EXPRPT_PKG.expHdr_invNum,
4245: p_new_expense_report_total IN AP_WEB_DB_EXPRPT_PKG.expHdr_total,
4246: p_new_ccard_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany,

Line 4243: p_new_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,

4239: END GetNewShortPayDocumentNum;
4240:
4241: ------------------------------------------------------------------------------
4242: PROCEDURE CreateShortPayExpReport(p_orig_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4243: p_new_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4244: p_new_expense_report_num IN AP_WEB_DB_EXPRPT_PKG.expHdr_invNum,
4245: p_new_expense_report_total IN AP_WEB_DB_EXPRPT_PKG.expHdr_total,
4246: p_new_ccard_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany,
4247: p_new_emp_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee,

Line 4244: p_new_expense_report_num IN AP_WEB_DB_EXPRPT_PKG.expHdr_invNum,

4240:
4241: ------------------------------------------------------------------------------
4242: PROCEDURE CreateShortPayExpReport(p_orig_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4243: p_new_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4244: p_new_expense_report_num IN AP_WEB_DB_EXPRPT_PKG.expHdr_invNum,
4245: p_new_expense_report_total IN AP_WEB_DB_EXPRPT_PKG.expHdr_total,
4246: p_new_ccard_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany,
4247: p_new_emp_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee,
4248: p_shortpay_type IN VARCHAR2)

Line 4245: p_new_expense_report_total IN AP_WEB_DB_EXPRPT_PKG.expHdr_total,

4241: ------------------------------------------------------------------------------
4242: PROCEDURE CreateShortPayExpReport(p_orig_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4243: p_new_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4244: p_new_expense_report_num IN AP_WEB_DB_EXPRPT_PKG.expHdr_invNum,
4245: p_new_expense_report_total IN AP_WEB_DB_EXPRPT_PKG.expHdr_total,
4246: p_new_ccard_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany,
4247: p_new_emp_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee,
4248: p_shortpay_type IN VARCHAR2)
4249: ------------------------------------------------------------------------------

Line 4246: p_new_ccard_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany,

4242: PROCEDURE CreateShortPayExpReport(p_orig_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4243: p_new_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4244: p_new_expense_report_num IN AP_WEB_DB_EXPRPT_PKG.expHdr_invNum,
4245: p_new_expense_report_total IN AP_WEB_DB_EXPRPT_PKG.expHdr_total,
4246: p_new_ccard_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany,
4247: p_new_emp_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee,
4248: p_shortpay_type IN VARCHAR2)
4249: ------------------------------------------------------------------------------
4250: IS

Line 4247: p_new_emp_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee,

4243: p_new_expense_report_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID,
4244: p_new_expense_report_num IN AP_WEB_DB_EXPRPT_PKG.expHdr_invNum,
4245: p_new_expense_report_total IN AP_WEB_DB_EXPRPT_PKG.expHdr_total,
4246: p_new_ccard_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany,
4247: p_new_emp_amt IN AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee,
4248: p_shortpay_type IN VARCHAR2)
4249: ------------------------------------------------------------------------------
4250: IS
4251: l_debug_info VARCHAR2(2000);

Line 4252: l_ExpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;

4248: p_shortpay_type IN VARCHAR2)
4249: ------------------------------------------------------------------------------
4250: IS
4251: l_debug_info VARCHAR2(2000);
4252: l_ExpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
4253:
4254: BEGIN
4255:
4256: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start CreateShortPayExpReport');

Line 4289: IF (NOT AP_WEB_DB_EXPRPT_PKG.InsertReportHeaderLikeExisting(

4285: l_ExpenseRec.source := NULL;
4286: l_ExpenseRec.accts_pay_comb_id := NULL;
4287: l_ExpenseRec.expense_status_code := NULL;
4288:
4289: IF (NOT AP_WEB_DB_EXPRPT_PKG.InsertReportHeaderLikeExisting(
4290: p_orig_expense_report_id, l_ExpenseRec)) THEN
4291: NULL;
4292: END IF;
4293:

Line 4381: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

4377: p_actid IN NUMBER,
4378: p_funmode IN VARCHAR2,
4379: p_result OUT NOCOPY VARCHAR2) IS
4380: ----------------------------------------------------------------------
4381: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4382: l_num_req_receipt_not_verified NUMBER;
4383: l_policy_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

Line 4383: l_policy_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;

4379: p_result OUT NOCOPY VARCHAR2) IS
4380: ----------------------------------------------------------------------
4381: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4382: l_num_req_receipt_not_verified NUMBER;
4383: l_policy_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

Line 4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;

4380: ----------------------------------------------------------------------
4381: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4382: l_num_req_receipt_not_verified NUMBER;
4383: l_policy_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

Line 4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

4381: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4382: l_num_req_receipt_not_verified NUMBER;
4383: l_policy_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

Line 4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

4382: l_num_req_receipt_not_verified NUMBER;
4383: l_policy_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4390: l_payment_due VARCHAR2(10) := C_IndividualPay;

Line 4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

4383: l_policy_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4390: l_payment_due VARCHAR2(10) := C_IndividualPay;
4391: l_count NUMBER;

Line 4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

4384: l_no_receipts_shortpay_total AP_WEB_DB_EXPRPT_PKG.expHdr_total;
4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4390: l_payment_due VARCHAR2(10) := C_IndividualPay;
4391: l_count NUMBER;
4392: l_personal_total NUMBER := 0;

Line 4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

4385: l_policy_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4386: l_no_receipts_shortpay_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
4387: l_policy_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4388: l_no_receipts_shortpay_doc_num AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4390: l_payment_due VARCHAR2(10) := C_IndividualPay;
4391: l_count NUMBER;
4392: l_personal_total NUMBER := 0;
4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

Line 4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

4389: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
4390: l_payment_due VARCHAR2(10) := C_IndividualPay;
4391: l_count NUMBER;
4392: l_personal_total NUMBER := 0;
4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4395: l_policy_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4396: l_no_receipts_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4397: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

Line 4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

4390: l_payment_due VARCHAR2(10) := C_IndividualPay;
4391: l_count NUMBER;
4392: l_personal_total NUMBER := 0;
4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4395: l_policy_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4396: l_no_receipts_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4397: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4398: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;

Line 4395: l_policy_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;

4391: l_count NUMBER;
4392: l_personal_total NUMBER := 0;
4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4395: l_policy_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4396: l_no_receipts_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4397: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4398: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4399: l_currency VARCHAR2(50);

Line 4396: l_no_receipts_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;

4392: l_personal_total NUMBER := 0;
4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4395: l_policy_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4396: l_no_receipts_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4397: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4398: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4399: l_currency VARCHAR2(50);
4400: l_debug_info VARCHAR2(500);

Line 4397: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

4393: l_policy_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4395: l_policy_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4396: l_no_receipts_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4397: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4398: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4399: l_currency VARCHAR2(50);
4400: l_debug_info VARCHAR2(500);
4401:

Line 4398: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;

4394: l_no_receipts_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4395: l_policy_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4396: l_no_receipts_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4397: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4398: l_emp_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4399: l_currency VARCHAR2(50);
4400: l_debug_info VARCHAR2(500);
4401:
4402: l_no_data_found_flag1 BOOLEAN := TRUE;

Line 4404: l_amtDueCCardCompany AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;

4400: l_debug_info VARCHAR2(500);
4401:
4402: l_no_data_found_flag1 BOOLEAN := TRUE;
4403: l_no_data_found_flag2 BOOLEAN := TRUE;
4404: l_amtDueCCardCompany AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4405: l_amtDueEmp AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4406:
4407: /* jrautiai ADJ Fix - Start */
4408: l_total NUMBER := 0;

Line 4405: l_amtDueEmp AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;

4401:
4402: l_no_data_found_flag1 BOOLEAN := TRUE;
4403: l_no_data_found_flag2 BOOLEAN := TRUE;
4404: l_amtDueCCardCompany AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany;
4405: l_amtDueEmp AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueEmployee;
4406:
4407: /* jrautiai ADJ Fix - Start */
4408: l_total NUMBER := 0;
4409: l_policy_count NUMBER := 0;

Line 4475: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetNextExpReportID(l_policy_shortpay_id)) THEN

4471:
4472: -----------------------------------------------------------------
4473: l_debug_info := 'Retrieve Policy ShortPay New Expense Report Id';
4474: -----------------------------------------------------------------
4475: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetNextExpReportID(l_policy_shortpay_id)) THEN
4476: NULL;
4477: END IF;
4478:
4479: l_policy_shortpay_doc_num := l_document_number || '-1';

Line 4506: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(l_policy_shortpay_id,

4502: l_policy_emp_amt:=0;
4503: l_policy_ccard_amt:=0;
4504: l_policy_shortpay_total := 0;
4505: END IF;
4506: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(l_policy_shortpay_id,
4507: l_policy_ccard_amt,
4508: l_policy_emp_amt,
4509: l_policy_shortpay_total)) THEN
4510: NULL;

Line 4539: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetNextExpReportID(l_no_receipts_shortpay_id)) THEN

4535: IF (l_missing_receipt_count > 0) THEN
4536: -----------------------------------------------------------------
4537: l_debug_info := 'Retrieve Policy ShortPay New Expense Report Id';
4538: -----------------------------------------------------------------
4539: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetNextExpReportID(l_no_receipts_shortpay_id)) THEN
4540: l_no_receipts_shortpay_id := NULL;
4541: END IF;
4542:
4543: IF (l_policy_count > 0) THEN

Line 4574: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(l_no_receipts_shortpay_id,

4570: l_no_receipts_emp_amt:=0;
4571: l_no_receipts_ccard_amt:=0;
4572: l_no_receipts_shortpay_total := 0;
4573: END IF;
4574: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(l_no_receipts_shortpay_id,
4575: l_no_receipts_ccard_amt,
4576: l_no_receipts_emp_amt,
4577: l_no_receipts_shortpay_total)) THEN
4578: NULL;

Line 4628: IF (NOT AP_WEB_DB_EXPRPT_PKG.DeleteExpenseReport(l_report_header_id)) THEN

4624: -----------------------------------------
4625: l_debug_info := 'Delete the original expense report if everything
4626: is getting shortpaid';
4627: ----------------------------------------------------------------------
4628: IF (NOT AP_WEB_DB_EXPRPT_PKG.DeleteExpenseReport(l_report_header_id)) THEN
4629: NULL;
4630: END IF;
4631:
4632: ELSE

Line 4649: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(l_report_header_id,

4645: l_amtDueCCardCompany:=0;
4646: l_total := 0;
4647: END IF;
4648:
4649: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetAmtDuesAndTotal(l_report_header_id,
4650: l_amtDueCCardCompany,
4651: l_amtDueEmp,
4652: l_total)) THEN
4653: /* jrautiai ADJ Fix End */

Line 4676: PROCEDURE DeleteExpReportFromAPTables(p_report_header_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID) IS

4672: END SplitExpenseReport;
4673:
4674:
4675:
4676: PROCEDURE DeleteExpReportFromAPTables(p_report_header_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_headerID) IS
4677: l_debug_info VARCHAR2(200);
4678: l_payment_due VARCHAR2(10) := C_IndividualPay;
4679: l_item_type VARCHAR2(100) := 'APEXP';
4680: l_item_key VARCHAR2(100) := to_char(p_report_header_id);

Line 4721: IF (NOT AP_WEB_DB_EXPRPT_PKG.DeleteExpenseReport(p_report_header_id)) THEN

4717:
4718: ----------------------------------------------------
4719: l_debug_info := 'Delete the expense report header';
4720: ----------------------------------------------------
4721: IF (NOT AP_WEB_DB_EXPRPT_PKG.DeleteExpenseReport(p_report_header_id)) THEN
4722: NULL;
4723: END IF;
4724:
4725: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end DeleteExpReportFromAPTables');

Line 4753: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;

4749: I NUMBER;
4750: l_debug_info VARCHAR2(200);
4751: C_WF_VERSION NUMBER := 0;
4752: -- Bug 668037
4753: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
4754:
4755: BEGIN
4756:
4757: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start ResetAttrValues');

Line 4930: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_item_key), l_override_approver_id)) THEN

4926: --
4927: -- Bug 668037
4928: -- Reset approver attributes
4929: --
4930: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_item_key), l_override_approver_id)) THEN
4931: l_override_approver_id := NULL;
4932: END IF;
4933:
4934: IF (l_override_approver_id IS NOT NULL) THEN

Line 5143: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

5139: p_funmode IN VARCHAR2,
5140: p_result OUT NOCOPY VARCHAR2) IS
5141: ----------------------------------------------------------------------
5142: l_debug_info VARCHAR2(200);
5143: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5144: l_payment_due VARCHAR2(10) := C_IndividualPay;
5145: l_AMEEnabled VARCHAR2(1);
5146: l_No VARCHAR2(1) := 'N';
5147: C_WF_Version NUMBER := 0;

Line 5172: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,

5168:
5169: ------------------------------------------------------------
5170: l_debug_info := 'Set reject status in report header';
5171: ------------------------------------------------------------
5172: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,
5173: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
5174: 'NonValidatedWebExpense')) THEN
5175: NULL;
5176: END IF;

Line 5173: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,

5169: ------------------------------------------------------------
5170: l_debug_info := 'Set reject status in report header';
5171: ------------------------------------------------------------
5172: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,
5173: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
5174: 'NonValidatedWebExpense')) THEN
5175: NULL;
5176: END IF;
5177:

Line 5310: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

5306: p_actid IN NUMBER,
5307: p_funmode IN VARCHAR2,
5308: p_result OUT NOCOPY VARCHAR2) IS
5309: ----------------------------------------------------------------------
5310: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5311: l_debug_info VARCHAR2(200);
5312: BEGIN
5313:
5314: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start DeleteExpenseReport');

Line 5592: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

5588: p_actid IN NUMBER,
5589: p_funmode IN VARCHAR2,
5590: p_result OUT NOCOPY VARCHAR2) IS
5591: ----------------------------------------------------------------------
5592: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5593: l_debug_info VARCHAR2(200);
5594: l_No VARCHAR2(1) := 'N';
5595: BEGIN
5596:

Line 5613: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlag2(l_report_header_id)) THEN

5609: --------------------------------------------------------------
5610: l_debug_info := 'Update all expense lines as receipt missing';
5611: --------------------------------------------------------------
5612: -- Bug 884248
5613: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlag2(l_report_header_id)) THEN
5614: NULL;
5615: END IF;
5616:
5617: ----------------------------------------------------------

Line 5762: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

5758: p_funmode IN VARCHAR2,
5759: p_result OUT NOCOPY VARCHAR2)
5760: ------------------------------------------------------------------------------
5761: IS
5762: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5763: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;
5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;

Line 5763: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;

5759: p_result OUT NOCOPY VARCHAR2)
5760: ------------------------------------------------------------------------------
5761: IS
5762: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5763: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;
5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;

Line 5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

5760: ------------------------------------------------------------------------------
5761: IS
5762: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5763: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;
5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;

Line 5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

5761: IS
5762: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5763: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;
5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;

Line 5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;

5762: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5763: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;
5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
5770: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;

Line 5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;

5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
5770: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
5771: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;
5772: l_debug_info VARCHAR2(2000);
5773: l_ccard_exists BOOLEAN := TRUE;

Line 5770: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;

5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
5770: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
5771: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;
5772: l_debug_info VARCHAR2(2000);
5773: l_ccard_exists BOOLEAN := TRUE;
5774: l_report_submitted_date DATE;

Line 5771: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;

5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
5770: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
5771: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;
5772: l_debug_info VARCHAR2(2000);
5773: l_ccard_exists BOOLEAN := TRUE;
5774: l_report_submitted_date DATE;
5775: l_org_id NUMBER;

Line 5800: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetNextExpReportID(l_new_report_id) ) THEN

5796:
5797: -----------------------------------------------------------------
5798: l_debug_info := 'Retrieve Credit Card New Expense Report Id';
5799: -----------------------------------------------------------------
5800: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetNextExpReportID(l_new_report_id) ) THEN
5801: l_new_report_id := NULL;
5802: END IF;
5803:
5804:

Line 5809: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpReportInfo(l_report_header_id,

5805: -------------------------------------------------------------------
5806: l_debug_info := 'Obtain the card number and the full name and the
5807: vendor information for the new expense report';
5808: --------------------------------------------------------------------
5809: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpReportInfo(l_report_header_id,
5810: l_description, l_ccard_amt, l_total)) THEN
5811: l_description := NULL;
5812: l_total := 0;
5813: l_ccard_amt := 0;

Line 5911: IF (NOT AP_WEB_DB_EXPRPT_PKG.InsertReportHeaderLikeExisting(

5907: END IF;
5908:
5909: l_XpenseRec.expense_status_code := l_expense_status_code;
5910:
5911: IF (NOT AP_WEB_DB_EXPRPT_PKG.InsertReportHeaderLikeExisting(
5912: l_report_header_id, l_XpenseRec)) THEN
5913: NULL;
5914: END IF;
5915:

Line 6190: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

6186: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
6187: -- ORG_ID item attribute doesn't exist, need to add it
6188: wf_engine.AddItemAttr(p_item_type, p_item_key, 'ORG_ID');
6189: -- get the org_id from header for old reports
6190: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(
6191: to_number(p_item_key),
6192: l_n_org_id) <> TRUE ) THEN
6193: l_n_org_id := NULL;
6194: END IF;

Line 6710: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;

6706: l_document_number VARCHAR2(50);
6707: l_orig_expense_report_num VARCHAR2(50);
6708: l_emp_cost_center VARCHAR2(240);
6709: l_doc_cost_center VARCHAR2(240);
6710: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
6711: l_approver_name wf_users.name%type;
6712: l_approver_display_name wf_users.display_name%type;
6713: l_total NUMBER;
6714: l_credit_total NUMBER;

Line 6859: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

6855: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
6856: -- ORG_ID item attribute doesn't exist, need to add it
6857: wf_engine.AddItemAttr(p_item_type, p_item_key, 'ORG_ID');
6858: -- get the org_id from header for old reports
6859: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(
6860: to_number(p_item_key),
6861: l_n_org_id) <> TRUE ) THEN
6862: l_n_org_id := NULL;
6863: END IF;

Line 7182: IF (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(l_item_key),

7178: 'EXPENSE_DETAILS',
7179: l_url);
7180:
7181:
7182: IF (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(l_item_key),
7183: l_override_approver_id)) THEN
7184:
7185: WF_DIRECTORY.GetUserName('PER',
7186: l_override_approver_id,

Line 7632: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

7628: p_manager_target IN VARCHAR2) IS
7629: --------------------------------------------------------
7630: l_manager_name wf_users.name%type;
7631: l_manager_display_name wf_users.display_name%type;
7632: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
7633: l_debug_info VARCHAR2(200);
7634: BEGIN
7635:
7636: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start SetPersonAs');

Line 8596: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

8592: p_actid IN NUMBER,
8593: p_funmode IN VARCHAR2,
8594: p_result OUT NOCOPY VARCHAR2) IS
8595: ---------------------------------------------------------
8596: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
8597: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
8598: l_debug_info VARCHAR2(200);
8599: l_rejection_reason Wf_Item_Attribute_Values.TEXT_VALUE%TYPE := NULL;
8600: BEGIN

Line 8597: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;

8593: p_funmode IN VARCHAR2,
8594: p_result OUT NOCOPY VARCHAR2) IS
8595: ---------------------------------------------------------
8596: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
8597: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
8598: l_debug_info VARCHAR2(200);
8599: l_rejection_reason Wf_Item_Attribute_Values.TEXT_VALUE%TYPE := NULL;
8600: BEGIN
8601:

Line 8632: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpWorkflowInfo(l_report_header_id,

8628: END IF;
8629:
8630:
8631:
8632: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpWorkflowInfo(l_report_header_id,
8633: l_WorkflowRec)) THEN
8634: l_WorkflowRec.workflow_flag := NULL;
8635: END IF;
8636:

Line 8889: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

8885: p_actid IN NUMBER,
8886: p_funmode IN VARCHAR2,
8887: p_result OUT NOCOPY VARCHAR2) IS
8888: ----------------------------------------------------------------------
8889: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
8890: l_debug_info VARCHAR2(200);
8891: BEGIN
8892:
8893: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start DeleteShortPayExpReport');

Line 9389: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

9385: when others then
9386: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
9387: -- ORG_ID item attribute doesn't exist, need to add it
9388: WF_ENGINE.AddItemAttr(l_itemtype, l_itemkey, 'ORG_ID');
9389: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(
9390: to_number(l_itemkey),
9391: l_n_org_id) <> TRUE ) THEN
9392: l_n_org_id := NULL;
9393: END IF;

Line 9415: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

9411: else
9412: -- Report was submitted before org_id being added, hence org_id
9413: -- item attributes hasn't been set yet. Need to get it from
9414: -- report header
9415: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(
9416: to_number(l_itemkey),
9417: l_n_org_id) <> TRUE ) THEN
9418: l_n_org_id := NULL;
9419: END IF;

Line 9633: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

9629: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
9630: -- ORG_ID item attribute doesn't exist, need to add it
9631: wf_engine.AddItemAttr(p_s_item_type, p_s_item_key, 'ORG_ID');
9632: -- get the org_id from header for old reports
9633: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(
9634: to_number(p_s_item_key),
9635: l_n_org_id) <> TRUE ) THEN
9636: l_n_org_id := NULL;
9637: END IF;

Line 9751: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

9747: ----------------------------------------------------------------------
9748:
9749: l_debug_info VARCHAR2(1000);
9750:
9751: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
9752: l_entered_by NUMBER := fnd_global.user_id;
9753: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9754:
9755: l_orig_language_code ap_expense_params.note_language_code%type := null;

Line 9882: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

9878: l_forwardee AME_UTIL.approverRecord2;
9879: l_approver_id NUMBER;
9880: l_approver_name varchar2(240);
9881:
9882: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
9883: l_entered_by NUMBER := fnd_global.user_id;
9884: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9885:
9886: l_orig_language_code ap_expense_params.note_language_code%type := null;

Line 10323: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

10319: p_funmode IN VARCHAR2,
10320: p_result OUT NOCOPY VARCHAR2) IS
10321: ----------------------------------------------------------------------
10322: l_debug_info VARCHAR2(200);
10323: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
10324: l_payment_due VARCHAR2(10) := C_IndividualPay;
10325: l_No VARCHAR2(1) := 'N';
10326: l_AMEEnabled VARCHAR2(1);
10327: C_WF_Version NUMBER := 0;

Line 10371: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,

10367:
10368: ------------------------------------------------------------
10369: l_debug_info := 'Set Returned status in report header';
10370: ------------------------------------------------------------
10371: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,
10372: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
10373: 'NonValidatedWebExpense')) THEN
10374: NULL;
10375: END IF;

Line 10372: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,

10368: ------------------------------------------------------------
10369: l_debug_info := 'Set Returned status in report header';
10370: ------------------------------------------------------------
10371: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,
10372: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
10373: 'NonValidatedWebExpense')) THEN
10374: NULL;
10375: END IF;
10376:

Line 10890: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

10886: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
10887: IS
10888: l_itemkey wf_items.item_key%TYPE;
10889: l_itemtype wf_items.item_type%TYPE := 'APEXP';
10890: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
10891: l_doc_cctr VARCHAR2(2000);
10892: l_preparer_name VARCHAR2(2000);
10893: l_employee_name VARCHAR2(2000);
10894: l_purpose VARCHAR2(2400);

Line 11009: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(p_rep_header_id,

11005: transactionTypeIn => l_itemtype);
11006: end if;
11007:
11008: l_debug_info := 'Set withdraw status in report header';
11009: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(p_rep_header_id,
11010: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW,
11011: 'NonValidatedWebExpense')) THEN
11012: NULL;
11013: END IF;

Line 11010: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW,

11006: end if;
11007:
11008: l_debug_info := 'Set withdraw status in report header';
11009: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(p_rep_header_id,
11010: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW,
11011: 'NonValidatedWebExpense')) THEN
11012: NULL;
11013: END IF;
11014:

Line 11406: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

11402: when others then
11403: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
11404: -- ORG_ID item attribute doesn't exist, need to add it
11405: WF_ENGINE.AddItemAttr(l_itemtype, l_itemkey, 'ORG_ID');
11406: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(
11407: to_number(l_itemkey),
11408: l_n_org_id) <> TRUE ) THEN
11409: l_n_org_id := NULL;
11410: END IF;

Line 11432: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(to_number(l_itemkey), l_n_org_id) <> TRUE ) THEN

11428: else
11429: -- Report was submitted before org_id being added, hence org_id
11430: -- item attributes hasn't been set yet. Need to get it from
11431: -- report header
11432: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(to_number(l_itemkey), l_n_org_id) <> TRUE ) THEN
11433: l_n_org_id := NULL;
11434: END IF;
11435:
11436: IF (l_n_org_id is not null) then

Line 11462: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(to_number(l_itemkey),l_payment)) THEN

11458: ----------------------------------------------------------------
11459: l_debug_info := 'Retrieve Profile Option Payment Due From';
11460: ----------------------------------------------------------------
11461:
11462: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(to_number(l_itemkey),l_payment)) THEN
11463: l_debug_info := 'Could not set workflow attribute Payment_Due_From';
11464: END IF;
11465:
11466: IF (l_payment = 'BOTH' and l_num_both_personal_lines > 0) THEN

Line 12076: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(l_report_header_id,l_payment)) THEN

12072:
12073: --------------------------------------------
12074: l_debug_info := 'Check to see if Both Pay scenario';
12075: --------------------------------------------
12076: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(l_report_header_id,l_payment)) THEN
12077: l_debug_info := 'Could not set workflow attribute Payment_Due_From';
12078: END IF;
12079: if (l_show_message = 'N' AND C_BothPay = l_payment) then
12080: --------------------------------------------

Line 13002: l_reimb_curr AP_WEB_DB_EXPRPT_PKG.expHdr_payemntCurrCode;

12998: l_base_min_acct_unit NUMBER;
12999: l_total NUMBER;
13000: l_total_dsp VARCHAR2(50);
13001: l_bHeaderUpdated BOOLEAN := FALSE;
13002: l_reimb_curr AP_WEB_DB_EXPRPT_PKG.expHdr_payemntCurrCode;
13003: l_over_threshold_distance NUMBER := 0;
13004: l_sh_distance_thresholds_flag VARCHAR2(1);
13005:
13006: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;

Line 13413: IF (NOT AP_WEB_DB_EXPRPT_PKG.UpdateHeaderTotal(l_report_header_id)) THEN

13409: -----------------------------------------------------------------------
13410: l_debug_info := 'update display_total item attribute if ap_expense_report_headers has been updated';
13411: -----------------------------------------------------------------------
13412: IF (l_bHeaderUpdated = TRUE) THEN
13413: IF (NOT AP_WEB_DB_EXPRPT_PKG.UpdateHeaderTotal(l_report_header_id)) THEN
13414: NULL;
13415: END IF;
13416:
13417: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetHeaderTotal(l_report_header_id,

Line 13417: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetHeaderTotal(l_report_header_id,

13413: IF (NOT AP_WEB_DB_EXPRPT_PKG.UpdateHeaderTotal(l_report_header_id)) THEN
13414: NULL;
13415: END IF;
13416:
13417: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetHeaderTotal(l_report_header_id,
13418: l_total)) THEN
13419: NULL;
13420: END IF;
13421:

Line 13422: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReimbCurr(l_report_header_id,

13418: l_total)) THEN
13419: NULL;
13420: END IF;
13421:
13422: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReimbCurr(l_report_header_id,
13423: l_reimb_curr)) THEN
13424:
13425: NULL;
13426: END IF;

Line 13455: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

13451: p_result OUT NOCOPY VARCHAR2) IS
13452: -------------------------------------------------------------------------------
13453: l_debug_info VARCHAR2(200);
13454: l_violations_count NUMBER:=0;
13455: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
13456: BEGIN
13457:
13458:
13459: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start hasCompanyViolations');

Line 13638: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

13634: BETWEEN TRUNC(NVL(rsa.START_DATE,SYSDATE))
13635: AND TRUNC(NVL(rsa.END_DATE,SYSDATE));
13636:
13637: l_debug_info VARCHAR2(200);
13638: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
13639: audit_rec audit_cur%ROWTYPE;
13640: rule_rec rule_cur%ROWTYPE;
13641: BEGIN
13642:

Line 13958: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

13954: p_result OUT NOCOPY VARCHAR2) IS
13955: ------------------------------------------------------------------------
13956: l_debug_info VARCHAR2(2000);
13957: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
13958: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
13959: l_preparer_name VARCHAR2(2000);
13960: BEGIN
13961:
13962: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start SetProvideMissingInfo');

Line 14051: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

14047: p_actid IN NUMBER,
14048: p_funmode IN VARCHAR2,
14049: p_result OUT NOCOPY VARCHAR2) IS
14050: ----------------------------------------------------------------------
14051: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14052: l_workflow_approved_flag AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;
14053:
14054: l_return_reason VARCHAR2(80);
14055: l_return_instruction Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 14052: l_workflow_approved_flag AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;

14048: p_funmode IN VARCHAR2,
14049: p_result OUT NOCOPY VARCHAR2) IS
14050: ----------------------------------------------------------------------
14051: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14052: l_workflow_approved_flag AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;
14053:
14054: l_return_reason VARCHAR2(80);
14055: l_return_instruction Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
14056:

Line 14080: if (not AP_WEB_DB_EXPRPT_PKG.getAuditReturnReasonInstr(l_report_header_id,

14076:
14077: ------------------------------------------------------------
14078: l_debug_info := 'Retrieve Return Reason and Instruction';
14079: ------------------------------------------------------------
14080: if (not AP_WEB_DB_EXPRPT_PKG.getAuditReturnReasonInstr(l_report_header_id,
14081: l_return_reason,
14082: l_return_instruction)) then
14083: l_debug_info := 'Could not retrieve Return Reason and Instruction';
14084: end if;

Line 14118: IF (l_workflow_approved_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED) THEN

14114: INTO l_workflow_approved_flag
14115: FROM AP_EXPENSE_REPORT_HEADERS
14116: WHERE REPORT_HEADER_ID = l_report_header_id;
14117:
14118: IF (l_workflow_approved_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED) THEN
14119: p_result := 'COMPLETE:REJECTED';
14120: ELSIF (l_workflow_approved_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REQUEST) THEN
14121: p_result := 'COMPLETE:REQUEST_MORE_INFO';
14122: ELSE

Line 14120: ELSIF (l_workflow_approved_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REQUEST) THEN

14116: WHERE REPORT_HEADER_ID = l_report_header_id;
14117:
14118: IF (l_workflow_approved_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED) THEN
14119: p_result := 'COMPLETE:REJECTED';
14120: ELSIF (l_workflow_approved_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REQUEST) THEN
14121: p_result := 'COMPLETE:REQUEST_MORE_INFO';
14122: ELSE
14123: p_result := 'COMPLETE:REVIEWED';
14124: END IF;

Line 14155: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

14151: p_actid IN NUMBER,
14152: p_funmode IN VARCHAR2,
14153: p_result OUT NOCOPY VARCHAR2) IS
14154: ----------------------------------------------------------------------
14155: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14156: l_debug_info VARCHAR2(200);
14157: l_manager_approved VARCHAR2(5);
14158: l_workflow_flag VARCHAR2(5);
14159:

Line 14206: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,

14202:
14203: ----------------------------------------------------------------------
14204: l_debug_info := 'Update the Expense Report as Mgr Approved so that it can be auditable';
14205: ----------------------------------------------------------------------
14206: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_report_header_id,
14207: l_workflow_flag, NULL)) THEN
14208: NULL;
14209: END IF;
14210:

Line 14260: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

14256: p_actid IN NUMBER,
14257: p_funmode IN VARCHAR2,
14258: p_result OUT NOCOPY VARCHAR2) IS
14259: ----------------------------------------------------------------------
14260: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14261: l_debug_info VARCHAR2(200);
14262: BEGIN
14263:
14264: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start RemoveFromAuditQueue');

Line 14327: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

14323: p_actid IN NUMBER,
14324: p_funmode IN VARCHAR2,
14325: p_result IN OUT NOCOPY VARCHAR2) IS
14326: ----------------------------------------------------------------------
14327: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14328: l_debug_info VARCHAR2(200);
14329:
14330: l_message_name fnd_new_messages.message_name%type;
14331: l_result_type varchar2(80);

Line 14529: AP_WEB_DB_EXPRPT_PKG.clearAuditReturnReasonInstr(l_report_header_id);

14525: if (l_result_type <> 'WFSTD_APPROVAL') then
14526: ------------------------------------------------------------
14527: l_debug_info := 'clear the header/line level return/audit reason/instructions in AERH/AERL';
14528: ------------------------------------------------------------
14529: AP_WEB_DB_EXPRPT_PKG.clearAuditReturnReasonInstr(l_report_header_id);
14530: AP_WEB_DB_EXPLINE_PKG.clearAuditReturnReasonInstr(l_report_header_id);
14531:
14532: ----------------------------------------------------------
14533: l_debug_info := 'clear Item Attribute AUDIT_RETURN_REASON';