APPS.PA_AP_INTEGRATION dependencies on PO_DISTRIBUTIONS_ALL

Line 626: from po_distributions_all

622: l_pa_debug_flag varchar2(1) ;
623:
624: cursor c_po_date is
625: select expenditure_item_date
626: from po_distributions_all
627: where po_distribution_id = p_po_distribution_id ;
628:
629: BEGIN
630: l_pa_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 757: p_po_distribution_id IN po_distributions_all.po_distribution_id%TYPE,

753: ( p_transaction_date IN DATE,
754: p_gl_date IN DATE,
755: p_po_exp_item_date IN DATE,
756: p_creation_date IN DATE,
757: p_po_distribution_id IN po_distributions_all.po_distribution_id%TYPE,
758: p_calling_program IN VARCHAR2,
759: p_exp_item_date OUT NOCOPY DATE,
760: p_is_date_valid OUT NOCOPY VARCHAR2,
761: p_pa_message_name OUT NOCOPY varchar2,

Line 832: from po_distributions_all

828: V_MSGCOUNT NUMBER;
829:
830: cursor c_po_date is
831: select expenditure_item_date
832: from po_distributions_all
833: where po_distribution_id = p_po_distribution_id ;
834:
835:
836: /* The cursor for getting all the variables to be passed to the patc.get_status proc. The use of ap_invoices_all is not done here as we dont have the invoice id being passed by AP */

Line 883: from po_distributions_all pod,

879: NULL,
880: NULL,
881: NULL,
882: NULL
883: from po_distributions_all pod,
884: po_headers_all poh,
885: GL_SETS_OF_BOOKS G
886: where
887: poh.po_header_id = pod.po_header_id

Line 919: from po_distributions_all pod

915:
916: begin
917: select pod.project_id,pod.task_id,pod.expenditure_type,DESTINATION_TYPE_CODE /* Added for bug 16312792 */
918: into l_project_id,l_task_id,l_expenditure_type,l_DESTINATION_TYPE_CODE /* Added for bug 16312792 */
919: from po_distributions_all pod
920: where
921: pod.po_distribution_id = p_po_distribution_id;
922: exception when no_data_found then
923: l_project_id := NULL;

Line 946: po_distributions_all pod,

942: 'POTRNSDT',
943: l_po_exp_item_date)
944: into l_award_id,l_profile_date
945: from gms_awards_all awd,
946: po_distributions_all pod,
947: gms_award_distributions adl
948: where adl.award_id = awd.award_id
949: and pod.po_distribution_id = p_po_distribution_id
950: and pod.award_id = adl.award_set_id