APPS.POR_UTIL_PKG dependencies on PO_CLM_MIPR_ACTION_HISTORY

Line 6137: FROM PO_CLM_MIPR_ACTION_HISTORY

6133: 'Progress: ' || l_progress );
6134: END IF;
6135:
6136: SELECT Count(*) INTO l_rec_found
6137: FROM PO_CLM_MIPR_ACTION_HISTORY
6138: WHERE requisition_header_id = p_document_id
6139: AND action_code = p_action_code;
6140:
6141: IF l_rec_found = 0 THEN

Line 6142: INSERT INTO PO_CLM_MIPR_ACTION_HISTORY(

6138: WHERE requisition_header_id = p_document_id
6139: AND action_code = p_action_code;
6140:
6141: IF l_rec_found = 0 THEN
6142: INSERT INTO PO_CLM_MIPR_ACTION_HISTORY(
6143: requisition_header_id,
6144: sequence_num,
6145: last_update_date,
6146: last_updated_by,

Line 6158: FROM PO_CLM_MIPR_ACTION_HISTORY

6154: contact,
6155: notes ) VALUES (
6156: p_document_id,
6157: NVL((SELECT Max(sequence_num) + 1
6158: FROM PO_CLM_MIPR_ACTION_HISTORY
6159: WHERE requisition_header_id = p_document_id),1),
6160: SYSDATE,
6161: fnd_global.user_id,
6162: SYSDATE,