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_INTEGRATION dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 8: G_PrevPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;

4: l_invoice_id NUMBER;
5: l_invoice_status Varchar2(30);
6: l_status_type Varchar2(30);
7:
8: G_PrevPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
9: G_PrevPdStDate DATE;
10: G_PrevPdEdDate DATE;
11: G_PrevSOBId NUMBER;
12:

Line 14: FUNCTION get_period_name RETURN pa_cost_distribution_lines_all.pa_period_name%TYPE is

10: G_PrevPdEdDate DATE;
11: G_PrevSOBId NUMBER;
12:
13: -- FUNCTION get_period_name /*2835063*/
14: FUNCTION get_period_name RETURN pa_cost_distribution_lines_all.pa_period_name%TYPE is
15: BEGIN
16: /* Please note that this function should be used only after ensuring that
17: get_raw_cdl_pa_date() is called, so that the returned variable's value has a
18: non-NULL value */

Line 216: l_earliest_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

212: IS
213: -- local variables
214: l_earliest_start_date DATE ;
215: l_earliest_end_date DATE ;
216: l_earliest_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
217: l_pa_date DATE ;
218: l_start_date DATE ; -- start date for the l_pa_date.
219: l_end_date DATE ; -- end date for the l_pa_date ( equals l_pa_date ).
220: l_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

Line 220: l_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

216: l_earliest_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
217: l_pa_date DATE ;
218: l_start_date DATE ; -- start date for the l_pa_date.
219: l_end_date DATE ; -- end date for the l_pa_date ( equals l_pa_date ).
220: l_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
221:
222: l_prof_new_gldate_derivation VARCHAR2(1) := 'N' ;
223:
224: BEGIN

Line 687: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

683: * EPP.
684: * This function can be called for both Provider and Receiver gl dates
685: * by passing the appropriate parameters.
686: */
687: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
688: ,p_set_of_books_id IN pa_implementations_all.set_of_books_id%TYPE
689: )
690: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
691: IS

Line 690: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE

686: */
687: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
688: ,p_set_of_books_id IN pa_implementations_all.set_of_books_id%TYPE
689: )
690: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
691: IS
692: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
693: l_gl_start_date DATE;
694: l_gl_end_date DATE;

Line 692: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

688: ,p_set_of_books_id IN pa_implementations_all.set_of_books_id%TYPE
689: )
690: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
691: IS
692: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
693: l_gl_start_date DATE;
694: l_gl_end_date DATE;
695: BEGIN
696:

Line 734: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

730: * into PA thro transaction import. The following procedure does not distinguish
731: * between system linkages.
732: */
733: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
734: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
735: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
736: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
737: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
738: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 735: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE

731: * between system linkages.
732: */
733: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
734: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
735: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
736: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
737: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
738: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
739: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 740: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

736: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
737: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
738: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
739: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
740: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
741: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

Line 741: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

737: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
738: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
739: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
740: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
741: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
745: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

Line 742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE

738: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
739: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
740: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
741: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
745: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
746: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

Line 743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

739: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
740: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
741: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
745: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
746: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
747: ,x_return_status OUT NOCOPY NUMBER

Line 744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

740: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
741: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
745: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
746: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
747: ,x_return_status OUT NOCOPY NUMBER
748: ,x_error_code OUT NOCOPY VARCHAR2

Line 745: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

741: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
745: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
746: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
747: ,x_return_status OUT NOCOPY NUMBER
748: ,x_error_code OUT NOCOPY VARCHAR2
749: ,x_error_stage OUT NOCOPY NUMBER

Line 746: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

742: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
743: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
744: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
745: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
746: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
747: ,x_return_status OUT NOCOPY NUMBER
748: ,x_error_code OUT NOCOPY VARCHAR2
749: ,x_error_stage OUT NOCOPY NUMBER
750: )

Line 752: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

748: ,x_error_code OUT NOCOPY VARCHAR2
749: ,x_error_stage OUT NOCOPY NUMBER
750: )
751: IS
752: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
753: l_prvdr_pa_period_name pa_periods.period_name%TYPE;
754: l_prvdr_gl_period_name gl_periods.period_name%TYPE;
755:
756: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 756: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

752: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
753: l_prvdr_pa_period_name pa_periods.period_name%TYPE;
754: l_prvdr_gl_period_name gl_periods.period_name%TYPE;
755:
756: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
757: l_recvr_pa_period_name pa_periods.period_name%TYPE;
758: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
759: l_recvr_gl_period_name gl_periods.period_name%TYPE;
760:

Line 758: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

754: l_prvdr_gl_period_name gl_periods.period_name%TYPE;
755:
756: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
757: l_recvr_pa_period_name pa_periods.period_name%TYPE;
758: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
759: l_recvr_gl_period_name gl_periods.period_name%TYPE;
760:
761: l_pa_gl_app_id NUMBER := 8721;
762: l_gl_app_id NUMBER := 101;