APPS.PA_INTEGRATION dependencies on PA_EXPENDITURE_ITEMS

Line 31: PA_EXPENDITURE_ITEMS EI

27: CURSOR pending_transfer IS
28: SELECT 'AP_PROJ_TASK_EXIST_PA'
29: FROM
30: PA_COST_DISTRIBUTION_LINES CDL,
31: PA_EXPENDITURE_ITEMS EI
32: WHERE
33: EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
34: AND CDL.TRANSFER_STATUS_CODE IN ('P','R','X')
35: AND EI.SYSTEM_LINKAGE_FUNCTION in ( 'VI','ER')

Line 52: FROM PA_EXPENDITURE_ITEMS EI

48: AND CDL.transfer_status_code||'' IN ('V','A')
49: AND CDL.line_type = 'R'
50: AND EXISTS
51: ( SELECT ' There are Splits/Transfers on EI'
52: FROM PA_EXPENDITURE_ITEMS EI
53: WHERE EI.SYSTEM_LINKAGE_FUNCTION in ( 'VI', 'ER' )
54: AND EI.TRANSFERRED_FROM_EXP_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
55: AND EI.ADJUSTED_EXPENDITURE_ITEM_ID IS NULL
56: AND EI.COST_DISTRIBUTED_FLAG||'' = 'N'

Line 72: FROM PA_EXPENDITURE_ITEMS EI

68: AND CDL.transfer_status_code||'' IN ( 'V', 'A' )
69: AND CDL.line_type = 'R'
70: AND EXISTS
71: ( SELECT 'Marked for recalc'
72: FROM PA_EXPENDITURE_ITEMS EI
73: WHERE EI.SYSTEM_LINKAGE_FUNCTION in ( 'VI','ER')
74: AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
75: AND EI.COST_DISTRIBUTED_FLAG = 'N'
76: );

Line 91: FROM PA_EXPENDITURE_ITEMS EI

87: AND CDL.transfer_status_code ||'' IN ('V','A')
88: AND CDL.line_type = 'R'
89: AND EXISTS
90: ( SELECT ' Reversed EI '
91: FROM PA_EXPENDITURE_ITEMS EI
92: WHERE EI.SYSTEM_LINKAGE_FUNCTION in ( 'VI','ER')
93: AND EI.ADJUSTED_EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
94: AND EI.COST_DISTRIBUTED_FLAG||'' = 'N'
95: );

Line 733: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

729: * The period information calculation is same for all transactions coming
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

Line 736: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

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
740: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

Line 737: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

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
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