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.PA_FIN_PLAN_UTILS dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 1674: creates a new record in PA_FIN_PLAN_AMOUNT_SETS and returns it.

1670: END Get_Appr_Rev_Plan_Type_Info;
1671:
1672: /*=================================================================================
1673: The procedure gets the amount set id for the combination of in flags if exists or
1674: creates a new record in PA_FIN_PLAN_AMOUNT_SETS and returns it.
1675:
1676: ===================================================================================*/
1677: PROCEDURE GET_OR_CREATE_AMOUNT_SET_ID
1678: (

Line 1679: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,

1675:
1676: ===================================================================================*/
1677: PROCEDURE GET_OR_CREATE_AMOUNT_SET_ID
1678: (
1679: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
1680: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,

Line 1680: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,

1676: ===================================================================================*/
1677: PROCEDURE GET_OR_CREATE_AMOUNT_SET_ID
1678: (
1679: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
1680: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
1684: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,

Line 1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,

1677: PROCEDURE GET_OR_CREATE_AMOUNT_SET_ID
1678: (
1679: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
1680: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
1684: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
1685: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,

Line 1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,

1678: (
1679: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
1680: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
1684: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
1685: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
1686: /* Changes for FP.M, Tracking Bug No - 3354518

Line 1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,

1679: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
1680: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
1684: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
1685: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
1686: /* Changes for FP.M, Tracking Bug No - 3354518
1687: Adding three new IN parameters p_bill_rate_flag,

Line 1684: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,

1680: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
1684: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
1685: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
1686: /* Changes for FP.M, Tracking Bug No - 3354518
1687: Adding three new IN parameters p_bill_rate_flag,
1688: p_cost_rate_flag, p_burden_rate below for

Line 1689: new columns in pa_fin_plan_amount_sets */

1685: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
1686: /* Changes for FP.M, Tracking Bug No - 3354518
1687: Adding three new IN parameters p_bill_rate_flag,
1688: p_cost_rate_flag, p_burden_rate below for
1689: new columns in pa_fin_plan_amount_sets */
1690: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895

Line 1690: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,

1686: /* Changes for FP.M, Tracking Bug No - 3354518
1687: Adding three new IN parameters p_bill_rate_flag,
1688: p_cost_rate_flag, p_burden_rate below for
1689: new columns in pa_fin_plan_amount_sets */
1690: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1694: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895

Line 1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,

1687: Adding three new IN parameters p_bill_rate_flag,
1688: p_cost_rate_flag, p_burden_rate below for
1689: new columns in pa_fin_plan_amount_sets */
1690: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1694: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1695: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895

Line 1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,

1688: p_cost_rate_flag, p_burden_rate below for
1689: new columns in pa_fin_plan_amount_sets */
1690: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1694: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1695: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1696: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895

1689: new columns in pa_fin_plan_amount_sets */
1690: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1694: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1695: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1696: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1697: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1694: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895

1690: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1694: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1695: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1696: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1697: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1698: x_message_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1695: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895

1691: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
1692: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
1693: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1694: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1695: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
1696: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1697: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1698: x_message_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1699: )

Line 1742: columns in pa_fin_plan_amount_sets */

1738: /* Changes for FP.M, Tracking Bug No - 3354518
1739: Adding checks for null value for three new
1740: parameters p_bill_rate_flag,p_cost_rate_flag,
1741: and p_burden_rate below based on the new
1742: columns in pa_fin_plan_amount_sets */
1743:
1744: IF p_raw_cost_flag is null or
1745: p_burdened_cost_flag is null or
1746: p_revenue_flag is null or

Line 1786: columns in pa_fin_plan_amount_sets */

1782: /* Changes for FP.M, Tracking Bug No - 3354518
1783: Adding debug code for three new
1784: parameters p_bill_rate_flag,p_cost_rate_flag,
1785: and p_burden_rate below based on the new
1786: columns in pa_fin_plan_amount_sets */
1787:
1788:
1789: IF P_PA_DEBUG_MODE = 'Y' THEN
1790: pa_debug.g_err_stage := 'bill rate flag is ' || p_bill_rate_flag;

Line 1821: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

1817: BEGIN
1818:
1819: /* Changes for FP.M, Tracking Bug No - 3354518
1820: Appending where clause for three new column bill_rate_flag,
1821: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets
1822: below*/
1823: select fin_plan_amount_set_id
1824: into x_cost_amount_set_id
1825: from pa_fin_plan_amount_sets

Line 1825: from pa_fin_plan_amount_sets

1821: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets
1822: below*/
1823: select fin_plan_amount_set_id
1824: into x_cost_amount_set_id
1825: from pa_fin_plan_amount_sets
1826: where
1827: raw_cost_flag=p_raw_cost_flag and
1828: burdened_cost_flag=p_burdened_cost_flag and
1829: cost_qty_flag=p_cost_qty_flag and

Line 1856: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (

1852: Adding three new column bill_rate_flag,cost_rate_flag,
1853: burden_rate to the insert statment below */
1854:
1855: IF l_status = 'NEW' THEN
1856: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (
1857: FIN_PLAN_AMOUNT_SET_ID,
1858: AMOUNT_SET_TYPE_CODE,
1859: RAW_COST_FLAG,
1860: BURDENED_COST_FLAG,

Line 1883: pa_fin_plan_amount_sets_s.NEXTVAL,

1879: CREATED_BY,
1880: LAST_UPDATE_LOGIN
1881: )
1882: VALUES (
1883: pa_fin_plan_amount_sets_s.NEXTVAL,
1884: 'COST',
1885: p_raw_cost_flag,
1886: p_burdened_cost_flag,
1887: p_cost_qty_flag,

Line 1908: --SELECT pa_fin_plan_amount_sets_s.currval

1904: sysdate,
1905: fnd_global.user_id,
1906: fnd_global.login_id) RETURNING FIN_PLAN_AMOUNT_SET_ID INTO x_cost_amount_set_id;
1907:
1908: --SELECT pa_fin_plan_amount_sets_s.currval
1909: --into x_cost_amount_set_id
1910: --from dual;
1911:
1912: END IF;

Line 1926: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

1922: BEGIN
1923:
1924: /* Changes for FP.M, Tracking Bug No - 3354518
1925: Appending where clause for three new column bill_rate_flag,
1926: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets
1927: below*/
1928: select fin_plan_amount_set_id
1929: into x_revenue_amount_set_id
1930: from pa_fin_plan_amount_sets

Line 1930: from pa_fin_plan_amount_sets

1926: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets
1927: below*/
1928: select fin_plan_amount_set_id
1929: into x_revenue_amount_set_id
1930: from pa_fin_plan_amount_sets
1931: where
1932: revenue_flag=p_revenue_flag and
1933: revenue_qty_flag=p_revenue_qty_flag and
1934: raw_cost_flag = 'N' and

Line 1962: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (

1958: /* Changes for FP.M, Tracking Bug No - 3354518
1959: Adding three new column bill_rate_flag,cost_rate_flag,
1960: burden_rate to the insert statment below */
1961:
1962: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (
1963: FIN_PLAN_AMOUNT_SET_ID,
1964: AMOUNT_SET_TYPE_CODE,
1965: RAW_COST_FLAG,
1966: BURDENED_COST_FLAG,

Line 1989: pa_fin_plan_amount_sets_s.NEXTVAL,

1985: CREATED_BY,
1986: LAST_UPDATE_LOGIN
1987: )
1988: VALUES (
1989: pa_fin_plan_amount_sets_s.NEXTVAL,
1990: 'REVENUE',
1991: 'N',
1992: 'N',
1993: 'N',

Line 2015: --select pa_fin_plan_amount_sets_s.currval

2011: fnd_global.user_id,
2012: fnd_global.login_id)
2013: RETURNING FIN_PLAN_AMOUNT_SET_ID INTO x_revenue_amount_set_id;
2014:
2015: --select pa_fin_plan_amount_sets_s.currval
2016: --into x_revenue_amount_set_id
2017: --from dual;
2018:
2019: END IF;

Line 2031: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

2027: IF p_plan_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
2028: BEGIN
2029: /* Changes for FP.M, Tracking Bug No - 3354518
2030: Appending where clause for three new column bill_rate_flag,
2031: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets
2032: below*/
2033: select fin_plan_amount_set_id
2034: into x_all_amount_set_id
2035: from pa_fin_plan_amount_sets

Line 2035: from pa_fin_plan_amount_sets

2031: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets
2032: below*/
2033: select fin_plan_amount_set_id
2034: into x_all_amount_set_id
2035: from pa_fin_plan_amount_sets
2036: where
2037: raw_cost_flag=p_raw_cost_flag and
2038: burdened_cost_flag=p_burdened_cost_flag and
2039: revenue_flag=p_revenue_flag and

Line 2066: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (

2062: IF l_status = 'NEW' THEN
2063: /* Changes for FP.M, Tracking Bug No - 3354518
2064: Adding three new column bill_rate_flag,cost_rate_flag,
2065: burden_rate to the insert statment below */
2066: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (
2067: FIN_PLAN_AMOUNT_SET_ID,
2068: AMOUNT_SET_TYPE_CODE,
2069: RAW_COST_FLAG,
2070: BURDENED_COST_FLAG,

Line 2093: pa_fin_plan_amount_sets_s.NEXTVAL,

2089: CREATED_BY,
2090: LAST_UPDATE_LOGIN
2091: )
2092: VALUES (
2093: pa_fin_plan_amount_sets_s.NEXTVAL,
2094: 'ALL',
2095: p_raw_cost_flag,
2096: p_burdened_cost_flag,
2097: 'N',

Line 2119: --select pa_fin_plan_amount_sets_s.currval

2115: fnd_global.user_id,
2116: fnd_global.login_id)
2117: RETURNING FIN_PLAN_AMOUNT_SET_ID INTO x_all_amount_set_id;
2118:
2119: --select pa_fin_plan_amount_sets_s.currval
2120: --into x_all_amount_set_id
2121: --from dual;
2122: END IF;
2123: END IF; -- cost and revenue

Line 2184: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,

2180: /*=================================================================================
2181: Given the amount set id the procedure return the flags.
2182: ===================================================================================*/
2183: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
2184: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
2185: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895

Line 2185: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895

2181: Given the amount set id the procedure return the flags.
2182: ===================================================================================*/
2183: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
2184: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
2185: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
2189: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895

Line 2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895

2182: ===================================================================================*/
2183: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
2184: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
2185: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
2189: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
2190: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895

Line 2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895

2183: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
2184: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
2185: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
2189: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
2190: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
2191: /* Changes for FP.M, Tracking Bug No - 3354518

Line 2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895

2184: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
2185: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
2189: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
2190: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
2191: /* Changes for FP.M, Tracking Bug No - 3354518
2192: Adding three new OUT parameters x_bill_rate_flag,

Line 2189: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895

2185: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
2189: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
2190: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
2191: /* Changes for FP.M, Tracking Bug No - 3354518
2192: Adding three new OUT parameters x_bill_rate_flag,
2193: x_cost_rate_flag, x_burden_rate below for

Line 2190: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895

2186: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
2187: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
2188: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
2189: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
2190: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
2191: /* Changes for FP.M, Tracking Bug No - 3354518
2192: Adding three new OUT parameters x_bill_rate_flag,
2193: x_cost_rate_flag, x_burden_rate below for
2194: new columns in pa_fin_plan_amount_sets */

Line 2194: new columns in pa_fin_plan_amount_sets */

2190: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
2191: /* Changes for FP.M, Tracking Bug No - 3354518
2192: Adding three new OUT parameters x_bill_rate_flag,
2193: x_cost_rate_flag, x_burden_rate below for
2194: new columns in pa_fin_plan_amount_sets */
2195: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
2196: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
2197: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
2198: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2195: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895

2191: /* Changes for FP.M, Tracking Bug No - 3354518
2192: Adding three new OUT parameters x_bill_rate_flag,
2193: x_cost_rate_flag, x_burden_rate below for
2194: new columns in pa_fin_plan_amount_sets */
2195: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
2196: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
2197: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
2198: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2199: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2196: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895

2192: Adding three new OUT parameters x_bill_rate_flag,
2193: x_cost_rate_flag, x_burden_rate below for
2194: new columns in pa_fin_plan_amount_sets */
2195: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
2196: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
2197: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
2198: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2199: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2200: x_message_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2197: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895

2193: x_cost_rate_flag, x_burden_rate below for
2194: new columns in pa_fin_plan_amount_sets */
2195: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
2196: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
2197: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
2198: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2199: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2200: x_message_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2201: IS

Line 2250: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

2246:
2247: END IF;
2248: /* Changes for FP.M, Tracking Bug No - 3354518
2249: Appending where clause for three new column bill_rate_flag,
2250: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets
2251: below*/
2252:
2253: select raw_cost_flag,
2254: burdened_cost_flag,

Line 2277: PA_FIN_PLAN_AMOUNT_SETS

2273: X_COST_RATE_FLAG,
2274: X_BURDEN_RATE_FLAG
2275: /* Changes for FPM End here ,Tracking Bug No - 3354518*/
2276: from
2277: PA_FIN_PLAN_AMOUNT_SETS
2278: where
2279: fin_plan_amount_set_id = P_AMOUNT_SET_ID;
2280:
2281: IF P_PA_DEBUG_MODE = 'Y' THEN