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 655: p_distribution_num po_distributions_all.distribution_num%TYPE,

651: /*******/
652: /* POD */
653: /*******/
654: FUNCTION get_pod_row_from_num(
655: p_distribution_num po_distributions_all.distribution_num%TYPE,
656: p_line_location_id po_distributions_all.line_location_id%TYPE
657: )
658: RETURN po_distributions_all%ROWTYPE IS
659: BEGIN

Line 656: p_line_location_id po_distributions_all.line_location_id%TYPE

652: /* POD */
653: /*******/
654: FUNCTION get_pod_row_from_num(
655: p_distribution_num po_distributions_all.distribution_num%TYPE,
656: p_line_location_id po_distributions_all.line_location_id%TYPE
657: )
658: RETURN po_distributions_all%ROWTYPE IS
659: BEGIN
660: IF ( p_distribution_num IS NULL

Line 658: RETURN po_distributions_all%ROWTYPE IS

654: FUNCTION get_pod_row_from_num(
655: p_distribution_num po_distributions_all.distribution_num%TYPE,
656: p_line_location_id po_distributions_all.line_location_id%TYPE
657: )
658: RETURN po_distributions_all%ROWTYPE IS
659: BEGIN
660: IF ( p_distribution_num IS NULL
661: OR p_line_location_id IS NULL) THEN
662: RETURN NULL;

Line 673: FROM po_distributions_all

669:
670: --first check if there is a singular match in the current OU
671: SELECT *
672: INTO g_pod_row
673: FROM po_distributions_all
674: WHERE po_distribution_id IN(SELECT po_distribution_id
675: FROM po_distributions
676: WHERE distribution_num = p_distribution_num
677: AND line_location_id = p_line_location_id);

Line 685: FROM po_distributions_all

681: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
682: BEGIN
683: SELECT *
684: INTO g_pod_row
685: FROM po_distributions_all
686: WHERE distribution_num = p_distribution_num
687: AND line_location_id = p_line_location_id;
688:
689: RETURN g_pod_row;

Line 709: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE

705: RETURN NULL;
706: END get_pod_row_from_num;
707:
708: FUNCTION get_pod_row_from_id(
709: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE
710: )
711: RETURN po_distributions_all%ROWTYPE IS
712: BEGIN
713: IF (p_distribution_id IS NULL) THEN

Line 711: RETURN po_distributions_all%ROWTYPE IS

707:
708: FUNCTION get_pod_row_from_id(
709: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE
710: )
711: RETURN po_distributions_all%ROWTYPE IS
712: BEGIN
713: IF (p_distribution_id IS NULL) THEN
714: RETURN NULL;
715: END IF;

Line 723: FROM po_distributions_all

719: END IF;
720:
721: SELECT *
722: INTO g_pod_row
723: FROM po_distributions_all
724: WHERE po_distribution_id = p_distribution_id;
725:
726: RETURN g_pod_row;
727: EXCEPTION