APPS.IEX_WF_DEL_CUR_STATUS_NOTE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 95

	  v_lit_sql :=   ' select l.created_by, l.litigation_id, r.SOURCE_NAME, ' ;

Line: 100

	  v_wof_sql :=   ' select l.created_by, l.writeoff_id, r.SOURCE_NAME, ' ;

Line: 105

	  v_ban_sql :=   ' select l.created_by, l.bankruptcy_id, r.SOURCE_NAME, ' ;

Line: 110

	  v_rep_sql :=   ' select l.created_by, l.repossession_id, r.SOURCE_NAME, ' ;

Line: 246

            select 'LIT_' || to_char(IEX_DEL_WF_S.Nextval)
            INTO v_itemkey
            from dual ;

Line: 332

            select 'BAN_' || to_char(IEX_DEL_WF_S.Nextval)
            INTO v_itemkey
            from dual ;

Line: 413

            select 'WRI_' || to_char(IEX_DEL_WF_S.Nextval)
            INTO v_itemkey
            from dual ;

Line: 493

            select 'REP_' || to_char(IEX_DEL_WF_S.Nextval)
            INTO v_itemkey
            from dual ;

Line: 576

                            PROCEDURE SELECT_NOTICE
    __________________________________________________________________________*/

    ----------- procedure update_approval_status  -----------------------------
    PROCEDURE select_notice(itemtype  	IN   varchar2,
                        itemkey     IN   varchar2,
                        actid       IN   number,
                        funcmode    IN   varchar2,
                        result      OUT NOCOPY  varchar2) is

        l_responder           VARCHAR2(100);

Line: 591

        l_api_name     				VARCHAR2(100) := 'select_notice';

Line: 622

              WF_CORE.Context('IEX_WF_DEL_CUR_STATUS_NOTE_PUB', 'Select Notice',
		      itemtype, itemkey, actid, funcmode);

Line: 625

    END select_notice;

Line: 627

    PROCEDURE select_resource_info(
          p_delinquency_id      IN NUMBER) IS
    BEGIN
         null;

Line: 633

            WF_CORE.Context('IEX_WF_DEL_CUR_STATUS_NOTE_PUB', 'Select Notice' );

Line: 635

    END select_resource_info;

Line: 707

        p_wf_item_NUMBER_VALUE.DELETE(2, p_wf_item_NUMBER_NAME.LAST) ;

Line: 708

        p_wf_item_TEXT_VALUE.DELETE(p_wf_item_NUMBER_NAME.FIRST, p_wf_item_NUMBER_NAME.LAST) ;

Line: 736

        SELECT DISTINCT DELINQUENCY_ID
        BULK COLLECT INTO ld_del_tbl
        From IEX_DEL_CHILDREN ;