DBA Data[Home] [Help]

APPS.PA_FP_FCST_GEN_CLIENT_EXT dependencies on PA_BUDGET_LINES

Line 16: ( PERIOD_NAME pa_budget_lines.period_name%TYPE,

12: * @rep:category BUSINESS_ENTITY PA_FORECAST
13: * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14: */
15: type l_pds_rate_dtls_rec_type is RECORD
16: ( PERIOD_NAME pa_budget_lines.period_name%TYPE,
17: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
18: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
19: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE);
20:

Line 17: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,

13: * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14: */
15: type l_pds_rate_dtls_rec_type is RECORD
16: ( PERIOD_NAME pa_budget_lines.period_name%TYPE,
17: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
18: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
19: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE);
20:
21: type l_pds_rate_dtls_tab is

Line 18: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,

14: */
15: type l_pds_rate_dtls_rec_type is RECORD
16: ( PERIOD_NAME pa_budget_lines.period_name%TYPE,
17: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
18: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
19: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE);
20:
21: type l_pds_rate_dtls_tab is
22: TABLE of l_pds_rate_dtls_rec_type INDEX BY BINARY_INTEGER;

Line 19: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE);

15: type l_pds_rate_dtls_rec_type is RECORD
16: ( PERIOD_NAME pa_budget_lines.period_name%TYPE,
17: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
18: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
19: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE);
20:
21: type l_pds_rate_dtls_tab is
22: TABLE of l_pds_rate_dtls_rec_type INDEX BY BINARY_INTEGER;
23:

Line 26: TABLE of pa_budget_lines.period_name%TYPE;

22: TABLE of l_pds_rate_dtls_rec_type INDEX BY BINARY_INTEGER;
23:
24: /*
25: type tab_period_name is
26: TABLE of pa_budget_lines.period_name%TYPE;
27:
28: type tab_raw_cost_rate is
29: TABLE of pa_budget_lines.txn_standard_cost_rate%TYPE;
30:

Line 29: TABLE of pa_budget_lines.txn_standard_cost_rate%TYPE;

25: type tab_period_name is
26: TABLE of pa_budget_lines.period_name%TYPE;
27:
28: type tab_raw_cost_rate is
29: TABLE of pa_budget_lines.txn_standard_cost_rate%TYPE;
30:
31: type tab_burden_cost_rate is
32: TABLE of pa_budget_lines.burden_cost_rate%TYPE;
33:

Line 32: TABLE of pa_budget_lines.burden_cost_rate%TYPE;

28: type tab_raw_cost_rate is
29: TABLE of pa_budget_lines.txn_standard_cost_rate%TYPE;
30:
31: type tab_burden_cost_rate is
32: TABLE of pa_budget_lines.burden_cost_rate%TYPE;
33:
34: type tab_bill_rate is
35: TABLE of pa_budget_lines.txn_standard_bill_rate%TYPE;
36: */

Line 35: TABLE of pa_budget_lines.txn_standard_bill_rate%TYPE;

31: type tab_burden_cost_rate is
32: TABLE of pa_budget_lines.burden_cost_rate%TYPE;
33:
34: type tab_bill_rate is
35: TABLE of pa_budget_lines.txn_standard_bill_rate%TYPE;
36: */
37:
38: -- Start Bug 5726785
39:

Line 41: ( period_name pa_budget_lines.period_name%TYPE,

37:
38: -- Start Bug 5726785
39:
40: TYPE l_plan_txn_prd_amt_rec IS RECORD
41: ( period_name pa_budget_lines.period_name%TYPE,
42: etc_quantity pa_budget_lines.quantity%TYPE,
43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,

Line 42: etc_quantity pa_budget_lines.quantity%TYPE,

38: -- Start Bug 5726785
39:
40: TYPE l_plan_txn_prd_amt_rec IS RECORD
41: ( period_name pa_budget_lines.period_name%TYPE,
42: etc_quantity pa_budget_lines.quantity%TYPE,
43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,

Line 43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,

39:
40: TYPE l_plan_txn_prd_amt_rec IS RECORD
41: ( period_name pa_budget_lines.period_name%TYPE,
42: etc_quantity pa_budget_lines.quantity%TYPE,
43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,
47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,

Line 44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,

40: TYPE l_plan_txn_prd_amt_rec IS RECORD
41: ( period_name pa_budget_lines.period_name%TYPE,
42: etc_quantity pa_budget_lines.quantity%TYPE,
43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,
47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,
48: init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,

Line 45: txn_revenue pa_budget_lines.txn_revenue%TYPE,

41: ( period_name pa_budget_lines.period_name%TYPE,
42: etc_quantity pa_budget_lines.quantity%TYPE,
43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,
47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,
48: init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,
49: init_revenue pa_budget_lines.init_revenue%TYPE,

Line 46: init_quantity pa_budget_lines.init_quantity%TYPE,

42: etc_quantity pa_budget_lines.quantity%TYPE,
43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,
47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,
48: init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,
49: init_revenue pa_budget_lines.init_revenue%TYPE,
50: periodic_line_editable VARCHAR2(1), -- Identifier which specifies whether the ETC figures are editable for a period or not

Line 47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,

43: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,
47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,
48: init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,
49: init_revenue pa_budget_lines.init_revenue%TYPE,
50: periodic_line_editable VARCHAR2(1), -- Identifier which specifies whether the ETC figures are editable for a period or not
51: description VARCHAR2(30) ); -- Description of the period. Values would be stamped using a new lookup type, PA_FP_FCST_GEN_CLNT_EXTN_LU.

Line 48: init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,

44: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,
47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,
48: init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,
49: init_revenue pa_budget_lines.init_revenue%TYPE,
50: periodic_line_editable VARCHAR2(1), -- Identifier which specifies whether the ETC figures are editable for a period or not
51: description VARCHAR2(30) ); -- Description of the period. Values would be stamped using a new lookup type, PA_FP_FCST_GEN_CLNT_EXTN_LU.
52:

Line 49: init_revenue pa_budget_lines.init_revenue%TYPE,

45: txn_revenue pa_budget_lines.txn_revenue%TYPE,
46: init_quantity pa_budget_lines.init_quantity%TYPE,
47: init_raw_cost pa_budget_lines.init_raw_cost%TYPE,
48: init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,
49: init_revenue pa_budget_lines.init_revenue%TYPE,
50: periodic_line_editable VARCHAR2(1), -- Identifier which specifies whether the ETC figures are editable for a period or not
51: description VARCHAR2(30) ); -- Description of the period. Values would be stamped using a new lookup type, PA_FP_FCST_GEN_CLNT_EXTN_LU.
52:
53: TYPE l_plan_txn_prd_amt_tbl IS