APPS.PO_PA_INTEGRATION_GRP dependencies on PO_DISTRIBUTIONS_ALL

Line 101: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE; --BUG#7046429

97: l_api_name CONSTANT VARCHAR2(30) := 'validate_temp_labor_po';
98: l_api_version CONSTANT NUMBER := 1.0;
99:
100: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
101: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE; --BUG#7046429
102: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
103: l_assignment_id NUMBER;
104:
105: l_status_rec PO_STATUS_REC_TYPE;

Line 245: FROM po_distributions_all

241: -- Sql Why : To check the project task validity
242: -- BUG#7046429
243: SELECT min(po_distribution_id)
244: INTO l_distribution_id
245: FROM po_distributions_all
246: WHERE po_line_id = p_po_line_id
247: AND project_id = p_project_id
248: AND task_id = p_task_id;
249:

Line 342: FROM po_distributions_all pod1,

338: -- match with the projects in Purchase Order and might doesn't matches.
339:
340: SELECT sum(nvl(pod1.amount_ordered,0) - nvl(pod1.amount_cancelled,0))
341: INTO x_po_line_amt
342: FROM po_distributions_all pod1,
343: po_distributions_all pod2
344: WHERE pod1.po_line_id = pod2.po_line_id
345: AND pod1.project_id = pod2.project_id
346: AND pod1.task_id = pod2.task_id

Line 343: po_distributions_all pod2

339:
340: SELECT sum(nvl(pod1.amount_ordered,0) - nvl(pod1.amount_cancelled,0))
341: INTO x_po_line_amt
342: FROM po_distributions_all pod1,
343: po_distributions_all pod2
344: WHERE pod1.po_line_id = pod2.po_line_id
345: AND pod1.project_id = pod2.project_id
346: AND pod1.task_id = pod2.task_id
347: AND pod2.po_distribution_id = l_distribution_id;

Line 407: FROM po_distributions_all

403: -- Sql What : Gets the line id for the given distribution
404: -- Sql Why : To check the line type
405: SELECT po_line_id
406: INTO l_po_line_id
407: FROM po_distributions_all
408: WHERE po_distribution_id = p_po_distribution_id;
409: Exception
410: When others then
411: RETURN FALSE;

Line 495: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;

491: l_api_version CONSTANT NUMBER := 1.0;
492:
493: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
494: l_price NUMBER := null;
495: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
496: l_rate PO_DISTRIBUTIONS_ALL.rate%TYPE;
497: l_rate_date PO_DISTRIBUTIONS_ALL.rate_date%TYPE;
498: l_base_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
499:

Line 496: l_rate PO_DISTRIBUTIONS_ALL.rate%TYPE;

492:
493: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
494: l_price NUMBER := null;
495: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
496: l_rate PO_DISTRIBUTIONS_ALL.rate%TYPE;
497: l_rate_date PO_DISTRIBUTIONS_ALL.rate_date%TYPE;
498: l_base_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
499:
500: BEGIN

Line 497: l_rate_date PO_DISTRIBUTIONS_ALL.rate_date%TYPE;

493: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
494: l_price NUMBER := null;
495: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
496: l_rate PO_DISTRIBUTIONS_ALL.rate%TYPE;
497: l_rate_date PO_DISTRIBUTIONS_ALL.rate_date%TYPE;
498: l_base_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
499:
500: BEGIN
501: -- Initialise the return status

Line 561: FROM po_distributions_all

557: -- Sql What : Gets the minimam distribution id for the give project/task
558: -- Sql Why : To get the currency info
559: SELECT min(po_distribution_id)
560: INTO l_distribution_id
561: FROM po_distributions_all
562: WHERE po_line_id = p_po_line_id
563: AND project_id = p_project_id
564: AND task_id = p_task_id;
565:

Line 597: FROM po_distributions_all

593: SELECT rate_date,
594: rate
595: INTO l_rate_date,
596: l_rate
597: FROM po_distributions_all
598: WHERE po_distribution_id = l_distribution_id;
599:
600: Exception
601: When others then