DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_PROJ_PERIODS_DENORM

Line 46: TABLE of pa_proj_periods_denorm.amount_type_code%TYPE index by BINARY_INTEGER;

42: TABLE of VARCHAR2(1) index by BINARY_INTEGER;
43: type av_tab_row_level is
44: TABLE of NUMBER index by BINARY_INTEGER;
45: type av_tab_amount_type is
46: TABLE of pa_proj_periods_denorm.amount_type_code%TYPE index by BINARY_INTEGER;
47: type av_tab_amount_subtype is
48: TABLE of pa_proj_periods_denorm.amount_subtype_code%TYPE index by BINARY_INTEGER;
49: type av_tab_period_numbers is
50: TABLE of pa_proj_periods_denorm.period_amount1%TYPE index by BINARY_INTEGER;

Line 48: TABLE of pa_proj_periods_denorm.amount_subtype_code%TYPE index by BINARY_INTEGER;

44: TABLE of NUMBER index by BINARY_INTEGER;
45: type av_tab_amount_type is
46: TABLE of pa_proj_periods_denorm.amount_type_code%TYPE index by BINARY_INTEGER;
47: type av_tab_amount_subtype is
48: TABLE of pa_proj_periods_denorm.amount_subtype_code%TYPE index by BINARY_INTEGER;
49: type av_tab_period_numbers is
50: TABLE of pa_proj_periods_denorm.period_amount1%TYPE index by BINARY_INTEGER;
51: type av_tab_amount_type_id is
52: TABLE of pa_proj_periods_denorm.amount_type_id%TYPE index by BINARY_INTEGER;

Line 50: TABLE of pa_proj_periods_denorm.period_amount1%TYPE index by BINARY_INTEGER;

46: TABLE of pa_proj_periods_denorm.amount_type_code%TYPE index by BINARY_INTEGER;
47: type av_tab_amount_subtype is
48: TABLE of pa_proj_periods_denorm.amount_subtype_code%TYPE index by BINARY_INTEGER;
49: type av_tab_period_numbers is
50: TABLE of pa_proj_periods_denorm.period_amount1%TYPE index by BINARY_INTEGER;
51: type av_tab_amount_type_id is
52: TABLE of pa_proj_periods_denorm.amount_type_id%TYPE index by BINARY_INTEGER;
53: type av_tab_amount_subtype_id is
54: TABLE of pa_proj_periods_denorm.amount_subtype_id%TYPE index by BINARY_INTEGER;

Line 52: TABLE of pa_proj_periods_denorm.amount_type_id%TYPE index by BINARY_INTEGER;

48: TABLE of pa_proj_periods_denorm.amount_subtype_code%TYPE index by BINARY_INTEGER;
49: type av_tab_period_numbers is
50: TABLE of pa_proj_periods_denorm.period_amount1%TYPE index by BINARY_INTEGER;
51: type av_tab_amount_type_id is
52: TABLE of pa_proj_periods_denorm.amount_type_id%TYPE index by BINARY_INTEGER;
53: type av_tab_amount_subtype_id is
54: TABLE of pa_proj_periods_denorm.amount_subtype_id%TYPE index by BINARY_INTEGER;
55: type av_tab_unit_of_measure is
56: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;

Line 54: TABLE of pa_proj_periods_denorm.amount_subtype_id%TYPE index by BINARY_INTEGER;

50: TABLE of pa_proj_periods_denorm.period_amount1%TYPE index by BINARY_INTEGER;
51: type av_tab_amount_type_id is
52: TABLE of pa_proj_periods_denorm.amount_type_id%TYPE index by BINARY_INTEGER;
53: type av_tab_amount_subtype_id is
54: TABLE of pa_proj_periods_denorm.amount_subtype_id%TYPE index by BINARY_INTEGER;
55: type av_tab_unit_of_measure is
56: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;
57: type av_tab_preceding_amts is
58: TABLE of pa_proj_periods_denorm.preceding_periods_amount%TYPE index by BINARY_INTEGER;

Line 58: TABLE of pa_proj_periods_denorm.preceding_periods_amount%TYPE index by BINARY_INTEGER;

54: TABLE of pa_proj_periods_denorm.amount_subtype_id%TYPE index by BINARY_INTEGER;
55: type av_tab_unit_of_measure is
56: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;
57: type av_tab_preceding_amts is
58: TABLE of pa_proj_periods_denorm.preceding_periods_amount%TYPE index by BINARY_INTEGER;
59: type av_tab_succeeding_amts is
60: TABLE of pa_proj_periods_denorm.succeeding_periods_amount%TYPE index by BINARY_INTEGER;
61: type av_tab_has_child_element is
62: TABLE of VARCHAR2(1) index by BINARY_INTEGER;

Line 60: TABLE of pa_proj_periods_denorm.succeeding_periods_amount%TYPE index by BINARY_INTEGER;

56: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;
57: type av_tab_preceding_amts is
58: TABLE of pa_proj_periods_denorm.preceding_periods_amount%TYPE index by BINARY_INTEGER;
59: type av_tab_succeeding_amts is
60: TABLE of pa_proj_periods_denorm.succeeding_periods_amount%TYPE index by BINARY_INTEGER;
61: type av_tab_has_child_element is
62: TABLE of VARCHAR2(1) index by BINARY_INTEGER;
63:
64: G_DEFAULT_AMOUNT_TYPE_CODE VARCHAR2(30);

Line 345: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,

341: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
342: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
343: p_task_id IN pa_resource_assignments.task_id%TYPE,
344: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
345: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
346: p_amt_or_periodic IN VARCHAR2) return VARCHAR2;
347:
348: end pa_fp_view_plans_pub;