DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_ACTION_HISTORY

Line 1127: UPDATE po_action_history poah

1123: THEN
1124:
1125: d_progress := 50;
1126:
1127: UPDATE po_action_history poah
1128: SET poah.action_code = p_action
1129: , poah.action_date = SYSDATE
1130: , poah.offline_code = NULL
1131: , poah.employee_id = l_emp_id

Line 1163: UPDATE po_action_history poah

1159: THEN
1160:
1161: d_progress := 110;
1162:
1163: UPDATE po_action_history poah
1164: SET poah.sequence_num = poah.sequence_num + 1
1165: WHERE poah.object_id = p_document_id
1166: AND poah.object_type_code = p_document_type
1167: AND poah.object_sub_type_code = p_document_subtype

Line 1177: FROM po_action_history poah

1173: -- Ported it over, as it will fix a PDOI issue.
1174:
1175: SELECT count(1)
1176: INTO l_count_hist
1177: FROM po_action_history poah
1178: WHERE poah.object_id = p_document_id
1179: AND poah.object_type_code = p_document_type
1180: AND poah.object_sub_type_code = p_document_subtype
1181: AND poah.action_code IS NOT NULL;

Line 1198: INSERT INTO po_action_history(

1194: -- Used Pro*C insert statement, as it was more accurate
1195: -- This SQL comes from: pocah.lpc
1196: -- The one in old POXPOACB.pls was incorrect.
1197:
1198: INSERT INTO po_action_history(
1199: object_id
1200: , object_type_code
1201: , object_sub_type_code
1202: , sequence_num

Line 1243: FROM po_action_history poah

1239: , 0
1240: , ''
1241: , 0
1242: , ''
1243: FROM po_action_history poah
1244: WHERE poah.object_id = p_document_id
1245: AND poah.object_type_code = p_document_type
1246: AND poah.object_sub_type_code = p_document_subtype
1247: AND poah.action_code IS NOT NULL

Line 1270: INSERT INTO po_action_history(

1266: IF (PO_LOG.d_stmt) THEN
1267: PO_LOG.stmt(d_module, d_progress, 'l_revision_num', l_revision_num);
1268: END IF;
1269:
1270: INSERT INTO po_action_history(
1271: object_id
1272: , object_type_code
1273: , object_sub_type_code
1274: , sequence_num

Line 2031: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE;

2027: , x_return_status OUT NOCOPY VARCHAR2
2028: )
2029: IS
2030:
2031: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE;
2032:
2033: d_progress NUMBER;
2034: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.insert_auth_action_history';
2035:

Line 2059: FROM PO_ACTION_HISTORY poah

2055:
2056:
2057: SELECT max(poah.sequence_num) + 1
2058: INTO l_sequence_num
2059: FROM PO_ACTION_HISTORY poah
2060: WHERE poah.object_type_code = p_document_type
2061: AND poah.object_id = p_document_id;
2062:
2063:

Line 2080: INSERT INTO PO_ACTION_HISTORY

2076: --
2077:
2078: d_progress := 20;
2079:
2080: INSERT INTO PO_ACTION_HISTORY
2081: ( object_id
2082: , object_type_code
2083: , object_sub_type_code
2084: , sequence_num

Line 2180: UPDATE PO_ACTION_HISTORY

2176: END IF;
2177:
2178: d_progress := 10;
2179:
2180: UPDATE PO_ACTION_HISTORY
2181: SET action_code = p_action
2182: , action_date = SYSDATE
2183: , note = p_note
2184: , last_updated_by = p_user_id