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 1672: creates a new record in PA_FIN_PLAN_AMOUNT_SETS and returns it.

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

Line 1677: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,

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

Line 1678: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,

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

Line 1679: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,

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

Line 1680: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,

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

Line 1681: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,

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

Line 1682: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,

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

Line 1687: new columns in pa_fin_plan_amount_sets */

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

Line 1688: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,

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

Line 1689: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,

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

Line 1690: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,

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

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

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

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

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

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

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

Line 1740: columns in pa_fin_plan_amount_sets */

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

Line 1784: columns in pa_fin_plan_amount_sets */

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

Line 1819: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

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

Line 1823: from pa_fin_plan_amount_sets

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

Line 1854: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (

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

Line 1881: pa_fin_plan_amount_sets_s.NEXTVAL,

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

Line 1906: --SELECT pa_fin_plan_amount_sets_s.currval

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

Line 1924: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

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

Line 1928: from pa_fin_plan_amount_sets

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

Line 1960: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (

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

Line 1987: pa_fin_plan_amount_sets_s.NEXTVAL,

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

Line 2013: --select pa_fin_plan_amount_sets_s.currval

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

Line 2029: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

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

Line 2033: from pa_fin_plan_amount_sets

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

Line 2064: INSERT INTO PA_FIN_PLAN_AMOUNT_SETS (

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

Line 2091: pa_fin_plan_amount_sets_s.NEXTVAL,

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

Line 2117: --select pa_fin_plan_amount_sets_s.currval

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

Line 2182: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2192: new columns in pa_fin_plan_amount_sets */

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

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

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

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

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

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

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

Line 2248: cost_rate_flag, burden_rate added to pa_fin_plan_amount_sets

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

Line 2275: PA_FIN_PLAN_AMOUNT_SETS

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