APPS.HR_WIP_TXNS dependencies on DBMS_LOB

Line 648: DBMS_LOB.WRITE(l_db_clob,

644: fnd_message.raise_error;
645: end if;
646: close csr_vo_cache;
647:
648: DBMS_LOB.WRITE(l_db_clob,
649: length(p_vo_xml),
650: DBMS_LOB.GETLENGTH(l_db_clob)+1,
651: p_vo_xml);
652:

Line 650: DBMS_LOB.GETLENGTH(l_db_clob)+1,

646: close csr_vo_cache;
647:
648: DBMS_LOB.WRITE(l_db_clob,
649: length(p_vo_xml),
650: DBMS_LOB.GETLENGTH(l_db_clob)+1,
651: p_vo_xml);
652:
653: update hr_wip_transactions
654: set vo_cache = l_db_clob

Line 859: l_amount := dbms_lob.getlength(p_vo_xml);

855: End if;
856: --
857: -- Convert clob to varchar2 datatype for comparision
858: --
859: l_amount := dbms_lob.getlength(p_vo_xml);
860: dbms_lob.read(p_vo_xml,l_amount,1,l_vo_xml_var);
861: --
862: upd(p_transaction_id => p_transaction_id
863: ,p_state => g_reject_for_correction_state

Line 860: dbms_lob.read(p_vo_xml,l_amount,1,l_vo_xml_var);

856: --
857: -- Convert clob to varchar2 datatype for comparision
858: --
859: l_amount := dbms_lob.getlength(p_vo_xml);
860: dbms_lob.read(p_vo_xml,l_amount,1,l_vo_xml_var);
861: --
862: upd(p_transaction_id => p_transaction_id
863: ,p_state => g_reject_for_correction_state
864: ,p_sub_state => null