APPS.RCV_TABLE_FUNCTIONS dependencies on PO_DISTRIBUTIONS_ALL

Line 12: g_pod_row po_distributions_all%ROWTYPE;

8: g_rsl_row rcv_shipment_lines%ROWTYPE;
9: g_poh_row po_headers_all%ROWTYPE;
10: g_pol_row po_lines_all%ROWTYPE;
11: g_pll_row po_line_locations_all%ROWTYPE;
12: g_pod_row po_distributions_all%ROWTYPE;
13: g_oeh_row oe_order_headers_all%ROWTYPE;
14: g_oel_row oe_order_lines_all%ROWTYPE;
15: g_prl_row po_requisition_lines_all%ROWTYPE;
16: g_prd_row po_req_distributions_all%ROWTYPE;

Line 628: p_distribution_num po_distributions_all.distribution_num%TYPE,

624: /*******/
625: /* POD */
626: /*******/
627: FUNCTION get_pod_row_from_num(
628: p_distribution_num po_distributions_all.distribution_num%TYPE,
629: p_line_location_id po_distributions_all.line_location_id%TYPE
630: )
631: RETURN po_distributions_all%ROWTYPE IS
632: BEGIN

Line 629: p_line_location_id po_distributions_all.line_location_id%TYPE

625: /* POD */
626: /*******/
627: FUNCTION get_pod_row_from_num(
628: p_distribution_num po_distributions_all.distribution_num%TYPE,
629: p_line_location_id po_distributions_all.line_location_id%TYPE
630: )
631: RETURN po_distributions_all%ROWTYPE IS
632: BEGIN
633: IF ( p_distribution_num IS NULL

Line 631: RETURN po_distributions_all%ROWTYPE IS

627: FUNCTION get_pod_row_from_num(
628: p_distribution_num po_distributions_all.distribution_num%TYPE,
629: p_line_location_id po_distributions_all.line_location_id%TYPE
630: )
631: RETURN po_distributions_all%ROWTYPE IS
632: BEGIN
633: IF ( p_distribution_num IS NULL
634: OR p_line_location_id IS NULL) THEN
635: RETURN NULL;

Line 646: FROM po_distributions_all

642:
643: --first check if there is a singular match in the current OU
644: SELECT *
645: INTO g_pod_row
646: FROM po_distributions_all
647: WHERE po_distribution_id IN(SELECT po_distribution_id
648: FROM po_distributions
649: WHERE distribution_num = p_distribution_num
650: AND line_location_id = p_line_location_id);

Line 658: FROM po_distributions_all

654: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
655: BEGIN
656: SELECT *
657: INTO g_pod_row
658: FROM po_distributions_all
659: WHERE distribution_num = p_distribution_num
660: AND line_location_id = p_line_location_id;
661:
662: RETURN g_pod_row;

Line 682: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE

678: RETURN NULL;
679: END get_pod_row_from_num;
680:
681: FUNCTION get_pod_row_from_id(
682: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE
683: )
684: RETURN po_distributions_all%ROWTYPE IS
685: BEGIN
686: IF (p_distribution_id IS NULL) THEN

Line 684: RETURN po_distributions_all%ROWTYPE IS

680:
681: FUNCTION get_pod_row_from_id(
682: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE
683: )
684: RETURN po_distributions_all%ROWTYPE IS
685: BEGIN
686: IF (p_distribution_id IS NULL) THEN
687: RETURN NULL;
688: END IF;

Line 696: FROM po_distributions_all

692: END IF;
693:
694: SELECT *
695: INTO g_pod_row
696: FROM po_distributions_all
697: WHERE po_distribution_id = p_distribution_id;
698:
699: RETURN g_pod_row;
700: EXCEPTION