eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_FLEX_INSERT_PKG dependencies on DBMS_SQL

Line 848: cur_glcc := dbms_sql.open_cursor;

844: -- ========================= FND LOG ===========================
845: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_glcc -> ' || sql_glcc);
846: -- ========================= FND LOG ===========================
847:
848: cur_glcc := dbms_sql.open_cursor;
849: dbms_sql.parse(cur_glcc, sql_glcc, dbms_sql.v7);
850:
851: -- ========================= FND LOG ===========================
852: psa_utils.debug_other_string(g_state_level,l_full_path,' BIND PARAMETERS');

Line 849: dbms_sql.parse(cur_glcc, sql_glcc, dbms_sql.v7);

845: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_glcc -> ' || sql_glcc);
846: -- ========================= FND LOG ===========================
847:
848: cur_glcc := dbms_sql.open_cursor;
849: dbms_sql.parse(cur_glcc, sql_glcc, dbms_sql.v7);
850:
851: -- ========================= FND LOG ===========================
852: psa_utils.debug_other_string(g_state_level,l_full_path,' BIND PARAMETERS');
853: psa_utils.debug_other_string(g_state_level,l_full_path,' ccid -> ' || ccid);

Line 856: dbms_sql.bind_variable(cur_glcc, ':ccid', ccid);

852: psa_utils.debug_other_string(g_state_level,l_full_path,' BIND PARAMETERS');
853: psa_utils.debug_other_string(g_state_level,l_full_path,' ccid -> ' || ccid);
854: -- ========================= FND LOG ===========================
855:
856: dbms_sql.bind_variable(cur_glcc, ':ccid', ccid);
857:
858: dbms_sql.define_column(cur_glcc, 1, coaid);
859: dbms_sql.define_column(cur_glcc, 2, db_allowed_flag, 1);
860: dbms_sql.define_column(cur_glcc, 3, account_type, 1);

Line 858: dbms_sql.define_column(cur_glcc, 1, coaid);

854: -- ========================= FND LOG ===========================
855:
856: dbms_sql.bind_variable(cur_glcc, ':ccid', ccid);
857:
858: dbms_sql.define_column(cur_glcc, 1, coaid);
859: dbms_sql.define_column(cur_glcc, 2, db_allowed_flag, 1);
860: dbms_sql.define_column(cur_glcc, 3, account_type, 1);
861:
862: for i in 1..30 loop

Line 859: dbms_sql.define_column(cur_glcc, 2, db_allowed_flag, 1);

855:
856: dbms_sql.bind_variable(cur_glcc, ':ccid', ccid);
857:
858: dbms_sql.define_column(cur_glcc, 1, coaid);
859: dbms_sql.define_column(cur_glcc, 2, db_allowed_flag, 1);
860: dbms_sql.define_column(cur_glcc, 3, account_type, 1);
861:
862: for i in 1..30 loop
863: dbms_sql.define_column(cur_glcc, i + 3, 'segment' || i , 25);

Line 860: dbms_sql.define_column(cur_glcc, 3, account_type, 1);

856: dbms_sql.bind_variable(cur_glcc, ':ccid', ccid);
857:
858: dbms_sql.define_column(cur_glcc, 1, coaid);
859: dbms_sql.define_column(cur_glcc, 2, db_allowed_flag, 1);
860: dbms_sql.define_column(cur_glcc, 3, account_type, 1);
861:
862: for i in 1..30 loop
863: dbms_sql.define_column(cur_glcc, i + 3, 'segment' || i , 25);
864: end loop;

Line 863: dbms_sql.define_column(cur_glcc, i + 3, 'segment' || i , 25);

859: dbms_sql.define_column(cur_glcc, 2, db_allowed_flag, 1);
860: dbms_sql.define_column(cur_glcc, 3, account_type, 1);
861:
862: for i in 1..30 loop
863: dbms_sql.define_column(cur_glcc, i + 3, 'segment' || i , 25);
864: end loop;
865:
866: ignore := dbms_sql.execute(cur_glcc);
867:

Line 866: ignore := dbms_sql.execute(cur_glcc);

862: for i in 1..30 loop
863: dbms_sql.define_column(cur_glcc, i + 3, 'segment' || i , 25);
864: end loop;
865:
866: ignore := dbms_sql.execute(cur_glcc);
867:
868: -- ========================= FND LOG ===========================
869: psa_utils.debug_other_string(g_state_level,l_full_path,' ignore -> ' || ignore);
870: -- ========================= FND LOG ===========================

Line 878: if dbms_sql.fetch_rows(cur_glcc) = 0 then

874: -- ========================= FND LOG ===========================
875: psa_utils.debug_other_string(g_state_level,l_full_path,' start loop');
876: -- ========================= FND LOG ===========================
877:
878: if dbms_sql.fetch_rows(cur_glcc) = 0 then
879: -- ========================= FND LOG ===========================
880: psa_utils.debug_other_string(g_state_level,l_full_path,' exit');
881: -- ========================= FND LOG ===========================
882: exit;

Line 885: dbms_sql.column_value(cur_glcc, 1, coaid);

881: -- ========================= FND LOG ===========================
882: exit;
883: end if;
884:
885: dbms_sql.column_value(cur_glcc, 1, coaid);
886: dbms_sql.column_value(cur_glcc, 2, db_allowed_flag);
887: dbms_sql.column_value(cur_glcc, 3, account_type);
888:
889: for i in 1..30 loop

Line 886: dbms_sql.column_value(cur_glcc, 2, db_allowed_flag);

882: exit;
883: end if;
884:
885: dbms_sql.column_value(cur_glcc, 1, coaid);
886: dbms_sql.column_value(cur_glcc, 2, db_allowed_flag);
887: dbms_sql.column_value(cur_glcc, 3, account_type);
888:
889: for i in 1..30 loop
890: dbms_sql.column_value(cur_glcc, i + 3, seg_val(i));

Line 887: dbms_sql.column_value(cur_glcc, 3, account_type);

883: end if;
884:
885: dbms_sql.column_value(cur_glcc, 1, coaid);
886: dbms_sql.column_value(cur_glcc, 2, db_allowed_flag);
887: dbms_sql.column_value(cur_glcc, 3, account_type);
888:
889: for i in 1..30 loop
890: dbms_sql.column_value(cur_glcc, i + 3, seg_val(i));
891: -- ========================= FND LOG ===========================

Line 890: dbms_sql.column_value(cur_glcc, i + 3, seg_val(i));

886: dbms_sql.column_value(cur_glcc, 2, db_allowed_flag);
887: dbms_sql.column_value(cur_glcc, 3, account_type);
888:
889: for i in 1..30 loop
890: dbms_sql.column_value(cur_glcc, i + 3, seg_val(i));
891: -- ========================= FND LOG ===========================
892: psa_utils.debug_other_string(g_state_level,l_full_path,' seg_val(' || i || ') -> ' || seg_val(i));
893: -- ========================= FND LOG ===========================
894: end loop;

Line 902: dbms_sql.close_cursor(cur_glcc);

898: -- ========================= FND LOG ===========================
899:
900: end loop;
901:
902: dbms_sql.close_cursor(cur_glcc);
903:
904: -- ========================= FND LOG ===========================
905: psa_utils.debug_other_string(g_state_level,l_full_path,' account_type -> ' || account_type);
906: -- ========================= FND LOG ===========================

Line 925: if dbms_sql.is_open(cur_glcc) then

921: <>
922: -- ========================= FND LOG ===========================
923: psa_utils.debug_other_string(g_state_level,l_full_path,' LABEL - return_invalid');
924: -- ========================= FND LOG ===========================
925: if dbms_sql.is_open(cur_glcc) then
926: dbms_sql.close_cursor(cur_glcc);
927: end if;
928:
929: -- ========================= FND LOG ===========================

Line 926: dbms_sql.close_cursor(cur_glcc);

922: -- ========================= FND LOG ===========================
923: psa_utils.debug_other_string(g_state_level,l_full_path,' LABEL - return_invalid');
924: -- ========================= FND LOG ===========================
925: if dbms_sql.is_open(cur_glcc) then
926: dbms_sql.close_cursor(cur_glcc);
927: end if;
928:
929: -- ========================= FND LOG ===========================
930: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN -> FALSE');

Line 940: if dbms_sql.is_open(cur_glcc) then

936: EXCEPTION
937:
938: WHEN OTHERS THEN
939:
940: if dbms_sql.is_open(cur_glcc) then
941: dbms_sql.close_cursor(cur_glcc);
942: end if;
943:
944: message_token('MSG', 'glfini() exception:' || SQLERRM);

Line 941: dbms_sql.close_cursor(cur_glcc);

937:
938: WHEN OTHERS THEN
939:
940: if dbms_sql.is_open(cur_glcc) then
941: dbms_sql.close_cursor(cur_glcc);
942: end if;
943:
944: message_token('MSG', 'glfini() exception:' || SQLERRM);
945: add_message('FND', 'FLEX-SSV EXCEPTION');

Line 1610: cur_stmp := dbms_sql.open_cursor;

1606: end loop;
1607:
1608: -- ========================= FND LOG ===========================
1609:
1610: cur_stmp := dbms_sql.open_cursor;
1611: dbms_sql.parse(cur_stmp, sql_stmp, dbms_sql.v7);
1612:
1613: -- ========================= FND LOG ===========================
1614: -- psa_utils.debug_other_string(g_state_level,l_full_path,' BIND PARAMETERS');

Line 1611: dbms_sql.parse(cur_stmp, sql_stmp, dbms_sql.v7);

1607:
1608: -- ========================= FND LOG ===========================
1609:
1610: cur_stmp := dbms_sql.open_cursor;
1611: dbms_sql.parse(cur_stmp, sql_stmp, dbms_sql.v7);
1612:
1613: -- ========================= FND LOG ===========================
1614: -- psa_utils.debug_other_string(g_state_level,l_full_path,' BIND PARAMETERS');
1615: -- psa_utils.debug_other_string(g_state_level,l_full_path,' coaid -> ' || coaid);

Line 1624: dbms_sql.bind_variable(cur_stmp, ':coaid', coaid);

1620: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp acct_category -> ' || acct_category);
1621: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp ccid -> ' || ccid);
1622: -- ========================= FND LOG ===========================
1623:
1624: dbms_sql.bind_variable(cur_stmp, ':coaid', coaid);
1625: dbms_sql.bind_variable(cur_stmp, ':catg', acct_category);
1626: dbms_sql.bind_variable(cur_stmp, ':ccid', ccid);
1627:
1628: dbms_sql.define_column(cur_stmp, 1, template_name, 50);

Line 1625: dbms_sql.bind_variable(cur_stmp, ':catg', acct_category);

1621: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp ccid -> ' || ccid);
1622: -- ========================= FND LOG ===========================
1623:
1624: dbms_sql.bind_variable(cur_stmp, ':coaid', coaid);
1625: dbms_sql.bind_variable(cur_stmp, ':catg', acct_category);
1626: dbms_sql.bind_variable(cur_stmp, ':ccid', ccid);
1627:
1628: dbms_sql.define_column(cur_stmp, 1, template_name, 50);
1629: dbms_sql.define_column(cur_stmp, 2, template_id);

Line 1626: dbms_sql.bind_variable(cur_stmp, ':ccid', ccid);

1622: -- ========================= FND LOG ===========================
1623:
1624: dbms_sql.bind_variable(cur_stmp, ':coaid', coaid);
1625: dbms_sql.bind_variable(cur_stmp, ':catg', acct_category);
1626: dbms_sql.bind_variable(cur_stmp, ':ccid', ccid);
1627:
1628: dbms_sql.define_column(cur_stmp, 1, template_name, 50);
1629: dbms_sql.define_column(cur_stmp, 2, template_id);
1630: dbms_sql.define_column(cur_stmp, 3, lgr_id);

Line 1628: dbms_sql.define_column(cur_stmp, 1, template_name, 50);

1624: dbms_sql.bind_variable(cur_stmp, ':coaid', coaid);
1625: dbms_sql.bind_variable(cur_stmp, ':catg', acct_category);
1626: dbms_sql.bind_variable(cur_stmp, ':ccid', ccid);
1627:
1628: dbms_sql.define_column(cur_stmp, 1, template_name, 50);
1629: dbms_sql.define_column(cur_stmp, 2, template_id);
1630: dbms_sql.define_column(cur_stmp, 3, lgr_id);
1631:
1632: for i in 1..30 loop

Line 1629: dbms_sql.define_column(cur_stmp, 2, template_id);

1625: dbms_sql.bind_variable(cur_stmp, ':catg', acct_category);
1626: dbms_sql.bind_variable(cur_stmp, ':ccid', ccid);
1627:
1628: dbms_sql.define_column(cur_stmp, 1, template_name, 50);
1629: dbms_sql.define_column(cur_stmp, 2, template_id);
1630: dbms_sql.define_column(cur_stmp, 3, lgr_id);
1631:
1632: for i in 1..30 loop
1633: dbms_sql.define_column(cur_stmp, i + 3, 'segment' || i || '_' ||

Line 1630: dbms_sql.define_column(cur_stmp, 3, lgr_id);

1626: dbms_sql.bind_variable(cur_stmp, ':ccid', ccid);
1627:
1628: dbms_sql.define_column(cur_stmp, 1, template_name, 50);
1629: dbms_sql.define_column(cur_stmp, 2, template_id);
1630: dbms_sql.define_column(cur_stmp, 3, lgr_id);
1631:
1632: for i in 1..30 loop
1633: dbms_sql.define_column(cur_stmp, i + 3, 'segment' || i || '_' ||
1634: 'type', 25);

Line 1633: dbms_sql.define_column(cur_stmp, i + 3, 'segment' || i || '_' ||

1629: dbms_sql.define_column(cur_stmp, 2, template_id);
1630: dbms_sql.define_column(cur_stmp, 3, lgr_id);
1631:
1632: for i in 1..30 loop
1633: dbms_sql.define_column(cur_stmp, i + 3, 'segment' || i || '_' ||
1634: 'type', 25);
1635: end loop;
1636:
1637: ignore := dbms_sql.execute(cur_stmp);

Line 1637: ignore := dbms_sql.execute(cur_stmp);

1633: dbms_sql.define_column(cur_stmp, i + 3, 'segment' || i || '_' ||
1634: 'type', 25);
1635: end loop;
1636:
1637: ignore := dbms_sql.execute(cur_stmp);
1638: sql_stmp_count := 0;
1639: -- ========================= FND LOG ===========================
1640: psa_utils.debug_other_string(g_state_level,l_full_path,' ignore ->' || ignore);
1641: -- ========================= FND LOG ===========================

Line 1648: test_value := dbms_sql.fetch_rows(cur_stmp);

1644:
1645: -- ========================= FND LOG ===========================
1646: psa_utils.debug_other_string(g_state_level,l_full_path,' start loop');
1647: -- ========================= FND LOG ===========================
1648: test_value := dbms_sql.fetch_rows(cur_stmp);
1649: -- ========================= FND LOG ===========================
1650: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp test_value -> ' || test_value);
1651: -- ========================= FND LOG ===========================
1652: -- if dbms_sql.fetch_rows(cur_stmp) > 0 then

Line 1652: -- if dbms_sql.fetch_rows(cur_stmp) > 0 then

1648: test_value := dbms_sql.fetch_rows(cur_stmp);
1649: -- ========================= FND LOG ===========================
1650: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp test_value -> ' || test_value);
1651: -- ========================= FND LOG ===========================
1652: -- if dbms_sql.fetch_rows(cur_stmp) > 0 then
1653: if test_value > 0 then
1654: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp -> here1');
1655: sql_stmp_count := sql_stmp_count + 1;
1656:

Line 1686: dbms_sql.column_value(cur_stmp, 1, template_name);

1682: for i in 1..30 loop
1683: seg_type(i) := null;
1684: end loop;
1685:
1686: dbms_sql.column_value(cur_stmp, 1, template_name);
1687: dbms_sql.column_value(cur_stmp, 2, template_id);
1688: dbms_sql.column_value(cur_stmp, 3, lgr_id);
1689:
1690: -- ========================= FND LOG ===========================

Line 1687: dbms_sql.column_value(cur_stmp, 2, template_id);

1683: seg_type(i) := null;
1684: end loop;
1685:
1686: dbms_sql.column_value(cur_stmp, 1, template_name);
1687: dbms_sql.column_value(cur_stmp, 2, template_id);
1688: dbms_sql.column_value(cur_stmp, 3, lgr_id);
1689:
1690: -- ========================= FND LOG ===========================
1691: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp Template name -> ' || template_name);

Line 1688: dbms_sql.column_value(cur_stmp, 3, lgr_id);

1684: end loop;
1685:
1686: dbms_sql.column_value(cur_stmp, 1, template_name);
1687: dbms_sql.column_value(cur_stmp, 2, template_id);
1688: dbms_sql.column_value(cur_stmp, 3, lgr_id);
1689:
1690: -- ========================= FND LOG ===========================
1691: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp Template name -> ' || template_name);
1692: -- ========================= FND LOG ===========================

Line 1694: dbms_sql.column_value(cur_stmp, i + 3, seg_type(i));

1690: -- ========================= FND LOG ===========================
1691: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp Template name -> ' || template_name);
1692: -- ========================= FND LOG ===========================
1693: for i in 1..30 loop
1694: dbms_sql.column_value(cur_stmp, i + 3, seg_type(i));
1695: end loop;
1696:
1697: -- ========================= FND LOG ===========================
1698: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1771: --num_templates := dbms_sql.last_row_count;

1767: -- ========================= FND LOG ===========================
1768:
1769: end loop;
1770:
1771: --num_templates := dbms_sql.last_row_count;
1772: num_templates := sql_stmp_count;
1773:
1774: -- ========================= FND LOG ===========================
1775: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp: num_templates -> '|| num_templates);

Line 1778: dbms_sql.close_cursor(cur_stmp);

1774: -- ========================= FND LOG ===========================
1775: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_stmp: num_templates -> '|| num_templates);
1776: -- ========================= FND LOG ===========================
1777:
1778: dbms_sql.close_cursor(cur_stmp);
1779:
1780: -- ========================= FND LOG ===========================
1781: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN -> TRUE');
1782: -- ========================= FND LOG ===========================

Line 1791: if dbms_sql.is_open(cur_stmp) then

1787: -- ========================= FND LOG ===========================
1788: psa_utils.debug_other_string(g_state_level,l_full_path,' LABEL - return_valid');
1789: -- ========================= FND LOG ===========================
1790:
1791: if dbms_sql.is_open(cur_stmp) then
1792: dbms_sql.close_cursor(cur_stmp);
1793: end if;
1794:
1795: -- ========================= FND LOG ===========================

Line 1792: dbms_sql.close_cursor(cur_stmp);

1788: psa_utils.debug_other_string(g_state_level,l_full_path,' LABEL - return_valid');
1789: -- ========================= FND LOG ===========================
1790:
1791: if dbms_sql.is_open(cur_stmp) then
1792: dbms_sql.close_cursor(cur_stmp);
1793: end if;
1794:
1795: -- ========================= FND LOG ===========================
1796: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN -> FALSE');

Line 1806: if dbms_sql.is_open(cur_stmp) then

1802: EXCEPTION
1803:
1804: WHEN OTHERS THEN
1805:
1806: if dbms_sql.is_open(cur_stmp) then
1807: dbms_sql.close_cursor(cur_stmp);
1808: end if;
1809:
1810: -- Dynamic SQL Exception

Line 1807: dbms_sql.close_cursor(cur_stmp);

1803:
1804: WHEN OTHERS THEN
1805:
1806: if dbms_sql.is_open(cur_stmp) then
1807: dbms_sql.close_cursor(cur_stmp);
1808: end if;
1809:
1810: -- Dynamic SQL Exception
1811:

Line 3158: cur_inscc := dbms_sql.open_cursor;

3154: -- ========================= FND LOG ===========================
3155: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_inscc -> ' || sql_inscc);
3156: -- ========================= FND LOG ===========================
3157:
3158: cur_inscc := dbms_sql.open_cursor;
3159: dbms_sql.parse(cur_inscc, sql_inscc, dbms_sql.v7);
3160:
3161: dbms_sql.bind_variable(cur_inscc, ':user_id', user_id);
3162: dbms_sql.bind_variable(cur_inscc, ':coaid', coaid);

Line 3159: dbms_sql.parse(cur_inscc, sql_inscc, dbms_sql.v7);

3155: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_inscc -> ' || sql_inscc);
3156: -- ========================= FND LOG ===========================
3157:
3158: cur_inscc := dbms_sql.open_cursor;
3159: dbms_sql.parse(cur_inscc, sql_inscc, dbms_sql.v7);
3160:
3161: dbms_sql.bind_variable(cur_inscc, ':user_id', user_id);
3162: dbms_sql.bind_variable(cur_inscc, ':coaid', coaid);
3163: dbms_sql.bind_variable(cur_inscc, ':grp_id', dyn_grp_id);

Line 3161: dbms_sql.bind_variable(cur_inscc, ':user_id', user_id);

3157:
3158: cur_inscc := dbms_sql.open_cursor;
3159: dbms_sql.parse(cur_inscc, sql_inscc, dbms_sql.v7);
3160:
3161: dbms_sql.bind_variable(cur_inscc, ':user_id', user_id);
3162: dbms_sql.bind_variable(cur_inscc, ':coaid', coaid);
3163: dbms_sql.bind_variable(cur_inscc, ':grp_id', dyn_grp_id);
3164: dbms_sql.bind_variable(cur_inscc, ':min_ccid', min_ccid);
3165:

Line 3162: dbms_sql.bind_variable(cur_inscc, ':coaid', coaid);

3158: cur_inscc := dbms_sql.open_cursor;
3159: dbms_sql.parse(cur_inscc, sql_inscc, dbms_sql.v7);
3160:
3161: dbms_sql.bind_variable(cur_inscc, ':user_id', user_id);
3162: dbms_sql.bind_variable(cur_inscc, ':coaid', coaid);
3163: dbms_sql.bind_variable(cur_inscc, ':grp_id', dyn_grp_id);
3164: dbms_sql.bind_variable(cur_inscc, ':min_ccid', min_ccid);
3165:
3166: -- ========================= FND LOG ===========================

Line 3163: dbms_sql.bind_variable(cur_inscc, ':grp_id', dyn_grp_id);

3159: dbms_sql.parse(cur_inscc, sql_inscc, dbms_sql.v7);
3160:
3161: dbms_sql.bind_variable(cur_inscc, ':user_id', user_id);
3162: dbms_sql.bind_variable(cur_inscc, ':coaid', coaid);
3163: dbms_sql.bind_variable(cur_inscc, ':grp_id', dyn_grp_id);
3164: dbms_sql.bind_variable(cur_inscc, ':min_ccid', min_ccid);
3165:
3166: -- ========================= FND LOG ===========================
3167: psa_utils.debug_other_string(g_state_level,l_full_path,' user_id -> ' || user_id);

Line 3164: dbms_sql.bind_variable(cur_inscc, ':min_ccid', min_ccid);

3160:
3161: dbms_sql.bind_variable(cur_inscc, ':user_id', user_id);
3162: dbms_sql.bind_variable(cur_inscc, ':coaid', coaid);
3163: dbms_sql.bind_variable(cur_inscc, ':grp_id', dyn_grp_id);
3164: dbms_sql.bind_variable(cur_inscc, ':min_ccid', min_ccid);
3165:
3166: -- ========================= FND LOG ===========================
3167: psa_utils.debug_other_string(g_state_level,l_full_path,' user_id -> ' || user_id);
3168: psa_utils.debug_other_string(g_state_level,l_full_path,' coaid -> ' || coaid);

Line 3173: num_rows := dbms_sql.execute(cur_inscc);

3169: psa_utils.debug_other_string(g_state_level,l_full_path,' dyn_grp_id -> ' || dyn_grp_id);
3170: psa_utils.debug_other_string(g_state_level,l_full_path,' min_ccid -> ' || min_ccid);
3171: -- ========================= FND LOG ===========================
3172:
3173: num_rows := dbms_sql.execute(cur_inscc);
3174:
3175: -- ========================= FND LOG ===========================
3176: psa_utils.debug_other_string(g_state_level,l_full_path,' num_rows -> ' || num_rows);
3177: -- ========================= FND LOG ===========================

Line 3179: dbms_sql.close_cursor(cur_inscc);

3175: -- ========================= FND LOG ===========================
3176: psa_utils.debug_other_string(g_state_level,l_full_path,' num_rows -> ' || num_rows);
3177: -- ========================= FND LOG ===========================
3178:
3179: dbms_sql.close_cursor(cur_inscc);
3180:
3181:
3182: -- Call API to update account types of the summary accounts
3183: BEGIN

Line 3228: if dbms_sql.is_open(cur_inscc) then

3224: EXCEPTION
3225:
3226: WHEN OTHERS THEN
3227:
3228: if dbms_sql.is_open(cur_inscc) then
3229: dbms_sql.close_cursor(cur_inscc);
3230: end if;
3231:
3232: -- Dynamic SQL Exception

Line 3229: dbms_sql.close_cursor(cur_inscc);

3225:
3226: WHEN OTHERS THEN
3227:
3228: if dbms_sql.is_open(cur_inscc) then
3229: dbms_sql.close_cursor(cur_inscc);
3230: end if;
3231:
3232: -- Dynamic SQL Exception
3233:

Line 3308: cur_acchy := dbms_sql.open_cursor;

3304: -- ========================= FND LOG ===========================
3305: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_acchy -> ' || sql_acchy);
3306: -- ========================= FND LOG ===========================
3307:
3308: cur_acchy := dbms_sql.open_cursor;
3309: dbms_sql.parse(cur_acchy, sql_acchy, dbms_sql.v7);
3310:
3311: dbms_sql.bind_variable(cur_acchy, ':ccid', ccid);
3312: dbms_sql.bind_variable(cur_acchy, ':user_id', user_id);

Line 3309: dbms_sql.parse(cur_acchy, sql_acchy, dbms_sql.v7);

3305: psa_utils.debug_other_string(g_state_level,l_full_path,' sql_acchy -> ' || sql_acchy);
3306: -- ========================= FND LOG ===========================
3307:
3308: cur_acchy := dbms_sql.open_cursor;
3309: dbms_sql.parse(cur_acchy, sql_acchy, dbms_sql.v7);
3310:
3311: dbms_sql.bind_variable(cur_acchy, ':ccid', ccid);
3312: dbms_sql.bind_variable(cur_acchy, ':user_id', user_id);
3313: dbms_sql.bind_variable(cur_acchy, ':ordering_value',

Line 3311: dbms_sql.bind_variable(cur_acchy, ':ccid', ccid);

3307:
3308: cur_acchy := dbms_sql.open_cursor;
3309: dbms_sql.parse(cur_acchy, sql_acchy, dbms_sql.v7);
3310:
3311: dbms_sql.bind_variable(cur_acchy, ':ccid', ccid);
3312: dbms_sql.bind_variable(cur_acchy, ':user_id', user_id);
3313: dbms_sql.bind_variable(cur_acchy, ':ordering_value',
3314: seg_val(acct_seg_index));
3315: dbms_sql.bind_variable(cur_acchy, ':grp_id', dyn_grp_id);

Line 3312: dbms_sql.bind_variable(cur_acchy, ':user_id', user_id);

3308: cur_acchy := dbms_sql.open_cursor;
3309: dbms_sql.parse(cur_acchy, sql_acchy, dbms_sql.v7);
3310:
3311: dbms_sql.bind_variable(cur_acchy, ':ccid', ccid);
3312: dbms_sql.bind_variable(cur_acchy, ':user_id', user_id);
3313: dbms_sql.bind_variable(cur_acchy, ':ordering_value',
3314: seg_val(acct_seg_index));
3315: dbms_sql.bind_variable(cur_acchy, ':grp_id', dyn_grp_id);
3316:

Line 3313: dbms_sql.bind_variable(cur_acchy, ':ordering_value',

3309: dbms_sql.parse(cur_acchy, sql_acchy, dbms_sql.v7);
3310:
3311: dbms_sql.bind_variable(cur_acchy, ':ccid', ccid);
3312: dbms_sql.bind_variable(cur_acchy, ':user_id', user_id);
3313: dbms_sql.bind_variable(cur_acchy, ':ordering_value',
3314: seg_val(acct_seg_index));
3315: dbms_sql.bind_variable(cur_acchy, ':grp_id', dyn_grp_id);
3316:
3317: -- ========================= FND LOG ===========================

Line 3315: dbms_sql.bind_variable(cur_acchy, ':grp_id', dyn_grp_id);

3311: dbms_sql.bind_variable(cur_acchy, ':ccid', ccid);
3312: dbms_sql.bind_variable(cur_acchy, ':user_id', user_id);
3313: dbms_sql.bind_variable(cur_acchy, ':ordering_value',
3314: seg_val(acct_seg_index));
3315: dbms_sql.bind_variable(cur_acchy, ':grp_id', dyn_grp_id);
3316:
3317: -- ========================= FND LOG ===========================
3318: psa_utils.debug_other_string(g_state_level,l_full_path,' ccid -> ' || ccid);
3319: psa_utils.debug_other_string(g_state_level,l_full_path,' user_id -> ' || user_id);

Line 3323: num_rows := dbms_sql.execute(cur_acchy);

3319: psa_utils.debug_other_string(g_state_level,l_full_path,' user_id -> ' || user_id);
3320: psa_utils.debug_other_string(g_state_level,l_full_path,' dyn_grp_id -> ' || dyn_grp_id);
3321: -- ========================= FND LOG ===========================
3322:
3323: num_rows := dbms_sql.execute(cur_acchy);
3324:
3325: -- ========================= FND LOG ===========================
3326: psa_utils.debug_other_string(g_state_level,l_full_path,' num_rows -> ' || num_rows);
3327: -- ========================= FND LOG ===========================

Line 3329: dbms_sql.close_cursor(cur_acchy);

3325: -- ========================= FND LOG ===========================
3326: psa_utils.debug_other_string(g_state_level,l_full_path,' num_rows -> ' || num_rows);
3327: -- ========================= FND LOG ===========================
3328:
3329: dbms_sql.close_cursor(cur_acchy);
3330:
3331: -- ========================= FND LOG ===========================
3332: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN -> TRUE');
3333: -- ========================= FND LOG ===========================

Line 3342: if dbms_sql.is_open(cur_acchy) then

3338: EXCEPTION
3339:
3340: WHEN OTHERS THEN
3341:
3342: if dbms_sql.is_open(cur_acchy) then
3343: dbms_sql.close_cursor(cur_acchy);
3344: end if;
3345:
3346: -- Dynamic SQL Exception

Line 3343: dbms_sql.close_cursor(cur_acchy);

3339:
3340: WHEN OTHERS THEN
3341:
3342: if dbms_sql.is_open(cur_acchy) then
3343: dbms_sql.close_cursor(cur_acchy);
3344: end if;
3345:
3346: -- Dynamic SQL Exception
3347:

Line 3786: cursornum := dbms_sql.open_cursor;

3782: nprocessed INTEGER;
3783:
3784: BEGIN
3785:
3786: cursornum := dbms_sql.open_cursor;
3787: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
3788: nprocessed := dbms_sql.execute(cursornum);
3789: dbms_sql.close_cursor(cursornum);
3790: return(nprocessed);

Line 3787: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

3783:
3784: BEGIN
3785:
3786: cursornum := dbms_sql.open_cursor;
3787: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
3788: nprocessed := dbms_sql.execute(cursornum);
3789: dbms_sql.close_cursor(cursornum);
3790: return(nprocessed);
3791:

Line 3788: nprocessed := dbms_sql.execute(cursornum);

3784: BEGIN
3785:
3786: cursornum := dbms_sql.open_cursor;
3787: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
3788: nprocessed := dbms_sql.execute(cursornum);
3789: dbms_sql.close_cursor(cursornum);
3790: return(nprocessed);
3791:
3792: EXCEPTION

Line 3789: dbms_sql.close_cursor(cursornum);

3785:
3786: cursornum := dbms_sql.open_cursor;
3787: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
3788: nprocessed := dbms_sql.execute(cursornum);
3789: dbms_sql.close_cursor(cursornum);
3790: return(nprocessed);
3791:
3792: EXCEPTION
3793:

Line 3796: if dbms_sql.is_open(cursornum) then

3792: EXCEPTION
3793:
3794: WHEN OTHERS THEN
3795:
3796: if dbms_sql.is_open(cursornum) then
3797: dbms_sql.close_cursor(cursornum);
3798: end if;
3799:
3800: -- Dynamic SQL Exception

Line 3797: dbms_sql.close_cursor(cursornum);

3793:
3794: WHEN OTHERS THEN
3795:
3796: if dbms_sql.is_open(cursornum) then
3797: dbms_sql.close_cursor(cursornum);
3798: end if;
3799:
3800: -- Dynamic SQL Exception
3801: