APPS.IEX_PROMISES_BATCH_PUB dependencies on DBMS_SQL

Line 2575: l_CursorID := DBMS_SQL.OPEN_CURSOR;

2571: OPEN Get_Object_Type(p_object_type_code);
2572: FETCH Get_Object_Type INTO l_object_type,l_select_id,l_select_name,l_select_details,l_from_table,l_where_clause;
2573: if Get_Object_Type%FOUND then
2574:
2575: l_CursorID := DBMS_SQL.OPEN_CURSOR;
2576:
2577: l_SelectStmt := 'SELECT ' || l_select_name;
2578:
2579: IF (l_select_details IS NOT NULL) THEN

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

2587: END IF;
2588:
2589: l_SelectStmt := l_SelectStmt || l_select_id || ' = :source_object_id ';
2590:
2591: DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, 1 );
2592:
2593: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2594:
2595: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );

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

2589: l_SelectStmt := l_SelectStmt || l_select_id || ' = :source_object_id ';
2590:
2591: DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, 1 );
2592:
2593: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2594:
2595: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );
2596: IF (l_select_details IS NOT NULL) THEN
2597: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );

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

2591: DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, 1 );
2592:
2593: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2594:
2595: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );
2596: IF (l_select_details IS NOT NULL) THEN
2597: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );
2598: END IF;
2599:

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

2593: DBMS_SQL.BIND_VARIABLE(l_CursorID,':source_object_id',p_object_id);
2594:
2595: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1 , l_object_name , 360 );
2596: IF (l_select_details IS NOT NULL) THEN
2597: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );
2598: END IF;
2599:
2600: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
2601:

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

2596: IF (l_select_details IS NOT NULL) THEN
2597: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2 , l_object_details , 2000 );
2598: END IF;
2599:
2600: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
2601:
2602: LOOP
2603:
2604: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

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

2600: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
2601:
2602: LOOP
2603:
2604: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN
2605:
2606: EXIT;
2607:
2608: END IF;

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

2606: EXIT;
2607:
2608: END IF;
2609:
2610: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1 , l_object_name );
2611: IF (l_select_details IS NOT NULL) THEN
2612: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2 , l_object_details );
2613: END IF;
2614:

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

2608: END IF;
2609:
2610: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1 , l_object_name );
2611: IF (l_select_details IS NOT NULL) THEN
2612: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2 , l_object_details );
2613: END IF;
2614:
2615:
2616: END LOOP;

Line 2618: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

2614:
2615:
2616: END LOOP;
2617:
2618: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
2619: end if;
2620: CLOSE Get_Object_Type;
2621:
2622:

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

3000: P_VALIDATION_LEVEL IN NUMBER,
3001: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3002: X_MSG_COUNT OUT NOCOPY NUMBER,
3003: X_MSG_DATA OUT NOCOPY VARCHAR2,
3004: p_dels_tbl IN DBMS_SQL.NUMBER_TABLE /*table of delinquency ids*/)
3005: IS
3006: l_api_name CONSTANT VARCHAR2(30) := 'REOPEN_PROMISES';
3007: l_api_version CONSTANT NUMBER := 1.0;
3008: l_return_status VARCHAR2(1);