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.FND_OAM_DSCRAM_ARGS_PKG dependencies on DBMS_SQL

Line 332: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,

328: --fetch the value into the properly typed local variable then then
329: --convert it into the canonical
330: CASE px_arg.datatype
331: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2 THEN
332: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,
333: l_bindvar_name,
334: x_canonical_value);
335:
336: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN

Line 337: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,

333: l_bindvar_name,
334: x_canonical_value);
335:
336: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
337: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,
338: l_bindvar_name,
339: l_number);
340: x_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
341:

Line 343: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,

339: l_number);
340: x_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
341:
342: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
343: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,
344: l_bindvar_name,
345: l_date);
346: x_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
347:

Line 349: DBMS_SQL.VARIABLE_VALUE_ROWID(p_execution_cursor_id,

345: l_date);
346: x_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
347:
348: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
349: DBMS_SQL.VARIABLE_VALUE_ROWID(p_execution_cursor_id,
350: l_bindvar_name,
351: l_rowid);
352: x_canonical_value := ROWIDTOCHAR(l_rowid);
353: ELSE

Line 439: IF NOT DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN

435: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
436: RETURN;
437: END CASE;
438: ELSIF px_arg.source_cursor_id IS NOT NULL THEN
439: IF NOT DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN
440: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), source cursor is already closed. This should not happen.';
441: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
442: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
443: RETURN;

Line 449: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,

445:
446: --bind if we have to
447: IF px_arg.source_sql_bind_rowids THEN
448: fnd_oam_debug.log(1, l_ctxt, 'Binding Rowids');
449: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,
450: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
451: p_rowid_lbound);
452: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,
453: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_UBOUND_NAME,

Line 452: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,

448: fnd_oam_debug.log(1, l_ctxt, 'Binding Rowids');
449: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,
450: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
451: p_rowid_lbound);
452: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,
453: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_UBOUND_NAME,
454: p_rowid_ubound);
455: END IF;
456:

Line 459: l_rows_fetched := DBMS_SQL.EXECUTE_AND_FETCH(px_arg.source_cursor_id);

455: END IF;
456:
457: --now execute and fetch
458: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
459: l_rows_fetched := DBMS_SQL.EXECUTE_AND_FETCH(px_arg.source_cursor_id);
460: fnd_oam_debug.log(1, l_ctxt, '...Done');
461:
462: IF l_rows_fetched <> 1 THEN
463: x_return_msg := 'Fetched '||l_rows_fetched||' rows. Args must return 1 row.';

Line 472: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,

468:
469: --now depending on the datatype, set our local canonical value
470: CASE px_arg.datatype
471: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2 THEN
472: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,
473: 1,
474: l_canonical_value);
475: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
476: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,

Line 476: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,

472: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,
473: 1,
474: l_canonical_value);
475: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
476: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,
477: 1,
478: l_number);
479: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
480: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN

Line 481: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,

477: 1,
478: l_number);
479: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
480: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
481: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,
482: 1,
483: l_date);
484: l_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
485: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN

Line 486: DBMS_SQL.COLUMN_VALUE_ROWID(px_arg.source_cursor_id,

482: 1,
483: l_date);
484: l_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
485: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
486: DBMS_SQL.COLUMN_VALUE_ROWID(px_arg.source_cursor_id,
487: 1,
488: l_rowid);
489: l_canonical_value := ROWIDTOCHAR(l_rowid);
490: ELSE

Line 620: IF px_arg.source_cursor_id IS NOT NULL AND DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN

616: -- However, to keep from querying the source_final_text in get_value later, all SQL-based sources use a cursor.
617: ELSIF FND_OAM_DSCRAM_UTILS_PKG.SOURCE_TYPE_USES_SQL(p_source_type) THEN
618:
619: --close the last cursor, shouldn't happen but it's safe
620: IF px_arg.source_cursor_id IS NOT NULL AND DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN
621: DBMS_SQL.CLOSE_CURSOR(px_arg.source_cursor_id);
622: END IF;
623:
624: --create a new cursor and parse the source_final_text into it

Line 621: DBMS_SQL.CLOSE_CURSOR(px_arg.source_cursor_id);

617: ELSIF FND_OAM_DSCRAM_UTILS_PKG.SOURCE_TYPE_USES_SQL(p_source_type) THEN
618:
619: --close the last cursor, shouldn't happen but it's safe
620: IF px_arg.source_cursor_id IS NOT NULL AND DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN
621: DBMS_SQL.CLOSE_CURSOR(px_arg.source_cursor_id);
622: END IF;
623:
624: --create a new cursor and parse the source_final_text into it
625: px_arg.source_cursor_id := DBMS_SQL.OPEN_CURSOR;

Line 625: px_arg.source_cursor_id := DBMS_SQL.OPEN_CURSOR;

621: DBMS_SQL.CLOSE_CURSOR(px_arg.source_cursor_id);
622: END IF;
623:
624: --create a new cursor and parse the source_final_text into it
625: px_arg.source_cursor_id := DBMS_SQL.OPEN_CURSOR;
626: BEGIN
627: DBMS_SQL.PARSE(px_arg.source_cursor_id,
628: p_source_final_text,
629: DBMS_SQL.NATIVE);

Line 627: DBMS_SQL.PARSE(px_arg.source_cursor_id,

623:
624: --create a new cursor and parse the source_final_text into it
625: px_arg.source_cursor_id := DBMS_SQL.OPEN_CURSOR;
626: BEGIN
627: DBMS_SQL.PARSE(px_arg.source_cursor_id,
628: p_source_final_text,
629: DBMS_SQL.NATIVE);
630: EXCEPTION
631: WHEN OTHERS THEN

Line 629: DBMS_SQL.NATIVE);

625: px_arg.source_cursor_id := DBMS_SQL.OPEN_CURSOR;
626: BEGIN
627: DBMS_SQL.PARSE(px_arg.source_cursor_id,
628: p_source_final_text,
629: DBMS_SQL.NATIVE);
630: EXCEPTION
631: WHEN OTHERS THEN
632: x_return_msg := 'ARG_ID ('||px_arg.arg_id||'), failed to parse source final text: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
633: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

Line 643: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,

639:
640: --finally, define a column with the correct output type
641: CASE px_arg.datatype
642: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2 THEN
643: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,
644: 1,
645: l_canonical_value,
646: 4000);
647: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN

Line 648: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,

644: 1,
645: l_canonical_value,
646: 4000);
647: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
648: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,
649: 1,
650: l_number);
651: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
652: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,

Line 652: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,

648: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,
649: 1,
650: l_number);
651: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
652: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,
653: 1,
654: l_date);
655: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
656: DBMS_SQL.DEFINE_COLUMN_ROWID(px_arg.source_cursor_id,

Line 656: DBMS_SQL.DEFINE_COLUMN_ROWID(px_arg.source_cursor_id,

652: DBMS_SQL.DEFINE_COLUMN(px_arg.source_cursor_id,
653: 1,
654: l_date);
655: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
656: DBMS_SQL.DEFINE_COLUMN_ROWID(px_arg.source_cursor_id,
657: 1,
658: l_rowid);
659: ELSE
660: x_return_msg := 'Unknown Arg Dataype: '||px_arg.datatype;

Line 1977: l_arg_ids dbms_sql.number_table;

1973: l_empty_arg_context arg_context;
1974: l_arg_ctxt arg_context;
1975: l_arg arg;
1976:
1977: l_arg_ids dbms_sql.number_table;
1978: l_arg_names dbms_sql.varchar2_table;
1979: l_initialized_success_flags dbms_sql.varchar2_table;
1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;

Line 1978: l_arg_names dbms_sql.varchar2_table;

1974: l_arg_ctxt arg_context;
1975: l_arg arg;
1976:
1977: l_arg_ids dbms_sql.number_table;
1978: l_arg_names dbms_sql.varchar2_table;
1979: l_initialized_success_flags dbms_sql.varchar2_table;
1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;

Line 1979: l_initialized_success_flags dbms_sql.varchar2_table;

1975: l_arg arg;
1976:
1977: l_arg_ids dbms_sql.number_table;
1978: l_arg_names dbms_sql.varchar2_table;
1979: l_initialized_success_flags dbms_sql.varchar2_table;
1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;
1983: l_write_policies dbms_sql.varchar2_table;

Line 1980: l_allow_override_source_flags dbms_sql.varchar2_table;

1976:
1977: l_arg_ids dbms_sql.number_table;
1978: l_arg_names dbms_sql.varchar2_table;
1979: l_initialized_success_flags dbms_sql.varchar2_table;
1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;
1983: l_write_policies dbms_sql.varchar2_table;
1984: l_datatypes dbms_sql.varchar2_table;

Line 1981: l_binding_enabled_flags dbms_sql.varchar2_table;

1977: l_arg_ids dbms_sql.number_table;
1978: l_arg_names dbms_sql.varchar2_table;
1979: l_initialized_success_flags dbms_sql.varchar2_table;
1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;
1983: l_write_policies dbms_sql.varchar2_table;
1984: l_datatypes dbms_sql.varchar2_table;
1985: l_valid_value_flags dbms_sql.varchar2_table;

Line 1982: l_permissions dbms_sql.varchar2_table;

1978: l_arg_names dbms_sql.varchar2_table;
1979: l_initialized_success_flags dbms_sql.varchar2_table;
1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;
1983: l_write_policies dbms_sql.varchar2_table;
1984: l_datatypes dbms_sql.varchar2_table;
1985: l_valid_value_flags dbms_sql.varchar2_table;
1986: l_canonical_values long_varchar2_table;

Line 1983: l_write_policies dbms_sql.varchar2_table;

1979: l_initialized_success_flags dbms_sql.varchar2_table;
1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;
1983: l_write_policies dbms_sql.varchar2_table;
1984: l_datatypes dbms_sql.varchar2_table;
1985: l_valid_value_flags dbms_sql.varchar2_table;
1986: l_canonical_values long_varchar2_table;
1987:

Line 1984: l_datatypes dbms_sql.varchar2_table;

1980: l_allow_override_source_flags dbms_sql.varchar2_table;
1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;
1983: l_write_policies dbms_sql.varchar2_table;
1984: l_datatypes dbms_sql.varchar2_table;
1985: l_valid_value_flags dbms_sql.varchar2_table;
1986: l_canonical_values long_varchar2_table;
1987:
1988: l_return_status VARCHAR2(6);

Line 1985: l_valid_value_flags dbms_sql.varchar2_table;

1981: l_binding_enabled_flags dbms_sql.varchar2_table;
1982: l_permissions dbms_sql.varchar2_table;
1983: l_write_policies dbms_sql.varchar2_table;
1984: l_datatypes dbms_sql.varchar2_table;
1985: l_valid_value_flags dbms_sql.varchar2_table;
1986: l_canonical_values long_varchar2_table;
1987:
1988: l_return_status VARCHAR2(6);
1989: l_return_msg VARCHAR2(2048);

Line 2075: l_arg_ids dbms_sql.number_table;

2071: l_arg_list arg_list := arg_list();
2072: l_empty_arg_list arg_list := arg_list();
2073: l_has_writable BOOLEAN := FALSE;
2074:
2075: l_arg_ids dbms_sql.number_table;
2076: l_arg_names dbms_sql.varchar2_table;
2077: l_initialized_success_flags dbms_sql.varchar2_table;
2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;

Line 2076: l_arg_names dbms_sql.varchar2_table;

2072: l_empty_arg_list arg_list := arg_list();
2073: l_has_writable BOOLEAN := FALSE;
2074:
2075: l_arg_ids dbms_sql.number_table;
2076: l_arg_names dbms_sql.varchar2_table;
2077: l_initialized_success_flags dbms_sql.varchar2_table;
2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;

Line 2077: l_initialized_success_flags dbms_sql.varchar2_table;

2073: l_has_writable BOOLEAN := FALSE;
2074:
2075: l_arg_ids dbms_sql.number_table;
2076: l_arg_names dbms_sql.varchar2_table;
2077: l_initialized_success_flags dbms_sql.varchar2_table;
2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;
2081: l_write_policies dbms_sql.varchar2_table;

Line 2078: l_allow_override_source_flags dbms_sql.varchar2_table;

2074:
2075: l_arg_ids dbms_sql.number_table;
2076: l_arg_names dbms_sql.varchar2_table;
2077: l_initialized_success_flags dbms_sql.varchar2_table;
2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;
2081: l_write_policies dbms_sql.varchar2_table;
2082: l_datatypes dbms_sql.varchar2_table;

Line 2079: l_binding_enabled_flags dbms_sql.varchar2_table;

2075: l_arg_ids dbms_sql.number_table;
2076: l_arg_names dbms_sql.varchar2_table;
2077: l_initialized_success_flags dbms_sql.varchar2_table;
2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;
2081: l_write_policies dbms_sql.varchar2_table;
2082: l_datatypes dbms_sql.varchar2_table;
2083: l_valid_value_flags dbms_sql.varchar2_table;

Line 2080: l_permissions dbms_sql.varchar2_table;

2076: l_arg_names dbms_sql.varchar2_table;
2077: l_initialized_success_flags dbms_sql.varchar2_table;
2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;
2081: l_write_policies dbms_sql.varchar2_table;
2082: l_datatypes dbms_sql.varchar2_table;
2083: l_valid_value_flags dbms_sql.varchar2_table;
2084: l_canonical_values long_varchar2_table;

Line 2081: l_write_policies dbms_sql.varchar2_table;

2077: l_initialized_success_flags dbms_sql.varchar2_table;
2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;
2081: l_write_policies dbms_sql.varchar2_table;
2082: l_datatypes dbms_sql.varchar2_table;
2083: l_valid_value_flags dbms_sql.varchar2_table;
2084: l_canonical_values long_varchar2_table;
2085:

Line 2082: l_datatypes dbms_sql.varchar2_table;

2078: l_allow_override_source_flags dbms_sql.varchar2_table;
2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;
2081: l_write_policies dbms_sql.varchar2_table;
2082: l_datatypes dbms_sql.varchar2_table;
2083: l_valid_value_flags dbms_sql.varchar2_table;
2084: l_canonical_values long_varchar2_table;
2085:
2086: k NUMBER;

Line 2083: l_valid_value_flags dbms_sql.varchar2_table;

2079: l_binding_enabled_flags dbms_sql.varchar2_table;
2080: l_permissions dbms_sql.varchar2_table;
2081: l_write_policies dbms_sql.varchar2_table;
2082: l_datatypes dbms_sql.varchar2_table;
2083: l_valid_value_flags dbms_sql.varchar2_table;
2084: l_canonical_values long_varchar2_table;
2085:
2086: k NUMBER;
2087: l_ignore BOOLEAN;

Line 2314: DBMS_SQL.BIND_VARIABLE(p_cursor_id,

2310: --even if we didn't get a value, do a binding - required for output args.
2311: BEGIN
2312: CASE p_arg_list(k).datatype
2313: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2 THEN
2314: DBMS_SQL.BIND_VARIABLE(p_cursor_id,
2315: l_bindvar_name,
2316: l_varchar2,
2317: 4000);
2318:

Line 2320: DBMS_SQL.BIND_VARIABLE(p_cursor_id,

2316: l_varchar2,
2317: 4000);
2318:
2319: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
2320: DBMS_SQL.BIND_VARIABLE(p_cursor_id,
2321: l_bindvar_name,
2322: l_number);
2323:
2324: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN

Line 2325: DBMS_SQL.BIND_VARIABLE(p_cursor_id,

2321: l_bindvar_name,
2322: l_number);
2323:
2324: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
2325: DBMS_SQL.BIND_VARIABLE(p_cursor_id,
2326: l_bindvar_name,
2327: l_date);
2328:
2329: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN

Line 2330: DBMS_SQL.BIND_VARIABLE_ROWID(p_cursor_id,

2326: l_bindvar_name,
2327: l_date);
2328:
2329: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
2330: DBMS_SQL.BIND_VARIABLE_ROWID(p_cursor_id,
2331: l_bindvar_name,
2332: l_rowid);
2333: ELSE
2334: x_return_msg := 'Arg ('||p_arg_list(k).arg_id||') has unknown datatype:'||p_arg_list(k).datatype;

Line 2578: DBMS_SQL.IS_OPEN(px_arg_list(k).source_cursor_id) THEN

2574: WHILE k IS NOT NULL LOOP
2575:
2576: --close up the cursor if it exists
2577: IF px_arg_list(k).source_cursor_id IS NOT NULL AND
2578: DBMS_SQL.IS_OPEN(px_arg_list(k).source_cursor_id) THEN
2579: DBMS_SQL.CLOSE_CURSOR(px_arg_list(k).source_cursor_id);
2580: END IF;
2581:
2582: k := px_arg_list.NEXT(k);

Line 2579: DBMS_SQL.CLOSE_CURSOR(px_arg_list(k).source_cursor_id);

2575:
2576: --close up the cursor if it exists
2577: IF px_arg_list(k).source_cursor_id IS NOT NULL AND
2578: DBMS_SQL.IS_OPEN(px_arg_list(k).source_cursor_id) THEN
2579: DBMS_SQL.CLOSE_CURSOR(px_arg_list(k).source_cursor_id);
2580: END IF;
2581:
2582: k := px_arg_list.NEXT(k);
2583: END LOOP;

Line 2640: DBMS_SQL.IS_OPEN(px_arg_context(l_s).source_cursor_id) THEN

2636: END IF;
2637:
2638: --close up the arg's cursor if it exists
2639: IF px_arg_context(l_s).source_cursor_id IS NOT NULL AND
2640: DBMS_SQL.IS_OPEN(px_arg_context(l_s).source_cursor_id) THEN
2641: DBMS_SQL.CLOSE_CURSOR(px_arg_context(l_s).source_cursor_id);
2642: END IF;
2643:
2644: l_s := px_arg_context.NEXT(l_s);

Line 2641: DBMS_SQL.CLOSE_CURSOR(px_arg_context(l_s).source_cursor_id);

2637:
2638: --close up the arg's cursor if it exists
2639: IF px_arg_context(l_s).source_cursor_id IS NOT NULL AND
2640: DBMS_SQL.IS_OPEN(px_arg_context(l_s).source_cursor_id) THEN
2641: DBMS_SQL.CLOSE_CURSOR(px_arg_context(l_s).source_cursor_id);
2642: END IF;
2643:
2644: l_s := px_arg_context.NEXT(l_s);
2645: END LOOP;