APPS.M4U_DMD_REQUESTS dependencies on M4U_DMD_DOCUMENTS

Line 462: m4u_dmd_utils.log('insert into m4u_dmd_documents' ,1);

458: l_orig_doc_id := p_orig_doc_id;
459: END IF;
460:
461: m4u_dmd_utils.log('l_doc_id -|'|| l_doc_id ||'|',1);
462: m4u_dmd_utils.log('insert into m4u_dmd_documents' ,1);
463:
464: INSERT INTO m4u_dmd_documents
465: (
466: msg_id,doc_id,type ,action, retry_count,

Line 464: INSERT INTO m4u_dmd_documents

460:
461: m4u_dmd_utils.log('l_doc_id -|'|| l_doc_id ||'|',1);
462: m4u_dmd_utils.log('insert into m4u_dmd_documents' ,1);
463:
464: INSERT INTO m4u_dmd_documents
465: (
466: msg_id,doc_id,type ,action, retry_count,
467: doc_status, functional_status,processing_message,
468: ref_doc_id,orig_doc_id,doc_timestamp,

Line 557: FROM m4u_dmd_documents

553: l_value VARCHAR2(4000);
554:
555: CURSOR docs_for_msg(p_msg_id IN VARCHAR2) IS
556: SELECT *
557: FROM m4u_dmd_documents
558: WHERE msg_id = p_msg_id;
559: BEGIN
560: m4u_dmd_utils.log('Entering m4u_dmd_request.rerty_request',2);
561: m4u_dmd_utils.log('p_msg_id -|'|| p_msg_id ||'|',1);

Line 696: FROM m4u_dmd_documents

692: )
693: IS
694: CURSOR docs_for_msg(p_msg_id IN VARCHAR2, p_retry_count IN NUMBER) IS
695: SELECT *
696: FROM m4u_dmd_documents
697: WHERE msg_id = p_msg_id
698: AND retry_count = p_retry_count;
699:
700: l_payload_id VARCHAR2(30);

Line 921: -- updates document record in m4u_dmd_documents

917: m4u_dmd_utils.handle_error(l_err_api,l_err_msg,
918: SQLCODE,SQLERRM,x_ret_sts,x_ret_msg);
919: END update_request;
920:
921: -- updates document record in m4u_dmd_documents
922: -- only updatable fields are allowed inputs
923: PROCEDURE update_document
924: (
925: p_doc_id IN VARCHAR2,

Line 965: l_doc_rec m4u_dmd_documents%rowtype;

961: l_err_msg VARCHAR2(2000);
962: l_param VARCHAR2(100);
963: l_value VARCHAR2(2000);
964: l_orig_doc_id VARCHAR2(80);
965: l_doc_rec m4u_dmd_documents%rowtype;
966: l_doc_id VARCHAR2(30);
967: l_retry_count NUMBER;
968: l_cis_status VARCHAR2(30);
969: BEGIN

Line 1102: FROM m4u_dmd_documents

1098:
1099: IF p_doc_id IS NULL THEN
1100: SELECT doc_id , retry_count
1101: INTO l_doc_id, l_retry_count
1102: FROM m4u_dmd_documents
1103: WHERE orig_doc_id = p_orig_doc_id;
1104: ELSE
1105: l_doc_id := p_doc_id;
1106: l_retry_count := p_retry_count;

Line 1111: FROM m4u_dmd_documents

1107: END IF;
1108:
1109: SELECT *
1110: INTO l_doc_rec
1111: FROM m4u_dmd_documents
1112: WHERE doc_id = l_doc_id;
1113:
1114: IF p_orig_doc_id = 'GENERATE' THEN
1115: l_orig_doc_id := l_doc_rec.type || '.' || sysdate ||

Line 1123: m4u_dmd_utils.log('UPDATE m4u_dmd_documents' ,1);

1119: END IF;
1120:
1121: m4u_dmd_utils.log('l_doc_id -|'|| l_doc_id ||'|',1);
1122:
1123: m4u_dmd_utils.log('UPDATE m4u_dmd_documents' ,1);
1124: UPDATE m4u_dmd_documents
1125: SET ref_doc_id = NVL(p_ref_doc_id, ref_doc_id ),
1126: orig_doc_id = NVL(l_orig_doc_id, orig_doc_id ),
1127: retry_count = NVL(l_retry_count,retry_count ),

Line 1124: UPDATE m4u_dmd_documents

1120:
1121: m4u_dmd_utils.log('l_doc_id -|'|| l_doc_id ||'|',1);
1122:
1123: m4u_dmd_utils.log('UPDATE m4u_dmd_documents' ,1);
1124: UPDATE m4u_dmd_documents
1125: SET ref_doc_id = NVL(p_ref_doc_id, ref_doc_id ),
1126: orig_doc_id = NVL(l_orig_doc_id, orig_doc_id ),
1127: retry_count = NVL(l_retry_count,retry_count ),
1128: doc_status = NVL(p_doc_status,doc_status ),