DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_BUDGET_LINES_S

Line 818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE

814:
815: /* This API populates the plsql tables with budget lines for bulk insert */
816: PROCEDURE insert_budget_line(
817: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE
819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

Line 842: SELECT PA_BUDGET_LINES_S.NEXTVAL

838: x_msg_count := 0;
839: x_msg_data := NULL;
840:
841: -- get Budget Line ID
842: SELECT PA_BUDGET_LINES_S.NEXTVAL
843: INTO l_budget_line_id
844: FROM DUAL;
845:
846: x_budget_line_id := l_budget_line_id;

Line 2771: p_start_date IN pa_budget_lines.start_date%TYPE,

2767:
2768: END get_options;
2769:
2770: PROCEDURE get_periods (
2771: p_start_date IN pa_budget_lines.start_date%TYPE,
2772: p_end_date IN pa_budget_lines.end_date%TYPE,
2773: p_period_set_name IN gl_sets_of_books.
2774: period_set_name%TYPE,
2775: p_accounted_period_type IN gl_sets_of_books.