DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_AGING_BUCKETS_PKG

Line 13735: -- This Procedure updates the IEX_DLN_UWQ_SUMMARY table aging columns with values calculated using IEX_AGING_BUCKETS_PKG package.

13731: END;
13732: --End Bug 8707923 27-Jul-2009 barathsr
13733: -- Start PNAVEENK for bug#7662453 on 22-12-2008
13734: -- This procedure will be called whenever "IEX: Populate UWQ Summary Table" cp runs.
13735: -- This Procedure updates the IEX_DLN_UWQ_SUMMARY table aging columns with values calculated using IEX_AGING_BUCKETS_PKG package.
13736: -- The package IEX_AGING_BUCKETS_PKG calculates aging summary on current values respective to PARTY/ACCOUNT/BILLTO.
13737: -- Start PNAVEENK for bug#7662453 on 22-12-2008
13738: PROCEDURE populate_aging_info(p_fmode varchar2, p_from_date date,p_org_id number)--Added for Bug 8707923 27-Jul-2009 barathsr
13739: IS

Line 13736: -- The package IEX_AGING_BUCKETS_PKG calculates aging summary on current values respective to PARTY/ACCOUNT/BILLTO.

13732: --End Bug 8707923 27-Jul-2009 barathsr
13733: -- Start PNAVEENK for bug#7662453 on 22-12-2008
13734: -- This procedure will be called whenever "IEX: Populate UWQ Summary Table" cp runs.
13735: -- This Procedure updates the IEX_DLN_UWQ_SUMMARY table aging columns with values calculated using IEX_AGING_BUCKETS_PKG package.
13736: -- The package IEX_AGING_BUCKETS_PKG calculates aging summary on current values respective to PARTY/ACCOUNT/BILLTO.
13737: -- Start PNAVEENK for bug#7662453 on 22-12-2008
13738: PROCEDURE populate_aging_info(p_fmode varchar2, p_from_date date,p_org_id number)--Added for Bug 8707923 27-Jul-2009 barathsr
13739: IS
13740:

Line 13744: l_bucket_lines_tbl IEX_AGING_BUCKETS_PKG.bucket_Lines_Tbl;

13740:
13741: l_default_bucket varchar2(100);
13742: l_default_bucket_id number;
13743: l_max_fetches NUMBER;
13744: l_bucket_lines_tbl IEX_AGING_BUCKETS_PKG.bucket_Lines_Tbl;
13745:
13746: type l_aging_tbl_type is table of number Index By Binary_Integer;
13747: l_amount1 l_aging_tbl_type;
13748: l_count1 l_aging_tbl_type;

Line 13804: IEX_AGING_BUCKETS_PKG.QUERY_AGING_LINES(p_api_version => 1.0,

13800: mo_global.set_policy_context('S',r_org.org_id);
13801: j := 1;
13802: for r_aging in c_aging_summary(r_org.org_id) loop
13803:
13804: IEX_AGING_BUCKETS_PKG.QUERY_AGING_LINES(p_api_version => 1.0,
13805: p_init_msg_list => 'T',
13806: p_commit => 'F',
13807: p_validation_level => 100,
13808: x_return_status => var1,