APPS.XDP_UTILITIES dependencies on XDP_PROC_BODY

Line 593: -- This procedure will insert a new row into XDP_PROC_BODY table

589:
590:
591:
592: --
593: -- This procedure will insert a new row into XDP_PROC_BODY table
594: --
595: PROCEDURE Create_New_Proc_Body(
596: p_proc_name IN VARCHAR2,
597: p_proc_type IN VARCHAR2 := 'CONNECT',

Line 610: insert into xdp_proc_body

606: error_description OUT NOCOPY VARCHAR2) IS
607: lv_lob clob;
608: BEGIN
609: return_code := 0;
610: insert into xdp_proc_body
611: (proc_name, proc_type, protected_flag, proc_spec, proc_body, creation_date, created_by, last_update_date,
612: last_updated_by, last_update_login)
613: values
614: (p_proc_name, p_proc_type, 'N', p_proc_spec, empty_clob(),

Line 627: -- This procedure will update the XDP_PROC_BODY table

623: error_description := SUBSTR(SQLERRM,1,280);
624: END Create_New_Proc_Body;
625:
626: --
627: -- This procedure will update the XDP_PROC_BODY table
628: --
629: PROCEDURE Update_Proc_Body(
630: p_proc_name IN VARCHAR2,
631: p_proc_type IN VARCHAR2 := 'CONNECT',

Line 644: update xdp_proc_body

640: lv_length number := 32767;
641: BEGIN
642: return_code := 0;
643:
644: update xdp_proc_body
645: set
646: last_update_date = p_last_update_date,
647: last_updated_by = p_last_updated_by,
648: last_update_login = p_last_update_login,

Line 677: from xdp_proc_body

673: lv_lob clob;
674:
675: CURSOR l_get_clob_value_csr IS
676: select proc_body
677: from xdp_proc_body
678: where proc_name = p_proc_name;
679:
680: BEGIN
681:

Line 686: from xdp_proc_body

682: /***
683: --skilaru 03/27/2001
684: --modified to use CURSOR
685: select proc_body into lv_lob
686: from xdp_proc_body
687: where proc_name = p_proc_name;
688: dbms_lob.read(lv_lob,lv_length,1,lv_str);
689: ***/
690: OPEN l_get_clob_value_csr;

Line 1871: FROM XDP_PROC_BODY

1867: lv_buffer varchar2(80);
1868:
1869: CURSOR lc_proc IS
1870: SELECT PROC_NAME,PROC_TYPE
1871: FROM XDP_PROC_BODY
1872: WHERE protected_flag = 'N'
1873: ORDER BY PROC_TYPE, PROC_NAME;
1874:
1875: CURSOR lc_adapter IS

Line 1897: from xdp_proc_body

1893: lv_src_length := 0;
1894: lv_buffer := NULL;
1895:
1896: select proc_body into lv_lob2
1897: from xdp_proc_body
1898: where proc_name = lv_rec.proc_name
1899: and proc_type = lv_rec.proc_type;
1900:
1901: lv_src_length := dbms_lob.GETLENGTH(lv_lob2);