APPS.PO_DRAFT_MERGE_PKG dependencies on PO_ACTION_HISTORY

Line 27: p_note PO_ACTION_HISTORY.note%TYPE,

23: p_doc_subtype IN VARCHAR2,
24: p_override_funds IN VARCHAR2,
25: p_employee_id IN NUMBER,
26: p_approval_path_id IN NUMBER,
27: p_note PO_ACTION_HISTORY.note%TYPE,
28: x_po_return_code OUT NOCOPY VARCHAR2,
29: x_online_report_id OUT NOCOPY NUMBER,
30: x_return_status OUT NOCOPY VARCHAR2 );
31: /*Bug 13938456 - Concurrent Mod Attachemnts*/

Line 535: l_note PO_ACTION_HISTORY.note%TYPE;

531:
532: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
533: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
534:
535: l_note PO_ACTION_HISTORY.note%TYPE;
536: l_approval_path_id NUMBER;
537: l_exception_msg VARCHAR2(2000);
538: l_override_funds VARCHAR2(3) := NULL;
539: l_employee_id NUMBER;

Line 995: p_note PO_ACTION_HISTORY.note%TYPE,

991: p_doc_subtype IN VARCHAR2,
992: p_override_funds IN VARCHAR2,
993: p_employee_id IN NUMBER,
994: p_approval_path_id IN NUMBER,
995: p_note PO_ACTION_HISTORY.note%TYPE,
996: x_po_return_code OUT NOCOPY VARCHAR2,
997: x_online_report_id OUT NOCOPY NUMBER,
998: x_return_status OUT NOCOPY VARCHAR2 )
999: IS

Line 1013: l_note PO_ACTION_HISTORY.note%TYPE;

1009: l_errorcode VARCHAR2(50);
1010: l_msg_count NUMBER;
1011: l_msg_data VARCHAR2(4000);
1012: x_exception_msg VARCHAR2(1000);
1013: l_note PO_ACTION_HISTORY.note%TYPE;
1014: resultout VARCHAR2(1);
1015: l_is_clm_document VARCHAR2(1);
1016: BEGIN
1017:

Line 1837: -- get data from last entry in po_action_history

1833:
1834:
1835: IF l_preparer_id = p_employee_id THEN
1836:
1837: -- get data from last entry in po_action_history
1838: SELECT sequence_num,
1839: object_revision_num,
1840: approval_path_id
1841: INTO l_sequence_num,

Line 1844: FROM po_action_history

1840: approval_path_id
1841: INTO l_sequence_num,
1842: l_object_rev_num,
1843: l_approval_path_id
1844: FROM po_action_history
1845: WHERE object_id = p_draft_id
1846: AND object_type_code = p_document_type
1847: AND sequence_num = (SELECT max(sequence_num)
1848: FROM po_action_history

Line 1848: FROM po_action_history

1844: FROM po_action_history
1845: WHERE object_id = p_draft_id
1846: AND object_type_code = p_document_type
1847: AND sequence_num = (SELECT max(sequence_num)
1848: FROM po_action_history
1849: WHERE object_id = p_draft_id
1850: AND Object_Type_Code = p_document_type
1851: AND object_sub_type_code = 'POST_AWARD_REQUEST')
1852: AND object_sub_type_code = 'POST_AWARD_REQUEST';

Line 1854: INSERT into PO_ACTION_HISTORY

1850: AND Object_Type_Code = p_document_type
1851: AND object_sub_type_code = 'POST_AWARD_REQUEST')
1852: AND object_sub_type_code = 'POST_AWARD_REQUEST';
1853:
1854: INSERT into PO_ACTION_HISTORY
1855: (object_id,
1856: object_type_code,
1857: object_sub_type_code,
1858: sequence_num,