APPS.PV_MATCH_V2_PUB dependencies on DBMS_SQL

Line 1637: l_theCursor := DBMS_SQL.OPEN_CURSOR;

1633: -- ==============================================================================
1634: -- Process the dynamic SQL to retrieve matching partner.
1635: -- ==============================================================================
1636: -- ==============================================================================
1637: l_theCursor := DBMS_SQL.OPEN_CURSOR;
1638:
1639: DBMS_SQL.PARSE(c => l_theCursor,
1640: statement => p_sql,
1641: language_flag => DBMS_SQL.NATIVE);

Line 1639: DBMS_SQL.PARSE(c => l_theCursor,

1635: -- ==============================================================================
1636: -- ==============================================================================
1637: l_theCursor := DBMS_SQL.OPEN_CURSOR;
1638:
1639: DBMS_SQL.PARSE(c => l_theCursor,
1640: statement => p_sql,
1641: language_flag => DBMS_SQL.NATIVE);
1642:
1643: -- -------------------------------------------------------------------------------

Line 1641: language_flag => DBMS_SQL.NATIVE);

1637: l_theCursor := DBMS_SQL.OPEN_CURSOR;
1638:
1639: DBMS_SQL.PARSE(c => l_theCursor,
1640: statement => p_sql,
1641: language_flag => DBMS_SQL.NATIVE);
1642:
1643: -- -------------------------------------------------------------------------------
1644: -- Bind the bind variables.
1645: -- -------------------------------------------------------------------------------

Line 1647: DBMS_SQL.BIND_VARIABLE(l_theCursor, ':bv' || i, p_bind_var_tbl(i));

1643: -- -------------------------------------------------------------------------------
1644: -- Bind the bind variables.
1645: -- -------------------------------------------------------------------------------
1646: FOR i IN 1..p_bind_var_tbl.COUNT LOOP
1647: DBMS_SQL.BIND_VARIABLE(l_theCursor, ':bv' || i, p_bind_var_tbl(i));
1648: END LOOP;
1649:
1650: -- -------------------------------------------------------------------------------
1651: -- Define output columns

Line 1653: DBMS_SQL.DEFINE_COLUMN(c => l_theCursor,

1649:
1650: -- -------------------------------------------------------------------------------
1651: -- Define output columns
1652: -- -------------------------------------------------------------------------------
1653: DBMS_SQL.DEFINE_COLUMN(c => l_theCursor,
1654: position => 1,
1655: column => l_column_party_id);
1656:
1657: DBMS_SQL.DEFINE_COLUMN(c => l_theCursor,

Line 1657: DBMS_SQL.DEFINE_COLUMN(c => l_theCursor,

1653: DBMS_SQL.DEFINE_COLUMN(c => l_theCursor,
1654: position => 1,
1655: column => l_column_party_id);
1656:
1657: DBMS_SQL.DEFINE_COLUMN(c => l_theCursor,
1658: position => 2,
1659: column => l_column_rank);
1660:
1661: -- -------------------------------------------------------------------------------

Line 1664: l_status := DBMS_SQL.EXECUTE(l_theCursor);

1660:
1661: -- -------------------------------------------------------------------------------
1662: -- Execute the dynamic SQL
1663: -- -------------------------------------------------------------------------------
1664: l_status := DBMS_SQL.EXECUTE(l_theCursor);
1665:
1666:
1667: -- -------------------------------------------------------------------------------
1668: -- Process SQL output row by row

Line 1670: WHILE (DBMS_SQL.FETCH_ROWS(c => l_theCursor) > 0) LOOP

1666:
1667: -- -------------------------------------------------------------------------------
1668: -- Process SQL output row by row
1669: -- -------------------------------------------------------------------------------
1670: WHILE (DBMS_SQL.FETCH_ROWS(c => l_theCursor) > 0) LOOP
1671: DBMS_SQL.COLUMN_VALUE(c => l_theCursor,
1672: position => 1,
1673: value => partner_id);
1674:

Line 1671: DBMS_SQL.COLUMN_VALUE(c => l_theCursor,

1667: -- -------------------------------------------------------------------------------
1668: -- Process SQL output row by row
1669: -- -------------------------------------------------------------------------------
1670: WHILE (DBMS_SQL.FETCH_ROWS(c => l_theCursor) > 0) LOOP
1671: DBMS_SQL.COLUMN_VALUE(c => l_theCursor,
1672: position => 1,
1673: value => partner_id);
1674:
1675: DBMS_SQL.COLUMN_VALUE(c => l_theCursor,

Line 1675: DBMS_SQL.COLUMN_VALUE(c => l_theCursor,

1671: DBMS_SQL.COLUMN_VALUE(c => l_theCursor,
1672: position => 1,
1673: value => partner_id);
1674:
1675: DBMS_SQL.COLUMN_VALUE(c => l_theCursor,
1676: position => 2,
1677: value => l_rank_base_2);
1678:
1679:

Line 1865: DBMS_SQL.CLOSE_CURSOR(c => l_theCursor);

1861:
1862:
1863: END LOOP;
1864:
1865: DBMS_SQL.CLOSE_CURSOR(c => l_theCursor);
1866: -- ====================================================================================
1867: -- ====================================================================================
1868: -- End of processing the dynamic SQL for retrieving matching partners.
1869: -- ====================================================================================