APPS.IEX_PROMISES_BATCH_PUB dependencies on DBMS_SQL

Line 2715: l_CursorID := DBMS_SQL.OPEN_CURSOR;

2711: OPEN Get_Object_Type(p_object_type_code);
2712: FETCH Get_Object_Type INTO l_object_type,l_select_id,l_select_name,l_select_details,l_from_table,l_where_clause;
2713: if Get_Object_Type%FOUND then
2714:
2715: l_CursorID := DBMS_SQL.OPEN_CURSOR;
2716:
2717: l_SelectStmt := 'SELECT ' || l_select_name;
2718:
2719: IF (l_select_details IS NOT NULL) THEN

Line 2731: DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, 1 );

2727: END IF;
2728:
2729: l_SelectStmt := l_SelectStmt || l_select_id || ' = :source_object_id ';
2730:
2731: DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, 1 );
2732:
2733: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2734:
2735: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );

Line 2733: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);

2729: l_SelectStmt := l_SelectStmt || l_select_id || ' = :source_object_id ';
2730:
2731: DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, 1 );
2732:
2733: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2734:
2735: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );
2736: IF (l_select_details IS NOT NULL) THEN
2737: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );

Line 2735: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );

2731: DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, 1 );
2732:
2733: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2734:
2735: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );
2736: IF (l_select_details IS NOT NULL) THEN
2737: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );
2738: END IF;
2739:

Line 2737: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );

2733: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2734:
2735: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );
2736: IF (l_select_details IS NOT NULL) THEN
2737: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );
2738: END IF;
2739:
2740: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
2741:

Line 2740: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

2736: IF (l_select_details IS NOT NULL) THEN
2737: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );
2738: END IF;
2739:
2740: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
2741:
2742: LOOP
2743:
2744: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

Line 2744: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

2740: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
2741:
2742: LOOP
2743:
2744: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN
2745:
2746: EXIT;
2747:
2748: END IF;

Line 2750: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1 , l_object_name );

2746: EXIT;
2747:
2748: END IF;
2749:
2750: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1 , l_object_name );
2751: IF (l_select_details IS NOT NULL) THEN
2752: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2 , l_object_details );
2753: END IF;
2754:

Line 2752: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2 , l_object_details );

2748: END IF;
2749:
2750: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1 , l_object_name );
2751: IF (l_select_details IS NOT NULL) THEN
2752: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2 , l_object_details );
2753: END IF;
2754:
2755:
2756: END LOOP;

Line 2758: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

2754:
2755:
2756: END LOOP;
2757:
2758: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
2759: end if;
2760: CLOSE Get_Object_Type;
2761:
2762: --adding for 14738490

Line 3181: p_dels_tbl IN DBMS_SQL.NUMBER_TABLE /*table of delinquency ids*/)

3177: P_VALIDATION_LEVEL IN NUMBER,
3178: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3179: X_MSG_COUNT OUT NOCOPY NUMBER,
3180: X_MSG_DATA OUT NOCOPY VARCHAR2,
3181: p_dels_tbl IN DBMS_SQL.NUMBER_TABLE /*table of delinquency ids*/)
3182: IS
3183: l_api_name CONSTANT VARCHAR2(30) := 'REOPEN_PROMISES';
3184: l_api_version CONSTANT NUMBER := 1.0;
3185: l_return_status VARCHAR2(1);