APPS.GML_PO_SYNCH dependencies on PO_RELEASES_ALL

Line 1533: v_created_by PO_RELEASES_ALL.created_by%TYPE;

1529:
1530: /* Bug 1829102 - Declaring variables and
1531: modifying cursor to fetch more fields */
1532:
1533: v_created_by PO_RELEASES_ALL.created_by%TYPE;
1534: v_last_updated_by PO_RELEASES_ALL.last_updated_by%TYPE;
1535: v_last_update_date DATE;
1536: v_buyer_code VARCHAR2(35);
1537: v_agent_id PO_RELEASES_ALL.agent_id%TYPE;

Line 1534: v_last_updated_by PO_RELEASES_ALL.last_updated_by%TYPE;

1530: /* Bug 1829102 - Declaring variables and
1531: modifying cursor to fetch more fields */
1532:
1533: v_created_by PO_RELEASES_ALL.created_by%TYPE;
1534: v_last_updated_by PO_RELEASES_ALL.last_updated_by%TYPE;
1535: v_last_update_date DATE;
1536: v_buyer_code VARCHAR2(35);
1537: v_agent_id PO_RELEASES_ALL.agent_id%TYPE;
1538:

Line 1537: v_agent_id PO_RELEASES_ALL.agent_id%TYPE;

1533: v_created_by PO_RELEASES_ALL.created_by%TYPE;
1534: v_last_updated_by PO_RELEASES_ALL.last_updated_by%TYPE;
1535: v_last_update_date DATE;
1536: v_buyer_code VARCHAR2(35);
1537: v_agent_id PO_RELEASES_ALL.agent_id%TYPE;
1538:
1539: CURSOR release_date_cur (
1540: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
1541: v_release_num CPG_PURCHASING_INTERFACE.RELEASE_NUM%TYPE)

Line 1544: FROM po_releases_all

1540: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
1541: v_release_num CPG_PURCHASING_INTERFACE.RELEASE_NUM%TYPE)
1542: IS
1543: SELECT release_date,created_by, last_updated_by, last_update_date,agent_id
1544: FROM po_releases_all
1545: WHERE po_header_id = v_po_header_id
1546: AND release_num = v_release_num;
1547:
1548: CURSOR buyer_code_cur ( v_agent_id PO_RELEASES_ALL.agent_id%TYPE )

Line 1548: CURSOR buyer_code_cur ( v_agent_id PO_RELEASES_ALL.agent_id%TYPE )

1544: FROM po_releases_all
1545: WHERE po_header_id = v_po_header_id
1546: AND release_num = v_release_num;
1547:
1548: CURSOR buyer_code_cur ( v_agent_id PO_RELEASES_ALL.agent_id%TYPE )
1549: IS
1550: SELECT upper(substrb(last_name ,1,35))
1551: FROM per_people_f
1552: WHERE person_id=v_agent_id;