eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_APPROVAL_PKG dependencies on AME_UTIL

Line 53: PROCEDURE parse_ame_approver( p_approver_string IN VARCHAR2, p_approver OUT NOCOPY ame_util.approverRecord2 );

49: nullEmployeeRecord employeeRecord;
50:
51:
52: -- Updated Parsing and Formatting routines to be compatible with AME API 11.5.10.
53: PROCEDURE parse_ame_approver( p_approver_string IN VARCHAR2, p_approver OUT NOCOPY ame_util.approverRecord2 );
54: FUNCTION format_ame_approver( p_approver IN ame_util.approverRecord2 ) RETURN VARCHAR2;
55: FUNCTION format_ame_approver_list( p_approver_list IN ame_util.approversTable2 ) RETURN VARCHAR2;
56: FUNCTION is_old_approver_record( p_approver_string IN VARCHAR2 ) RETURN BOOLEAN;
57:

Line 54: FUNCTION format_ame_approver( p_approver IN ame_util.approverRecord2 ) RETURN VARCHAR2;

50:
51:
52: -- Updated Parsing and Formatting routines to be compatible with AME API 11.5.10.
53: PROCEDURE parse_ame_approver( p_approver_string IN VARCHAR2, p_approver OUT NOCOPY ame_util.approverRecord2 );
54: FUNCTION format_ame_approver( p_approver IN ame_util.approverRecord2 ) RETURN VARCHAR2;
55: FUNCTION format_ame_approver_list( p_approver_list IN ame_util.approversTable2 ) RETURN VARCHAR2;
56: FUNCTION is_old_approver_record( p_approver_string IN VARCHAR2 ) RETURN BOOLEAN;
57:
58: -- parsing and formatting routines

Line 55: FUNCTION format_ame_approver_list( p_approver_list IN ame_util.approversTable2 ) RETURN VARCHAR2;

51:
52: -- Updated Parsing and Formatting routines to be compatible with AME API 11.5.10.
53: PROCEDURE parse_ame_approver( p_approver_string IN VARCHAR2, p_approver OUT NOCOPY ame_util.approverRecord2 );
54: FUNCTION format_ame_approver( p_approver IN ame_util.approverRecord2 ) RETURN VARCHAR2;
55: FUNCTION format_ame_approver_list( p_approver_list IN ame_util.approversTable2 ) RETURN VARCHAR2;
56: FUNCTION is_old_approver_record( p_approver_string IN VARCHAR2 ) RETURN BOOLEAN;
57:
58: -- parsing and formatting routines
59: PROCEDURE parse_approver(p_approver_string IN VARCHAR2,

Line 60: p_approver OUT NOCOPY ame_util.approverRecord);

56: FUNCTION is_old_approver_record( p_approver_string IN VARCHAR2 ) RETURN BOOLEAN;
57:
58: -- parsing and formatting routines
59: PROCEDURE parse_approver(p_approver_string IN VARCHAR2,
60: p_approver OUT NOCOPY ame_util.approverRecord);
61: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,
62: p_approver_string OUT NOCOPY VARCHAR2);
63: PROCEDURE parse_approver_list(p_approver_list_string IN VARCHAR2,
64: p_approver_list OUT NOCOPY ame_util.approversTable);

Line 61: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,

57:
58: -- parsing and formatting routines
59: PROCEDURE parse_approver(p_approver_string IN VARCHAR2,
60: p_approver OUT NOCOPY ame_util.approverRecord);
61: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,
62: p_approver_string OUT NOCOPY VARCHAR2);
63: PROCEDURE parse_approver_list(p_approver_list_string IN VARCHAR2,
64: p_approver_list OUT NOCOPY ame_util.approversTable);
65: PROCEDURE format_approver_list(p_approver_list IN ame_util.approversTable,

Line 64: p_approver_list OUT NOCOPY ame_util.approversTable);

60: p_approver OUT NOCOPY ame_util.approverRecord);
61: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,
62: p_approver_string OUT NOCOPY VARCHAR2);
63: PROCEDURE parse_approver_list(p_approver_list_string IN VARCHAR2,
64: p_approver_list OUT NOCOPY ame_util.approversTable);
65: PROCEDURE format_approver_list(p_approver_list IN ame_util.approversTable,
66: p_approver_list_string OUT NOCOPY VARCHAR2);
67: FUNCTION convert_to_ame_api_insertion(p_pon_api_insertion IN NUMBER) RETURN VARCHAR2;
68: FUNCTION convert_to_pon_api_insertion(p_ame_api_insertion IN VARCHAR2) RETURN NUMBER;

Line 65: PROCEDURE format_approver_list(p_approver_list IN ame_util.approversTable,

61: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,
62: p_approver_string OUT NOCOPY VARCHAR2);
63: PROCEDURE parse_approver_list(p_approver_list_string IN VARCHAR2,
64: p_approver_list OUT NOCOPY ame_util.approversTable);
65: PROCEDURE format_approver_list(p_approver_list IN ame_util.approversTable,
66: p_approver_list_string OUT NOCOPY VARCHAR2);
67: FUNCTION convert_to_ame_api_insertion(p_pon_api_insertion IN NUMBER) RETURN VARCHAR2;
68: FUNCTION convert_to_pon_api_insertion(p_ame_api_insertion IN VARCHAR2) RETURN NUMBER;
69: FUNCTION convert_to_ame_authority(p_pon_authority IN NUMBER) RETURN VARCHAR2;

Line 84: FUNCTION approvers_match(p_approver1 ame_util.approverRecord,

80: PROCEDURE get_employee_info_for_user(p_user_name IN VARCHAR2, p_employee OUT NOCOPY employeeRecord);
81: PROCEDURE get_employee_info_for_person(p_person_id IN NUMBER, p_employee OUT NOCOPY employeeRecord);
82:
83: -- function that returns true if two approvers match
84: FUNCTION approvers_match(p_approver1 ame_util.approverRecord,
85: p_approver2 ame_util.approverRecord) RETURN BOOLEAN;
86:
87: --procedure used for error reporting
88: PROCEDURE trim_error_code(p_error_code IN NUMBER,

Line 85: p_approver2 ame_util.approverRecord) RETURN BOOLEAN;

81: PROCEDURE get_employee_info_for_person(p_person_id IN NUMBER, p_employee OUT NOCOPY employeeRecord);
82:
83: -- function that returns true if two approvers match
84: FUNCTION approvers_match(p_approver1 ame_util.approverRecord,
85: p_approver2 ame_util.approverRecord) RETURN BOOLEAN;
86:
87: --procedure used for error reporting
88: PROCEDURE trim_error_code(p_error_code IN NUMBER,
89: p_error_message_in IN VARCHAR2,

Line 877: l_next_approver_list ame_util.approversTable2;

873: l_auction_header_id NUMBER;
874: l_transaction_id VARCHAR2(80);
875:
876: l_next_approver_employee employeeRecord;
877: l_next_approver_list ame_util.approversTable2;
878: l_next_approver ame_util.approverRecord2;
879: l_process_out varchar2(2);
880: l_person_id NUMBER;
881:

Line 878: l_next_approver ame_util.approverRecord2;

874: l_transaction_id VARCHAR2(80);
875:
876: l_next_approver_employee employeeRecord;
877: l_next_approver_list ame_util.approversTable2;
878: l_next_approver ame_util.approverRecord2;
879: l_process_out varchar2(2);
880: l_person_id NUMBER;
881:
882: l_next_approver_name VARCHAR2(240);

Line 886: l_idList ame_util.idList;

882: l_next_approver_name VARCHAR2(240);
883: l_next_approver_string VARCHAR2(240);
884: l_success_flag BOOLEAN;
885: l_source_type_out VARCHAR2(50);
886: l_idList ame_util.idList;
887:
888: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
889: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
890: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 972: IF( l_next_approver.api_insertion = ame_util.apiAuthorityInsertion AND

968: ame_api3.parseApproverSource( approverSourceIn => l_next_approver.source,
969: sourceDescriptionOut => l_source_type_out,
970: ruleIdListOut => l_idList);
971:
972: IF( l_next_approver.api_insertion = ame_util.apiAuthorityInsertion AND
973: l_source_type_out <> ame_util.forwardeeSource ) THEN
974: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
975: itemkey => itemkey,
976: aname => 'FIRST_AUTHORITY_APPROVER_ID');

Line 973: l_source_type_out <> ame_util.forwardeeSource ) THEN

969: sourceDescriptionOut => l_source_type_out,
970: ruleIdListOut => l_idList);
971:
972: IF( l_next_approver.api_insertion = ame_util.apiAuthorityInsertion AND
973: l_source_type_out <> ame_util.forwardeeSource ) THEN
974: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
975: itemkey => itemkey,
976: aname => 'FIRST_AUTHORITY_APPROVER_ID');
977: END IF;

Line 1193: l_admin_approver ame_util.approverRecord2;

1189: funcmode IN VARCHAR2,
1190: resultout OUT NOCOPY VARCHAR2) IS
1191: l_error_date DATE;
1192: l_oam_admin_user_name VARCHAR2(100);
1193: l_admin_approver ame_util.approverRecord2;
1194:
1195: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1196: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1197: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 1212: l_admin_approver := ame_util.emptyApproverRecord2;

1208: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAdminApprover returns ' || fnd_global.newline || format_ame_approver(l_admin_approver));
1209:
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: l_admin_approver := ame_util.emptyApproverRecord2;
1213:
1214: log_string(l_exception_log_level, l_current_log_level, l_module_name, SQLERRM);
1215: END;
1216:

Line 1372: l_approver ame_util.approverRecord2;

1368:
1369: l_approver_employee employeeRecord;
1370: l_person_id NUMBER;
1371:
1372: l_approver ame_util.approverRecord2;
1373: l_forwardee ame_util.approverRecord2;
1374: l_approver_old ame_util.approverRecord;
1375:
1376: l_forwardee_user_name VARCHAR2(100);

Line 1373: l_forwardee ame_util.approverRecord2;

1369: l_approver_employee employeeRecord;
1370: l_person_id NUMBER;
1371:
1372: l_approver ame_util.approverRecord2;
1373: l_forwardee ame_util.approverRecord2;
1374: l_approver_old ame_util.approverRecord;
1375:
1376: l_forwardee_user_name VARCHAR2(100);
1377: l_forwardee_employee employeeRecord;

Line 1374: l_approver_old ame_util.approverRecord;

1370: l_person_id NUMBER;
1371:
1372: l_approver ame_util.approverRecord2;
1373: l_forwardee ame_util.approverRecord2;
1374: l_approver_old ame_util.approverRecord;
1375:
1376: l_forwardee_user_name VARCHAR2(100);
1377: l_forwardee_employee employeeRecord;
1378: l_action_type VARCHAR2(25);

Line 1383: l_idList ame_util.idList;

1379: l_approval_status VARCHAR2(50);
1380: l_valid_response BOOLEAN;
1381: l_success_flag BOOLEAN;
1382: l_source_type_out VARCHAR2(50);
1383: l_idList ame_util.idList;
1384:
1385: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1386: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1387: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 1441: 'It is_old_approver_record. So calling ame_util.apprRecordToApprRecord2' );

1437:
1438: log_string( l_statement_log_level,
1439: l_current_log_level,
1440: l_module_name,
1441: 'It is_old_approver_record. So calling ame_util.apprRecordToApprRecord2' );
1442: parse_approver(l_approver_string, l_approver_old);
1443: ame_util.apprRecordToApprRecord2( approverRecordIn => l_approver_old,
1444: approverRecord2Out => l_approver );
1445: ELSE

Line 1443: ame_util.apprRecordToApprRecord2( approverRecordIn => l_approver_old,

1439: l_current_log_level,
1440: l_module_name,
1441: 'It is_old_approver_record. So calling ame_util.apprRecordToApprRecord2' );
1442: parse_approver(l_approver_string, l_approver_old);
1443: ame_util.apprRecordToApprRecord2( approverRecordIn => l_approver_old,
1444: approverRecord2Out => l_approver );
1445: ELSE
1446: parse_ame_approver(l_approver_string, l_approver);
1447: END IF;

Line 1463: IF( l_approver.api_insertion = ame_util.apiAuthorityInsertion AND

1459: ame_api3.parseApproverSource( approverSourceIn => l_approver.source,
1460: sourceDescriptionOut => l_source_type_out,
1461: ruleIdListOut => l_idList);
1462:
1463: IF( l_approver.api_insertion = ame_util.apiAuthorityInsertion AND
1464: l_source_type_out <> ame_util.forwardeeSource ) THEN
1465: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1466: itemkey => itemkey,
1467: aname => 'FIRST_AUTHORITY_APPROVER_ID');

Line 1464: l_source_type_out <> ame_util.forwardeeSource ) THEN

1460: sourceDescriptionOut => l_source_type_out,
1461: ruleIdListOut => l_idList);
1462:
1463: IF( l_approver.api_insertion = ame_util.apiAuthorityInsertion AND
1464: l_source_type_out <> ame_util.forwardeeSource ) THEN
1465: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1466: itemkey => itemkey,
1467: aname => 'FIRST_AUTHORITY_APPROVER_ID');
1468: END IF;

Line 1598: l_approver.approval_status:= ame_util.approvedStatus;

1594:
1595: -- determine approval status for response type
1596: -- set approver's approval status
1597: IF l_response_type = 'APPROVE' THEN
1598: l_approver.approval_status:= ame_util.approvedStatus;
1599: ELSIF l_response_type = 'REJECT' THEN
1600: l_approver.approval_status := ame_util.rejectStatus;
1601: ELSIF l_response_type = 'FORWARD' THEN
1602: l_approver.approval_status := ame_util.forwardStatus;

Line 1600: l_approver.approval_status := ame_util.rejectStatus;

1596: -- set approver's approval status
1597: IF l_response_type = 'APPROVE' THEN
1598: l_approver.approval_status:= ame_util.approvedStatus;
1599: ELSIF l_response_type = 'REJECT' THEN
1600: l_approver.approval_status := ame_util.rejectStatus;
1601: ELSIF l_response_type = 'FORWARD' THEN
1602: l_approver.approval_status := ame_util.forwardStatus;
1603: ELSIF l_response_type = 'APPROVE_AND_FORWARD' THEN
1604: l_approver.approval_status := ame_util.approveAndForwardStatus;

Line 1602: l_approver.approval_status := ame_util.forwardStatus;

1598: l_approver.approval_status:= ame_util.approvedStatus;
1599: ELSIF l_response_type = 'REJECT' THEN
1600: l_approver.approval_status := ame_util.rejectStatus;
1601: ELSIF l_response_type = 'FORWARD' THEN
1602: l_approver.approval_status := ame_util.forwardStatus;
1603: ELSIF l_response_type = 'APPROVE_AND_FORWARD' THEN
1604: l_approver.approval_status := ame_util.approveAndForwardStatus;
1605: END IF;
1606:

Line 1604: l_approver.approval_status := ame_util.approveAndForwardStatus;

1600: l_approver.approval_status := ame_util.rejectStatus;
1601: ELSIF l_response_type = 'FORWARD' THEN
1602: l_approver.approval_status := ame_util.forwardStatus;
1603: ELSIF l_response_type = 'APPROVE_AND_FORWARD' THEN
1604: l_approver.approval_status := ame_util.approveAndForwardStatus;
1605: END IF;
1606:
1607: -- use forwardee's person id since person id is preferred
1608: IF l_forwardee_employee.person_id IS NOT NULL THEN

Line 1614: IF l_approver.api_insertion IN (ame_util.oamGenerated, ame_util.apiAuthorityInsertion) AND

1610: l_forwardee.orig_system_id := l_forwardee_employee.person_id;
1611: l_forwardee.orig_system := l_approver.orig_system;
1612:
1613: -- set forwardee's api_insertion and authority fields
1614: IF l_approver.api_insertion IN (ame_util.oamGenerated, ame_util.apiAuthorityInsertion) AND
1615: l_approver.authority = ame_util.authorityApprover THEN
1616: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
1617: ELSE
1618: l_forwardee.api_insertion := ame_util.apiInsertion;

Line 1615: l_approver.authority = ame_util.authorityApprover THEN

1611: l_forwardee.orig_system := l_approver.orig_system;
1612:
1613: -- set forwardee's api_insertion and authority fields
1614: IF l_approver.api_insertion IN (ame_util.oamGenerated, ame_util.apiAuthorityInsertion) AND
1615: l_approver.authority = ame_util.authorityApprover THEN
1616: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
1617: ELSE
1618: l_forwardee.api_insertion := ame_util.apiInsertion;
1619: END IF;

Line 1616: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;

1612:
1613: -- set forwardee's api_insertion and authority fields
1614: IF l_approver.api_insertion IN (ame_util.oamGenerated, ame_util.apiAuthorityInsertion) AND
1615: l_approver.authority = ame_util.authorityApprover THEN
1616: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
1617: ELSE
1618: l_forwardee.api_insertion := ame_util.apiInsertion;
1619: END IF;
1620:

Line 1618: l_forwardee.api_insertion := ame_util.apiInsertion;

1614: IF l_approver.api_insertion IN (ame_util.oamGenerated, ame_util.apiAuthorityInsertion) AND
1615: l_approver.authority = ame_util.authorityApprover THEN
1616: l_forwardee.api_insertion := ame_util.apiAuthorityInsertion;
1617: ELSE
1618: l_forwardee.api_insertion := ame_util.apiInsertion;
1619: END IF;
1620:
1621: IF l_forwardee.orig_system = 'POS' THEN
1622: select full_name into l_forwardee.display_name from per_all_people_f where person_id = l_forwardee.orig_system_id and TRUNC(sysdate) between effective_start_date and effective_end_date;

Line 1655: l_forwardee.approval_status := ame_util.nullStatus;

1651: RETURN;
1652: END IF;
1653: END IF;
1654:
1655: l_forwardee.approval_status := ame_util.nullStatus;
1656:
1657: l_forwardee.authority := l_approver.authority;
1658: l_forwardee.approver_category := l_approver.approver_category;
1659: l_forwardee.item_class := l_approver.item_class ;

Line 1684: l_forwardee := ame_util.emptyApproverRecord2;

1680:
1681: RETURN;
1682: END IF;
1683: ELSE
1684: l_forwardee := ame_util.emptyApproverRecord2;
1685: END IF;
1686:
1687: l_success_flag := TRUE;
1688:

Line 1772: l_approver_list ame_util.approversTable2;

1768: p_last_update_date IN DATE,
1769: p_approver_list_string OUT NOCOPY VARCHAR2,
1770: p_error_message OUT NOCOPY VARCHAR2) IS
1771:
1772: l_approver_list ame_util.approversTable2;
1773: l_approver ame_util.approverRecord2;
1774: l_available_insertion_list ame_util.insertionsTable2;
1775: l_insertion_order ame_util.insertionRecord2;
1776: l_process_out varchar2(2);

Line 1773: l_approver ame_util.approverRecord2;

1769: p_approver_list_string OUT NOCOPY VARCHAR2,
1770: p_error_message OUT NOCOPY VARCHAR2) IS
1771:
1772: l_approver_list ame_util.approversTable2;
1773: l_approver ame_util.approverRecord2;
1774: l_available_insertion_list ame_util.insertionsTable2;
1775: l_insertion_order ame_util.insertionRecord2;
1776: l_process_out varchar2(2);
1777:

Line 1774: l_available_insertion_list ame_util.insertionsTable2;

1770: p_error_message OUT NOCOPY VARCHAR2) IS
1771:
1772: l_approver_list ame_util.approversTable2;
1773: l_approver ame_util.approverRecord2;
1774: l_available_insertion_list ame_util.insertionsTable2;
1775: l_insertion_order ame_util.insertionRecord2;
1776: l_process_out varchar2(2);
1777:
1778: l_error_code NUMBER;

Line 1775: l_insertion_order ame_util.insertionRecord2;

1771:
1772: l_approver_list ame_util.approversTable2;
1773: l_approver ame_util.approverRecord2;
1774: l_available_insertion_list ame_util.insertionsTable2;
1775: l_insertion_order ame_util.insertionRecord2;
1776: l_process_out varchar2(2);
1777:
1778: l_error_code NUMBER;
1779:

Line 1809: (ame_util.absoluteOrder, ame_util.afterApprover, ame_util.beforeApprover) AND

1805: -- that corresponds to the api insertion and authority value of the approver to be inserted into the approver list
1806:
1807: FOR i IN 1 .. l_available_insertion_list.COUNT LOOP
1808: IF l_available_insertion_list(i).order_type IN
1809: (ame_util.absoluteOrder, ame_util.afterApprover, ame_util.beforeApprover) AND
1810: l_available_insertion_list(i).api_insertion = l_approver.api_insertion AND
1811: l_available_insertion_list(i).authority = l_approver.authority THEN
1812:
1813: l_insertion_order := l_available_insertion_list(i);

Line 1891: l_approver_list ame_util.approversTable2;

1887: p_last_update_date IN DATE,
1888: p_approver_list_string OUT NOCOPY VARCHAR2,
1889: p_error_message OUT NOCOPY VARCHAR2) IS
1890:
1891: l_approver_list ame_util.approversTable2;
1892: l_approver ame_util.approverRecord2;
1893: l_process_out varchar2(2);
1894:
1895: l_error_code NUMBER;

Line 1892: l_approver ame_util.approverRecord2;

1888: p_approver_list_string OUT NOCOPY VARCHAR2,
1889: p_error_message OUT NOCOPY VARCHAR2) IS
1890:
1891: l_approver_list ame_util.approversTable2;
1892: l_approver ame_util.approverRecord2;
1893: l_process_out varchar2(2);
1894:
1895: l_error_code NUMBER;
1896:

Line 1960: l_approver_list ame_util.approversTable2;

1956: p_last_update_date IN DATE,
1957: p_approver_list_string OUT NOCOPY VARCHAR2,
1958: p_error_message OUT NOCOPY VARCHAR2) IS
1959:
1960: l_approver_list ame_util.approversTable2;
1961: l_approver ame_util.approverRecord2;
1962: l_process_out VARCHAR2(1);
1963:
1964: insertion ame_util.insertionRecord2;

Line 1961: l_approver ame_util.approverRecord2;

1957: p_approver_list_string OUT NOCOPY VARCHAR2,
1958: p_error_message OUT NOCOPY VARCHAR2) IS
1959:
1960: l_approver_list ame_util.approversTable2;
1961: l_approver ame_util.approverRecord2;
1962: l_process_out VARCHAR2(1);
1963:
1964: insertion ame_util.insertionRecord2;
1965: l_available_insertion_list ame_util.insertionsTable2;

Line 1964: insertion ame_util.insertionRecord2;

1960: l_approver_list ame_util.approversTable2;
1961: l_approver ame_util.approverRecord2;
1962: l_process_out VARCHAR2(1);
1963:
1964: insertion ame_util.insertionRecord2;
1965: l_available_insertion_list ame_util.insertionsTable2;
1966: l_current_first_approver ame_util.approverRecord2;
1967:
1968: l_error_code NUMBER;

Line 1965: l_available_insertion_list ame_util.insertionsTable2;

1961: l_approver ame_util.approverRecord2;
1962: l_process_out VARCHAR2(1);
1963:
1964: insertion ame_util.insertionRecord2;
1965: l_available_insertion_list ame_util.insertionsTable2;
1966: l_current_first_approver ame_util.approverRecord2;
1967:
1968: l_error_code NUMBER;
1969:

Line 1966: l_current_first_approver ame_util.approverRecord2;

1962: l_process_out VARCHAR2(1);
1963:
1964: insertion ame_util.insertionRecord2;
1965: l_available_insertion_list ame_util.insertionsTable2;
1966: l_current_first_approver ame_util.approverRecord2;
1967:
1968: l_error_code NUMBER;
1969:
1970: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1997: if( l_approver_list(i).authority = ame_util.authorityApprover

1993: approvalProcessCompleteYNOut => l_process_out,
1994: approversOut => l_approver_list);
1995:
1996: for i in 1 .. l_approver_list.count loop
1997: if( l_approver_list(i).authority = ame_util.authorityApprover
1998: and l_approver_list(i).group_or_chain_id < 3
1999: and l_approver_list(i).api_insertion = ame_util.oamGenerated) then
2000: l_current_first_approver := l_approver_list(i) ;
2001: log_string(l_statement_log_level, l_current_log_level, l_module_name,'authorityApprover: ' || l_current_first_approver.authority);

Line 1999: and l_approver_list(i).api_insertion = ame_util.oamGenerated) then

1995:
1996: for i in 1 .. l_approver_list.count loop
1997: if( l_approver_list(i).authority = ame_util.authorityApprover
1998: and l_approver_list(i).group_or_chain_id < 3
1999: and l_approver_list(i).api_insertion = ame_util.oamGenerated) then
2000: l_current_first_approver := l_approver_list(i) ;
2001: log_string(l_statement_log_level, l_current_log_level, l_module_name,'authorityApprover: ' || l_current_first_approver.authority);
2002:
2003: exit;

Line 2036: l_approver.authority := ame_util.authorityApprover;

2032: END IF;
2033:
2034: -- set the mandatory default attributes for the first authority approver.
2035: -- this will make sure we have populated the correct values.
2036: l_approver.authority := ame_util.authorityApprover;
2037: l_approver.api_insertion := ame_util.apiAuthorityInsertion;
2038: l_approver.approval_status := ame_util.nullStatus;
2039: l_approver.approver_category := ame_util.approvalApproverCategory ;
2040: l_approver.item_class := l_current_first_approver.item_class ;

Line 2037: l_approver.api_insertion := ame_util.apiAuthorityInsertion;

2033:
2034: -- set the mandatory default attributes for the first authority approver.
2035: -- this will make sure we have populated the correct values.
2036: l_approver.authority := ame_util.authorityApprover;
2037: l_approver.api_insertion := ame_util.apiAuthorityInsertion;
2038: l_approver.approval_status := ame_util.nullStatus;
2039: l_approver.approver_category := ame_util.approvalApproverCategory ;
2040: l_approver.item_class := l_current_first_approver.item_class ;
2041: l_approver.item_id := l_current_first_approver.item_id ;

Line 2038: l_approver.approval_status := ame_util.nullStatus;

2034: -- set the mandatory default attributes for the first authority approver.
2035: -- this will make sure we have populated the correct values.
2036: l_approver.authority := ame_util.authorityApprover;
2037: l_approver.api_insertion := ame_util.apiAuthorityInsertion;
2038: l_approver.approval_status := ame_util.nullStatus;
2039: l_approver.approver_category := ame_util.approvalApproverCategory ;
2040: l_approver.item_class := l_current_first_approver.item_class ;
2041: l_approver.item_id := l_current_first_approver.item_id ;
2042: l_approver.action_type_id := l_current_first_approver.action_type_id ;

Line 2039: l_approver.approver_category := ame_util.approvalApproverCategory ;

2035: -- this will make sure we have populated the correct values.
2036: l_approver.authority := ame_util.authorityApprover;
2037: l_approver.api_insertion := ame_util.apiAuthorityInsertion;
2038: l_approver.approval_status := ame_util.nullStatus;
2039: l_approver.approver_category := ame_util.approvalApproverCategory ;
2040: l_approver.item_class := l_current_first_approver.item_class ;
2041: l_approver.item_id := l_current_first_approver.item_id ;
2042: l_approver.action_type_id := l_current_first_approver.action_type_id ;
2043: l_approver.group_or_chain_id := l_current_first_approver.group_or_chain_id ;

Line 2060: clearChainStatusYNIn => ame_util.booleanTrue);

2056: ame_api2.setFirstAuthorityApprover(applicationIdIn => APPLICATION_ID,
2057: transactionIdIn => p_transaction_id,
2058: approverIn => l_approver,
2059: transactionTypeIn => AWARD_TRANSACTION_TYPE,
2060: clearChainStatusYNIn => ame_util.booleanTrue);
2061:
2062: -- recalculate approver list
2063: ame_api2.getAllApprovers7( applicationIdIn => APPLICATION_ID,
2064: transactionIdIn => p_transaction_id,

Line 2104: l_approver_list ame_util.approversTable2;

2100: p_approver_list_string OUT NOCOPY VARCHAR2,
2101: p_can_delete_oam_approvers OUT NOCOPY VARCHAR2,
2102: p_error_message OUT NOCOPY VARCHAR2) IS
2103:
2104: l_approver_list ame_util.approversTable2;
2105: l_attribute_value1 VARCHAR2(10);
2106: l_attribute_value2 VARCHAR2(10);
2107: l_attribute_value3 VARCHAR2(10);
2108: l_process_out VARCHAR2(10);

Line 2141: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api3.getAttributeValue with ' || ame_util.allowDeletingOamApprovers);

2137:
2138: p_approver_list_string := format_ame_approver_list(l_approver_list);
2139:
2140: -- determine whether OAM-generated approvers can be deleted
2141: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api3.getAttributeValue with ' || ame_util.allowDeletingOamApprovers);
2142: ame_api3.getAttributeValue(applicationIdIn => APPLICATION_ID,
2143: transactionTypeIn => AWARD_TRANSACTION_TYPE,
2144: transactionIdIn => p_transaction_id,
2145: attributeNameIn => ame_util.allowDeletingOamApprovers,

Line 2145: attributeNameIn => ame_util.allowDeletingOamApprovers,

2141: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api3.getAttributeValue with ' || ame_util.allowDeletingOamApprovers);
2142: ame_api3.getAttributeValue(applicationIdIn => APPLICATION_ID,
2143: transactionTypeIn => AWARD_TRANSACTION_TYPE,
2144: transactionIdIn => p_transaction_id,
2145: attributeNameIn => ame_util.allowDeletingOamApprovers,
2146: itemIdIn => NULL,
2147: attributeValue1Out => l_attribute_value1,
2148: attributeValue2Out => l_attribute_value2,
2149: attributeValue3Out => l_attribute_value3);

Line 2400: FUNCTION approvers_match(p_approver1 ame_util.approverRecord,

2396:
2397: /*
2398: Returns true if p_approver1 and p_approver2 match; false otherwise.
2399: */
2400: FUNCTION approvers_match(p_approver1 ame_util.approverRecord,
2401: p_approver2 ame_util.approverRecord) RETURN BOOLEAN IS
2402: BEGIN
2403:
2404: RETURN

Line 2401: p_approver2 ame_util.approverRecord) RETURN BOOLEAN IS

2397: /*
2398: Returns true if p_approver1 and p_approver2 match; false otherwise.
2399: */
2400: FUNCTION approvers_match(p_approver1 ame_util.approverRecord,
2401: p_approver2 ame_util.approverRecord) RETURN BOOLEAN IS
2402: BEGIN
2403:
2404: RETURN
2405: NVL(((p_approver1.user_id IS NULL AND p_approver2.user_id IS NULL) OR

Line 2417: Reconstructs an ame_util.approverRecord record from a string.

2413:
2414: END approvers_match;
2415:
2416: /*
2417: Reconstructs an ame_util.approverRecord record from a string.
2418: */
2419: PROCEDURE parse_approver(p_approver_string IN VARCHAR2,
2420: p_approver OUT NOCOPY ame_util.approverRecord) IS
2421: l_start_index INTEGER;

Line 2420: p_approver OUT NOCOPY ame_util.approverRecord) IS

2416: /*
2417: Reconstructs an ame_util.approverRecord record from a string.
2418: */
2419: PROCEDURE parse_approver(p_approver_string IN VARCHAR2,
2420: p_approver OUT NOCOPY ame_util.approverRecord) IS
2421: l_start_index INTEGER;
2422: l_end_index INTEGER;
2423: l_delimiter_length INTEGER;
2424: l_field_value VARCHAR2(80);

Line 2498: Reconstructs an ame_util.approverRecord2 record from a string.

2494:
2495: END is_old_approver_record;
2496:
2497: /*
2498: Reconstructs an ame_util.approverRecord2 record from a string.
2499: */
2500: PROCEDURE parse_ame_approver( p_approver_string IN VARCHAR2, p_approver OUT NOCOPY ame_util.approverRecord2 ) IS
2501: l_start_index INTEGER;
2502: l_end_index INTEGER;

Line 2500: PROCEDURE parse_ame_approver( p_approver_string IN VARCHAR2, p_approver OUT NOCOPY ame_util.approverRecord2 ) IS

2496:
2497: /*
2498: Reconstructs an ame_util.approverRecord2 record from a string.
2499: */
2500: PROCEDURE parse_ame_approver( p_approver_string IN VARCHAR2, p_approver OUT NOCOPY ame_util.approverRecord2 ) IS
2501: l_start_index INTEGER;
2502: l_end_index INTEGER;
2503: l_delimiter_length INTEGER;
2504: l_field_value VARCHAR2(80);

Line 2619: Creates a string representation of an ame_util.approverRecord record.

2615: END parse_ame_approver;
2616:
2617:
2618: /*
2619: Creates a string representation of an ame_util.approverRecord record.
2620: */
2621: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,
2622: p_approver_string OUT NOCOPY VARCHAR2) IS
2623: BEGIN

Line 2621: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,

2617:
2618: /*
2619: Creates a string representation of an ame_util.approverRecord record.
2620: */
2621: PROCEDURE format_approver(p_approver IN ame_util.approverRecord,
2622: p_approver_string OUT NOCOPY VARCHAR2) IS
2623: BEGIN
2624:
2625: p_approver_string :=

Line 2636: Creates a string representation of an ame_util.approverRecord record.

2632:
2633: END format_approver;
2634:
2635: /*
2636: Creates a string representation of an ame_util.approverRecord record.
2637: */
2638: FUNCTION format_ame_approver(p_approver IN ame_util.approverRecord2) RETURN VARCHAR2 IS
2639:
2640: l_approver_string VARCHAR2(1500);

Line 2638: FUNCTION format_ame_approver(p_approver IN ame_util.approverRecord2) RETURN VARCHAR2 IS

2634:
2635: /*
2636: Creates a string representation of an ame_util.approverRecord record.
2637: */
2638: FUNCTION format_ame_approver(p_approver IN ame_util.approverRecord2) RETURN VARCHAR2 IS
2639:
2640: l_approver_string VARCHAR2(1500);
2641:
2642: BEGIN

Line 2674: Reconstructs an ame_util.approversTable table from a string.

2670:
2671: END format_ame_approver;
2672:
2673: /*
2674: Reconstructs an ame_util.approversTable table from a string.
2675: */
2676: PROCEDURE parse_approver_list(p_approver_list_string IN VARCHAR2,
2677: p_approver_list OUT NOCOPY ame_util.approversTable) IS
2678: l_start_index INTEGER;

Line 2677: p_approver_list OUT NOCOPY ame_util.approversTable) IS

2673: /*
2674: Reconstructs an ame_util.approversTable table from a string.
2675: */
2676: PROCEDURE parse_approver_list(p_approver_list_string IN VARCHAR2,
2677: p_approver_list OUT NOCOPY ame_util.approversTable) IS
2678: l_start_index INTEGER;
2679: l_end_index INTEGER;
2680: l_list_string_length INTEGER;
2681: l_delimiter_length INTEGER;

Line 2684: l_approver ame_util.approverRecord;

2680: l_list_string_length INTEGER;
2681: l_delimiter_length INTEGER;
2682: l_list_index INTEGER;
2683: l_approver_string VARCHAR2(240);
2684: l_approver ame_util.approverRecord;
2685: BEGIN
2686:
2687: l_list_string_length := LENGTHB(p_approver_list_string);
2688: l_delimiter_length := LENGTHB(APPROVER_RECORD_DELIMITER);

Line 2710: Creates a string representation of an ame_util.approversTable table.

2706:
2707: END parse_approver_list;
2708:
2709: /*
2710: Creates a string representation of an ame_util.approversTable table.
2711: */
2712: PROCEDURE format_approver_list(p_approver_list IN ame_util.approversTable,
2713: p_approver_list_string OUT NOCOPY VARCHAR2) IS
2714: l_approver_string VARCHAR2(240);

Line 2712: PROCEDURE format_approver_list(p_approver_list IN ame_util.approversTable,

2708:
2709: /*
2710: Creates a string representation of an ame_util.approversTable table.
2711: */
2712: PROCEDURE format_approver_list(p_approver_list IN ame_util.approversTable,
2713: p_approver_list_string OUT NOCOPY VARCHAR2) IS
2714: l_approver_string VARCHAR2(240);
2715: BEGIN
2716:

Line 2731: Creates a string representation of an ame_util.approversTable2 table.

2727:
2728: END format_approver_list;
2729:
2730: /*
2731: Creates a string representation of an ame_util.approversTable2 table.
2732: */
2733: FUNCTION format_ame_approver_list( p_approver_list IN ame_util.approversTable2) RETURN VARCHAR2 IS
2734: l_approver_list_string VARCHAR2(32000);
2735: l_approver_string VARCHAR2(1500);

Line 2733: FUNCTION format_ame_approver_list( p_approver_list IN ame_util.approversTable2) RETURN VARCHAR2 IS

2729:
2730: /*
2731: Creates a string representation of an ame_util.approversTable2 table.
2732: */
2733: FUNCTION format_ame_approver_list( p_approver_list IN ame_util.approversTable2) RETURN VARCHAR2 IS
2734: l_approver_list_string VARCHAR2(32000);
2735: l_approver_string VARCHAR2(1500);
2736: BEGIN
2737:

Line 2757: Converts the specified PON_AWARD_APPROVAL_PKG api_insertion code to a corresponding ame_util api_insertion code.

2753: END format_ame_approver_list;
2754:
2755:
2756: /*
2757: Converts the specified PON_AWARD_APPROVAL_PKG api_insertion code to a corresponding ame_util api_insertion code.
2758: */
2759: FUNCTION convert_to_ame_api_insertion(p_pon_api_insertion IN NUMBER) RETURN VARCHAR2 IS
2760: BEGIN
2761: IF p_pon_api_insertion = API_AUTHORITY_INSERTION THEN

Line 2762: RETURN ame_util.apiAuthorityInsertion;

2758: */
2759: FUNCTION convert_to_ame_api_insertion(p_pon_api_insertion IN NUMBER) RETURN VARCHAR2 IS
2760: BEGIN
2761: IF p_pon_api_insertion = API_AUTHORITY_INSERTION THEN
2762: RETURN ame_util.apiAuthorityInsertion;
2763: ELSIF p_pon_api_insertion = API_INSERTION THEN
2764: RETURN ame_util.apiInsertion;
2765: ELSIF p_pon_api_insertion = OAM_GENERATED THEN
2766: RETURN ame_util.oamGenerated;

Line 2764: RETURN ame_util.apiInsertion;

2760: BEGIN
2761: IF p_pon_api_insertion = API_AUTHORITY_INSERTION THEN
2762: RETURN ame_util.apiAuthorityInsertion;
2763: ELSIF p_pon_api_insertion = API_INSERTION THEN
2764: RETURN ame_util.apiInsertion;
2765: ELSIF p_pon_api_insertion = OAM_GENERATED THEN
2766: RETURN ame_util.oamGenerated;
2767: ELSE
2768: RETURN NULL;

Line 2766: RETURN ame_util.oamGenerated;

2762: RETURN ame_util.apiAuthorityInsertion;
2763: ELSIF p_pon_api_insertion = API_INSERTION THEN
2764: RETURN ame_util.apiInsertion;
2765: ELSIF p_pon_api_insertion = OAM_GENERATED THEN
2766: RETURN ame_util.oamGenerated;
2767: ELSE
2768: RETURN NULL;
2769: END IF;
2770: END convert_to_ame_api_insertion;

Line 2773: Converts the specified ame_util api_insertion code to a corresponding PON_AWARD_APPROVAL_PKG api_insertion code.

2769: END IF;
2770: END convert_to_ame_api_insertion;
2771:
2772: /*
2773: Converts the specified ame_util api_insertion code to a corresponding PON_AWARD_APPROVAL_PKG api_insertion code.
2774: */
2775: FUNCTION convert_to_pon_api_insertion(p_ame_api_insertion IN VARCHAR2) RETURN NUMBER IS
2776: BEGIN
2777: IF p_ame_api_insertion = ame_util.apiAuthorityInsertion THEN

Line 2777: IF p_ame_api_insertion = ame_util.apiAuthorityInsertion THEN

2773: Converts the specified ame_util api_insertion code to a corresponding PON_AWARD_APPROVAL_PKG api_insertion code.
2774: */
2775: FUNCTION convert_to_pon_api_insertion(p_ame_api_insertion IN VARCHAR2) RETURN NUMBER IS
2776: BEGIN
2777: IF p_ame_api_insertion = ame_util.apiAuthorityInsertion THEN
2778: RETURN API_AUTHORITY_INSERTION;
2779: ELSIF p_ame_api_insertion = ame_util.apiInsertion THEN
2780: RETURN API_INSERTION;
2781: ELSIF p_ame_api_insertion = ame_util.oamGenerated THEN

Line 2779: ELSIF p_ame_api_insertion = ame_util.apiInsertion THEN

2775: FUNCTION convert_to_pon_api_insertion(p_ame_api_insertion IN VARCHAR2) RETURN NUMBER IS
2776: BEGIN
2777: IF p_ame_api_insertion = ame_util.apiAuthorityInsertion THEN
2778: RETURN API_AUTHORITY_INSERTION;
2779: ELSIF p_ame_api_insertion = ame_util.apiInsertion THEN
2780: RETURN API_INSERTION;
2781: ELSIF p_ame_api_insertion = ame_util.oamGenerated THEN
2782: RETURN OAM_GENERATED;
2783: ELSE

Line 2781: ELSIF p_ame_api_insertion = ame_util.oamGenerated THEN

2777: IF p_ame_api_insertion = ame_util.apiAuthorityInsertion THEN
2778: RETURN API_AUTHORITY_INSERTION;
2779: ELSIF p_ame_api_insertion = ame_util.apiInsertion THEN
2780: RETURN API_INSERTION;
2781: ELSIF p_ame_api_insertion = ame_util.oamGenerated THEN
2782: RETURN OAM_GENERATED;
2783: ELSE
2784: RETURN NULL;
2785: END IF;

Line 2789: Converts the specified PON_AWARD_APPROVAL_PKG authority code to a corresponding ame_util authority code.

2785: END IF;
2786: END convert_to_pon_api_insertion;
2787:
2788: /*
2789: Converts the specified PON_AWARD_APPROVAL_PKG authority code to a corresponding ame_util authority code.
2790: */
2791: FUNCTION convert_to_ame_authority(p_pon_authority IN NUMBER) RETURN VARCHAR2 IS
2792: BEGIN
2793: IF p_pon_authority = PRE_APPROVER THEN

Line 2794: RETURN ame_util.preApprover;

2790: */
2791: FUNCTION convert_to_ame_authority(p_pon_authority IN NUMBER) RETURN VARCHAR2 IS
2792: BEGIN
2793: IF p_pon_authority = PRE_APPROVER THEN
2794: RETURN ame_util.preApprover;
2795: ELSIF p_pon_authority = AUTHORITY_APPROVER THEN
2796: RETURN ame_util.authorityApprover;
2797: ELSIF p_pon_authority = POST_APPROVER THEN
2798: RETURN ame_util.postApprover;

Line 2796: RETURN ame_util.authorityApprover;

2792: BEGIN
2793: IF p_pon_authority = PRE_APPROVER THEN
2794: RETURN ame_util.preApprover;
2795: ELSIF p_pon_authority = AUTHORITY_APPROVER THEN
2796: RETURN ame_util.authorityApprover;
2797: ELSIF p_pon_authority = POST_APPROVER THEN
2798: RETURN ame_util.postApprover;
2799: ELSE
2800: RETURN NULL;

Line 2798: RETURN ame_util.postApprover;

2794: RETURN ame_util.preApprover;
2795: ELSIF p_pon_authority = AUTHORITY_APPROVER THEN
2796: RETURN ame_util.authorityApprover;
2797: ELSIF p_pon_authority = POST_APPROVER THEN
2798: RETURN ame_util.postApprover;
2799: ELSE
2800: RETURN NULL;
2801: END IF;
2802: END convert_to_ame_authority;

Line 2805: Converts the specified ame_util authority code to a corresponding PON_AWARD_APPROVAL_PKG authority code.

2801: END IF;
2802: END convert_to_ame_authority;
2803:
2804: /*
2805: Converts the specified ame_util authority code to a corresponding PON_AWARD_APPROVAL_PKG authority code.
2806: */
2807: FUNCTION convert_to_pon_authority(p_ame_authority IN VARCHAR2) RETURN NUMBER IS
2808: BEGIN
2809: IF p_ame_authority = ame_util.preApprover THEN

Line 2809: IF p_ame_authority = ame_util.preApprover THEN

2805: Converts the specified ame_util authority code to a corresponding PON_AWARD_APPROVAL_PKG authority code.
2806: */
2807: FUNCTION convert_to_pon_authority(p_ame_authority IN VARCHAR2) RETURN NUMBER IS
2808: BEGIN
2809: IF p_ame_authority = ame_util.preApprover THEN
2810: RETURN PRE_APPROVER;
2811: ELSIF p_ame_authority = ame_util.authorityApprover THEN
2812: RETURN AUTHORITY_APPROVER;
2813: ELSIF p_ame_authority = ame_util.postApprover THEN

Line 2811: ELSIF p_ame_authority = ame_util.authorityApprover THEN

2807: FUNCTION convert_to_pon_authority(p_ame_authority IN VARCHAR2) RETURN NUMBER IS
2808: BEGIN
2809: IF p_ame_authority = ame_util.preApprover THEN
2810: RETURN PRE_APPROVER;
2811: ELSIF p_ame_authority = ame_util.authorityApprover THEN
2812: RETURN AUTHORITY_APPROVER;
2813: ELSIF p_ame_authority = ame_util.postApprover THEN
2814: RETURN POST_APPROVER;
2815: ELSE

Line 2813: ELSIF p_ame_authority = ame_util.postApprover THEN

2809: IF p_ame_authority = ame_util.preApprover THEN
2810: RETURN PRE_APPROVER;
2811: ELSIF p_ame_authority = ame_util.authorityApprover THEN
2812: RETURN AUTHORITY_APPROVER;
2813: ELSIF p_ame_authority = ame_util.postApprover THEN
2814: RETURN POST_APPROVER;
2815: ELSE
2816: RETURN NULL;
2817: END IF;

Line 2821: Converts the specified PON_AWARD_APPROVAL_PKG approval_status code to a corresponding ame_util approval_status code.

2817: END IF;
2818: END convert_to_pon_authority;
2819:
2820: /*
2821: Converts the specified PON_AWARD_APPROVAL_PKG approval_status code to a corresponding ame_util approval_status code.
2822: */
2823: FUNCTION convert_to_ame_approval_status(p_pon_approval_status IN NUMBER) RETURN VARCHAR2 IS
2824: BEGIN
2825: IF p_pon_approval_status = APPROVE_AND_FORWARD_STATUS THEN

Line 2826: RETURN ame_util.approveAndForwardStatus;

2822: */
2823: FUNCTION convert_to_ame_approval_status(p_pon_approval_status IN NUMBER) RETURN VARCHAR2 IS
2824: BEGIN
2825: IF p_pon_approval_status = APPROVE_AND_FORWARD_STATUS THEN
2826: RETURN ame_util.approveAndForwardStatus;
2827: ELSIF p_pon_approval_status = APPROVED_STATUS THEN
2828: RETURN ame_util.approvedStatus;
2829: ELSIF p_pon_approval_status = CLEAR_EXCEPTIONS_STATUS THEN
2830: RETURN ame_util.clearExceptionsStatus;

Line 2828: RETURN ame_util.approvedStatus;

2824: BEGIN
2825: IF p_pon_approval_status = APPROVE_AND_FORWARD_STATUS THEN
2826: RETURN ame_util.approveAndForwardStatus;
2827: ELSIF p_pon_approval_status = APPROVED_STATUS THEN
2828: RETURN ame_util.approvedStatus;
2829: ELSIF p_pon_approval_status = CLEAR_EXCEPTIONS_STATUS THEN
2830: RETURN ame_util.clearExceptionsStatus;
2831: ELSIF p_pon_approval_status = EXCEPTION_STATUS THEN
2832: RETURN ame_util.exceptionStatus;

Line 2830: RETURN ame_util.clearExceptionsStatus;

2826: RETURN ame_util.approveAndForwardStatus;
2827: ELSIF p_pon_approval_status = APPROVED_STATUS THEN
2828: RETURN ame_util.approvedStatus;
2829: ELSIF p_pon_approval_status = CLEAR_EXCEPTIONS_STATUS THEN
2830: RETURN ame_util.clearExceptionsStatus;
2831: ELSIF p_pon_approval_status = EXCEPTION_STATUS THEN
2832: RETURN ame_util.exceptionStatus;
2833: ELSIF p_pon_approval_status = FORWARD_STATUS THEN
2834: RETURN ame_util.forwardStatus;

Line 2832: RETURN ame_util.exceptionStatus;

2828: RETURN ame_util.approvedStatus;
2829: ELSIF p_pon_approval_status = CLEAR_EXCEPTIONS_STATUS THEN
2830: RETURN ame_util.clearExceptionsStatus;
2831: ELSIF p_pon_approval_status = EXCEPTION_STATUS THEN
2832: RETURN ame_util.exceptionStatus;
2833: ELSIF p_pon_approval_status = FORWARD_STATUS THEN
2834: RETURN ame_util.forwardStatus;
2835: ELSIF p_pon_approval_status = NO_RESPONSE_STATUS THEN
2836: RETURN ame_util.noResponseStatus;

Line 2834: RETURN ame_util.forwardStatus;

2830: RETURN ame_util.clearExceptionsStatus;
2831: ELSIF p_pon_approval_status = EXCEPTION_STATUS THEN
2832: RETURN ame_util.exceptionStatus;
2833: ELSIF p_pon_approval_status = FORWARD_STATUS THEN
2834: RETURN ame_util.forwardStatus;
2835: ELSIF p_pon_approval_status = NO_RESPONSE_STATUS THEN
2836: RETURN ame_util.noResponseStatus;
2837: /*
2838: ELSIF p_pon_approval_status = NOTIFIED_STATUS THEN

Line 2836: RETURN ame_util.noResponseStatus;

2832: RETURN ame_util.exceptionStatus;
2833: ELSIF p_pon_approval_status = FORWARD_STATUS THEN
2834: RETURN ame_util.forwardStatus;
2835: ELSIF p_pon_approval_status = NO_RESPONSE_STATUS THEN
2836: RETURN ame_util.noResponseStatus;
2837: /*
2838: ELSIF p_pon_approval_status = NOTIFIED_STATUS THEN
2839: RETURN ame_util.notifiedStatus;
2840: */

Line 2839: RETURN ame_util.notifiedStatus;

2835: ELSIF p_pon_approval_status = NO_RESPONSE_STATUS THEN
2836: RETURN ame_util.noResponseStatus;
2837: /*
2838: ELSIF p_pon_approval_status = NOTIFIED_STATUS THEN
2839: RETURN ame_util.notifiedStatus;
2840: */
2841: ELSIF p_pon_approval_status = REJECT_STATUS THEN
2842: RETURN ame_util.rejectStatus;
2843: /*

Line 2842: RETURN ame_util.rejectStatus;

2838: ELSIF p_pon_approval_status = NOTIFIED_STATUS THEN
2839: RETURN ame_util.notifiedStatus;
2840: */
2841: ELSIF p_pon_approval_status = REJECT_STATUS THEN
2842: RETURN ame_util.rejectStatus;
2843: /*
2844: ELSIF p_pon_approval_status = REPEATED_STATUS THEN
2845: RETURN ame_util.repeatedStatus;
2846: ELSIF p_pon_approval_status = SUPPRESSED_STATUS THEN

Line 2845: RETURN ame_util.repeatedStatus;

2841: ELSIF p_pon_approval_status = REJECT_STATUS THEN
2842: RETURN ame_util.rejectStatus;
2843: /*
2844: ELSIF p_pon_approval_status = REPEATED_STATUS THEN
2845: RETURN ame_util.repeatedStatus;
2846: ELSIF p_pon_approval_status = SUPPRESSED_STATUS THEN
2847: RETURN ame_util.suppressedStatus;
2848: */
2849: ELSIF p_pon_approval_status = NULL_STATUS THEN

Line 2847: RETURN ame_util.suppressedStatus;

2843: /*
2844: ELSIF p_pon_approval_status = REPEATED_STATUS THEN
2845: RETURN ame_util.repeatedStatus;
2846: ELSIF p_pon_approval_status = SUPPRESSED_STATUS THEN
2847: RETURN ame_util.suppressedStatus;
2848: */
2849: ELSIF p_pon_approval_status = NULL_STATUS THEN
2850: RETURN ame_util.nullStatus;
2851: ELSE

Line 2850: RETURN ame_util.nullStatus;

2846: ELSIF p_pon_approval_status = SUPPRESSED_STATUS THEN
2847: RETURN ame_util.suppressedStatus;
2848: */
2849: ELSIF p_pon_approval_status = NULL_STATUS THEN
2850: RETURN ame_util.nullStatus;
2851: ELSE
2852: RETURN NULL;
2853: END IF;
2854: END convert_to_ame_approval_status;

Line 2857: Converts the specified ame_util approval_status code to a corresponding PON_AWARD_APPROVAL_PKG approval_status code.

2853: END IF;
2854: END convert_to_ame_approval_status;
2855:
2856: /*
2857: Converts the specified ame_util approval_status code to a corresponding PON_AWARD_APPROVAL_PKG approval_status code.
2858: */
2859: FUNCTION convert_to_pon_approval_status(p_ame_approval_status IN VARCHAR2) RETURN NUMBER IS
2860: BEGIN
2861: IF p_ame_approval_status = ame_util.approveAndForwardStatus THEN

Line 2861: IF p_ame_approval_status = ame_util.approveAndForwardStatus THEN

2857: Converts the specified ame_util approval_status code to a corresponding PON_AWARD_APPROVAL_PKG approval_status code.
2858: */
2859: FUNCTION convert_to_pon_approval_status(p_ame_approval_status IN VARCHAR2) RETURN NUMBER IS
2860: BEGIN
2861: IF p_ame_approval_status = ame_util.approveAndForwardStatus THEN
2862: RETURN APPROVE_AND_FORWARD_STATUS;
2863: ELSIF p_ame_approval_status = ame_util.approvedStatus THEN
2864: RETURN APPROVED_STATUS;
2865: ELSIF p_ame_approval_status = ame_util.clearExceptionsStatus THEN

Line 2863: ELSIF p_ame_approval_status = ame_util.approvedStatus THEN

2859: FUNCTION convert_to_pon_approval_status(p_ame_approval_status IN VARCHAR2) RETURN NUMBER IS
2860: BEGIN
2861: IF p_ame_approval_status = ame_util.approveAndForwardStatus THEN
2862: RETURN APPROVE_AND_FORWARD_STATUS;
2863: ELSIF p_ame_approval_status = ame_util.approvedStatus THEN
2864: RETURN APPROVED_STATUS;
2865: ELSIF p_ame_approval_status = ame_util.clearExceptionsStatus THEN
2866: RETURN CLEAR_EXCEPTIONS_STATUS;
2867: ELSIF p_ame_approval_status = ame_util.exceptionStatus THEN

Line 2865: ELSIF p_ame_approval_status = ame_util.clearExceptionsStatus THEN

2861: IF p_ame_approval_status = ame_util.approveAndForwardStatus THEN
2862: RETURN APPROVE_AND_FORWARD_STATUS;
2863: ELSIF p_ame_approval_status = ame_util.approvedStatus THEN
2864: RETURN APPROVED_STATUS;
2865: ELSIF p_ame_approval_status = ame_util.clearExceptionsStatus THEN
2866: RETURN CLEAR_EXCEPTIONS_STATUS;
2867: ELSIF p_ame_approval_status = ame_util.exceptionStatus THEN
2868: RETURN EXCEPTION_STATUS;
2869: ELSIF p_ame_approval_status = ame_util.forwardStatus THEN

Line 2867: ELSIF p_ame_approval_status = ame_util.exceptionStatus THEN

2863: ELSIF p_ame_approval_status = ame_util.approvedStatus THEN
2864: RETURN APPROVED_STATUS;
2865: ELSIF p_ame_approval_status = ame_util.clearExceptionsStatus THEN
2866: RETURN CLEAR_EXCEPTIONS_STATUS;
2867: ELSIF p_ame_approval_status = ame_util.exceptionStatus THEN
2868: RETURN EXCEPTION_STATUS;
2869: ELSIF p_ame_approval_status = ame_util.forwardStatus THEN
2870: RETURN FORWARD_STATUS;
2871: ELSIF p_ame_approval_status = ame_util.noResponseStatus THEN

Line 2869: ELSIF p_ame_approval_status = ame_util.forwardStatus THEN

2865: ELSIF p_ame_approval_status = ame_util.clearExceptionsStatus THEN
2866: RETURN CLEAR_EXCEPTIONS_STATUS;
2867: ELSIF p_ame_approval_status = ame_util.exceptionStatus THEN
2868: RETURN EXCEPTION_STATUS;
2869: ELSIF p_ame_approval_status = ame_util.forwardStatus THEN
2870: RETURN FORWARD_STATUS;
2871: ELSIF p_ame_approval_status = ame_util.noResponseStatus THEN
2872: RETURN NO_RESPONSE_STATUS;
2873: /*

Line 2871: ELSIF p_ame_approval_status = ame_util.noResponseStatus THEN

2867: ELSIF p_ame_approval_status = ame_util.exceptionStatus THEN
2868: RETURN EXCEPTION_STATUS;
2869: ELSIF p_ame_approval_status = ame_util.forwardStatus THEN
2870: RETURN FORWARD_STATUS;
2871: ELSIF p_ame_approval_status = ame_util.noResponseStatus THEN
2872: RETURN NO_RESPONSE_STATUS;
2873: /*
2874: ELSIF p_ame_approval_status = ame_util.notifiedStatus THEN
2875: RETURN NOTIFIED_STATUS;

Line 2874: ELSIF p_ame_approval_status = ame_util.notifiedStatus THEN

2870: RETURN FORWARD_STATUS;
2871: ELSIF p_ame_approval_status = ame_util.noResponseStatus THEN
2872: RETURN NO_RESPONSE_STATUS;
2873: /*
2874: ELSIF p_ame_approval_status = ame_util.notifiedStatus THEN
2875: RETURN NOTIFIED_STATUS;
2876: */
2877: ELSIF p_ame_approval_status = ame_util.rejectStatus THEN
2878: RETURN REJECT_STATUS;

Line 2877: ELSIF p_ame_approval_status = ame_util.rejectStatus THEN

2873: /*
2874: ELSIF p_ame_approval_status = ame_util.notifiedStatus THEN
2875: RETURN NOTIFIED_STATUS;
2876: */
2877: ELSIF p_ame_approval_status = ame_util.rejectStatus THEN
2878: RETURN REJECT_STATUS;
2879: /*
2880: ELSIF p_ame_approval_status = ame_util.repeatedStatus THEN
2881: RETURN REPEATED_STATUS;

Line 2880: ELSIF p_ame_approval_status = ame_util.repeatedStatus THEN

2876: */
2877: ELSIF p_ame_approval_status = ame_util.rejectStatus THEN
2878: RETURN REJECT_STATUS;
2879: /*
2880: ELSIF p_ame_approval_status = ame_util.repeatedStatus THEN
2881: RETURN REPEATED_STATUS;
2882: ELSIF p_ame_approval_status = ame_util.suppressedStatus THEN
2883: RETURN SUPPRESSED_STATUS;
2884: */

Line 2882: ELSIF p_ame_approval_status = ame_util.suppressedStatus THEN

2878: RETURN REJECT_STATUS;
2879: /*
2880: ELSIF p_ame_approval_status = ame_util.repeatedStatus THEN
2881: RETURN REPEATED_STATUS;
2882: ELSIF p_ame_approval_status = ame_util.suppressedStatus THEN
2883: RETURN SUPPRESSED_STATUS;
2884: */
2885: ELSIF p_ame_approval_status IS NULL THEN
2886: RETURN NULL_STATUS;

Line 3124: Returns a string representation of an ame_util.insertionsTable.

3120: END log_string;
3121:
3122:
3123: /*
3124: Returns a string representation of an ame_util.insertionsTable.
3125: */
3126: FUNCTION get_insertion_list_string(p_insertion_list IN ame_util.insertionsTable2) RETURN VARCHAR2 IS
3127: l_insertion_list_string VARCHAR2(4000);
3128: BEGIN

Line 3126: FUNCTION get_insertion_list_string(p_insertion_list IN ame_util.insertionsTable2) RETURN VARCHAR2 IS

3122:
3123: /*
3124: Returns a string representation of an ame_util.insertionsTable.
3125: */
3126: FUNCTION get_insertion_list_string(p_insertion_list IN ame_util.insertionsTable2) RETURN VARCHAR2 IS
3127: l_insertion_list_string VARCHAR2(4000);
3128: BEGIN
3129:
3130: FOR i IN 1 .. p_insertion_list.COUNT LOOP

Line 3151: FUNCTION get_insertion_string(p_approver IN ame_util.approverRecord2, p_order IN ame_util.insertionRecord2) RETURN VARCHAR2 IS

3147:
3148: END get_insertion_list_string;
3149:
3150:
3151: FUNCTION get_insertion_string(p_approver IN ame_util.approverRecord2, p_order IN ame_util.insertionRecord2) RETURN VARCHAR2 IS
3152: BEGIN
3153:
3154: RETURN format_ame_approver(p_approver) || ' ' || '(' || get_order_type_string(p_order.order_type) || ', ' || get_parameter_string(p_order.parameter) || ')';
3155:

Line 3159: Returns a string representation of the value of an ame_util.approverRecord's api_insertion field.

3155:
3156: END get_insertion_string;
3157:
3158: /*
3159: Returns a string representation of the value of an ame_util.approverRecord's api_insertion field.
3160: */
3161: FUNCTION get_api_insertion_string(p_api_insertion IN VARCHAR2) RETURN VARCHAR2 IS
3162: BEGIN
3163:

Line 3164: IF p_api_insertion = ame_util.oamGenerated THEN

3160: */
3161: FUNCTION get_api_insertion_string(p_api_insertion IN VARCHAR2) RETURN VARCHAR2 IS
3162: BEGIN
3163:
3164: IF p_api_insertion = ame_util.oamGenerated THEN
3165: RETURN 'oamGenerated';
3166: ELSIF p_api_insertion = ame_util.apiAuthorityInsertion THEN
3167: RETURN 'apiAuthorityInsertion';
3168: ELSIF p_api_insertion = ame_util.apiInsertion THEN

Line 3166: ELSIF p_api_insertion = ame_util.apiAuthorityInsertion THEN

3162: BEGIN
3163:
3164: IF p_api_insertion = ame_util.oamGenerated THEN
3165: RETURN 'oamGenerated';
3166: ELSIF p_api_insertion = ame_util.apiAuthorityInsertion THEN
3167: RETURN 'apiAuthorityInsertion';
3168: ELSIF p_api_insertion = ame_util.apiInsertion THEN
3169: RETURN 'apiInsertion';
3170: ELSE

Line 3168: ELSIF p_api_insertion = ame_util.apiInsertion THEN

3164: IF p_api_insertion = ame_util.oamGenerated THEN
3165: RETURN 'oamGenerated';
3166: ELSIF p_api_insertion = ame_util.apiAuthorityInsertion THEN
3167: RETURN 'apiAuthorityInsertion';
3168: ELSIF p_api_insertion = ame_util.apiInsertion THEN
3169: RETURN 'apiInsertion';
3170: ELSE
3171: RETURN NULL;
3172: END IF;

Line 3177: Returns a string representation of the value of an ame_util.approverRecord's authority field.

3173:
3174: END get_api_insertion_string;
3175:
3176: /*
3177: Returns a string representation of the value of an ame_util.approverRecord's authority field.
3178: */
3179: FUNCTION get_authority_string(p_authority IN VARCHAR2) RETURN VARCHAR2 IS
3180: BEGIN
3181:

Line 3182: IF p_authority = ame_util.preApprover THEN

3178: */
3179: FUNCTION get_authority_string(p_authority IN VARCHAR2) RETURN VARCHAR2 IS
3180: BEGIN
3181:
3182: IF p_authority = ame_util.preApprover THEN
3183: RETURN 'preApprover';
3184: ELSIF p_authority = ame_util.authorityApprover THEN
3185: RETURN 'authorityApprover';
3186: ELSIF p_authority = ame_util.postApprover THEN

Line 3184: ELSIF p_authority = ame_util.authorityApprover THEN

3180: BEGIN
3181:
3182: IF p_authority = ame_util.preApprover THEN
3183: RETURN 'preApprover';
3184: ELSIF p_authority = ame_util.authorityApprover THEN
3185: RETURN 'authorityApprover';
3186: ELSIF p_authority = ame_util.postApprover THEN
3187: RETURN 'postApprover';
3188: ELSE

Line 3186: ELSIF p_authority = ame_util.postApprover THEN

3182: IF p_authority = ame_util.preApprover THEN
3183: RETURN 'preApprover';
3184: ELSIF p_authority = ame_util.authorityApprover THEN
3185: RETURN 'authorityApprover';
3186: ELSIF p_authority = ame_util.postApprover THEN
3187: RETURN 'postApprover';
3188: ELSE
3189: RETURN NULL;
3190: END IF;

Line 3195: Returns a string representation of the value of an ame_util.approverRecord's approval_status field.

3191:
3192: END get_authority_string;
3193:
3194: /*
3195: Returns a string representation of the value of an ame_util.approverRecord's approval_status field.
3196: */
3197: FUNCTION get_approval_status_string(p_approval_status IN VARCHAR2) RETURN VARCHAR2 IS
3198: BEGIN
3199:

Line 3200: IF p_approval_status = ame_util.approveAndForwardStatus THEN

3196: */
3197: FUNCTION get_approval_status_string(p_approval_status IN VARCHAR2) RETURN VARCHAR2 IS
3198: BEGIN
3199:
3200: IF p_approval_status = ame_util.approveAndForwardStatus THEN
3201: RETURN 'approveAndForwardStatus';
3202: ELSIF p_approval_status = ame_util.approvedStatus THEN
3203: RETURN 'approvedStatus';
3204: ELSIF p_approval_status = ame_util.clearExceptionsStatus THEN

Line 3202: ELSIF p_approval_status = ame_util.approvedStatus THEN

3198: BEGIN
3199:
3200: IF p_approval_status = ame_util.approveAndForwardStatus THEN
3201: RETURN 'approveAndForwardStatus';
3202: ELSIF p_approval_status = ame_util.approvedStatus THEN
3203: RETURN 'approvedStatus';
3204: ELSIF p_approval_status = ame_util.clearExceptionsStatus THEN
3205: RETURN 'clearExceptionsStatus';
3206: ELSIF p_approval_status = ame_util.exceptionStatus THEN

Line 3204: ELSIF p_approval_status = ame_util.clearExceptionsStatus THEN

3200: IF p_approval_status = ame_util.approveAndForwardStatus THEN
3201: RETURN 'approveAndForwardStatus';
3202: ELSIF p_approval_status = ame_util.approvedStatus THEN
3203: RETURN 'approvedStatus';
3204: ELSIF p_approval_status = ame_util.clearExceptionsStatus THEN
3205: RETURN 'clearExceptionsStatus';
3206: ELSIF p_approval_status = ame_util.exceptionStatus THEN
3207: RETURN 'exceptionStatus';
3208: ELSIF p_approval_status = ame_util.forwardStatus THEN

Line 3206: ELSIF p_approval_status = ame_util.exceptionStatus THEN

3202: ELSIF p_approval_status = ame_util.approvedStatus THEN
3203: RETURN 'approvedStatus';
3204: ELSIF p_approval_status = ame_util.clearExceptionsStatus THEN
3205: RETURN 'clearExceptionsStatus';
3206: ELSIF p_approval_status = ame_util.exceptionStatus THEN
3207: RETURN 'exceptionStatus';
3208: ELSIF p_approval_status = ame_util.forwardStatus THEN
3209: RETURN 'forwardStatus';
3210: ELSIF p_approval_status = ame_util.noResponseStatus THEN

Line 3208: ELSIF p_approval_status = ame_util.forwardStatus THEN

3204: ELSIF p_approval_status = ame_util.clearExceptionsStatus THEN
3205: RETURN 'clearExceptionsStatus';
3206: ELSIF p_approval_status = ame_util.exceptionStatus THEN
3207: RETURN 'exceptionStatus';
3208: ELSIF p_approval_status = ame_util.forwardStatus THEN
3209: RETURN 'forwardStatus';
3210: ELSIF p_approval_status = ame_util.noResponseStatus THEN
3211: RETURN 'noResponseStatus';
3212: /*

Line 3210: ELSIF p_approval_status = ame_util.noResponseStatus THEN

3206: ELSIF p_approval_status = ame_util.exceptionStatus THEN
3207: RETURN 'exceptionStatus';
3208: ELSIF p_approval_status = ame_util.forwardStatus THEN
3209: RETURN 'forwardStatus';
3210: ELSIF p_approval_status = ame_util.noResponseStatus THEN
3211: RETURN 'noResponseStatus';
3212: /*
3213: ELSIF p_approval_status = ame_util.notifiedStatus THEN
3214: RETURN 'notifiedStatus';

Line 3213: ELSIF p_approval_status = ame_util.notifiedStatus THEN

3209: RETURN 'forwardStatus';
3210: ELSIF p_approval_status = ame_util.noResponseStatus THEN
3211: RETURN 'noResponseStatus';
3212: /*
3213: ELSIF p_approval_status = ame_util.notifiedStatus THEN
3214: RETURN 'notifiedStatus';
3215: */
3216: ELSIF p_approval_status = ame_util.rejectStatus THEN
3217: RETURN 'rejectStatus';

Line 3216: ELSIF p_approval_status = ame_util.rejectStatus THEN

3212: /*
3213: ELSIF p_approval_status = ame_util.notifiedStatus THEN
3214: RETURN 'notifiedStatus';
3215: */
3216: ELSIF p_approval_status = ame_util.rejectStatus THEN
3217: RETURN 'rejectStatus';
3218: /*
3219: ELSIF p_approval_status = ame_util.repeatedStatus THEN
3220: RETURN 'repeatedStatus';

Line 3219: ELSIF p_approval_status = ame_util.repeatedStatus THEN

3215: */
3216: ELSIF p_approval_status = ame_util.rejectStatus THEN
3217: RETURN 'rejectStatus';
3218: /*
3219: ELSIF p_approval_status = ame_util.repeatedStatus THEN
3220: RETURN 'repeatedStatus';
3221: ELSIF p_approval_status = ame_util.suppressedStatus THEN
3222: RETURN 'suppressedStatus';
3223: */

Line 3221: ELSIF p_approval_status = ame_util.suppressedStatus THEN

3217: RETURN 'rejectStatus';
3218: /*
3219: ELSIF p_approval_status = ame_util.repeatedStatus THEN
3220: RETURN 'repeatedStatus';
3221: ELSIF p_approval_status = ame_util.suppressedStatus THEN
3222: RETURN 'suppressedStatus';
3223: */
3224: ELSIF p_approval_status IS NULL THEN
3225: RETURN 'nullStatus';

Line 3233: Returns a string representation of the value of an ame_util.orderRecord's or ame_util.insertionRecord's order_type field.

3229:
3230: END get_approval_status_string;
3231:
3232: /*
3233: Returns a string representation of the value of an ame_util.orderRecord's or ame_util.insertionRecord's order_type field.
3234: */
3235: FUNCTION get_order_type_string(p_order_type IN VARCHAR2) RETURN VARCHAR2 IS
3236: BEGIN
3237:

Line 3238: IF p_order_type = ame_util.absoluteOrder THEN

3234: */
3235: FUNCTION get_order_type_string(p_order_type IN VARCHAR2) RETURN VARCHAR2 IS
3236: BEGIN
3237:
3238: IF p_order_type = ame_util.absoluteOrder THEN
3239: RETURN 'absoluteOrder';
3240: ELSIF p_order_type = ame_util.afterApprover THEN
3241: RETURN 'afterApprover';
3242: ELSIF p_order_type = ame_util.beforeApprover THEN

Line 3240: ELSIF p_order_type = ame_util.afterApprover THEN

3236: BEGIN
3237:
3238: IF p_order_type = ame_util.absoluteOrder THEN
3239: RETURN 'absoluteOrder';
3240: ELSIF p_order_type = ame_util.afterApprover THEN
3241: RETURN 'afterApprover';
3242: ELSIF p_order_type = ame_util.beforeApprover THEN
3243: RETURN 'beforeApprover';
3244: ELSIF p_order_type = ame_util.firstAuthority THEN

Line 3242: ELSIF p_order_type = ame_util.beforeApprover THEN

3238: IF p_order_type = ame_util.absoluteOrder THEN
3239: RETURN 'absoluteOrder';
3240: ELSIF p_order_type = ame_util.afterApprover THEN
3241: RETURN 'afterApprover';
3242: ELSIF p_order_type = ame_util.beforeApprover THEN
3243: RETURN 'beforeApprover';
3244: ELSIF p_order_type = ame_util.firstAuthority THEN
3245: RETURN 'firstAuthority';
3246: ELSIF p_order_type = ame_util.firstPostApprover THEN

Line 3244: ELSIF p_order_type = ame_util.firstAuthority THEN

3240: ELSIF p_order_type = ame_util.afterApprover THEN
3241: RETURN 'afterApprover';
3242: ELSIF p_order_type = ame_util.beforeApprover THEN
3243: RETURN 'beforeApprover';
3244: ELSIF p_order_type = ame_util.firstAuthority THEN
3245: RETURN 'firstAuthority';
3246: ELSIF p_order_type = ame_util.firstPostApprover THEN
3247: RETURN 'firstPostApprover';
3248: ELSIF p_order_type = ame_util.firstPreApprover THEN

Line 3246: ELSIF p_order_type = ame_util.firstPostApprover THEN

3242: ELSIF p_order_type = ame_util.beforeApprover THEN
3243: RETURN 'beforeApprover';
3244: ELSIF p_order_type = ame_util.firstAuthority THEN
3245: RETURN 'firstAuthority';
3246: ELSIF p_order_type = ame_util.firstPostApprover THEN
3247: RETURN 'firstPostApprover';
3248: ELSIF p_order_type = ame_util.firstPreApprover THEN
3249: RETURN 'firstPreApprover';
3250: ELSIF p_order_type = ame_util.lastPostApprover THEN

Line 3248: ELSIF p_order_type = ame_util.firstPreApprover THEN

3244: ELSIF p_order_type = ame_util.firstAuthority THEN
3245: RETURN 'firstAuthority';
3246: ELSIF p_order_type = ame_util.firstPostApprover THEN
3247: RETURN 'firstPostApprover';
3248: ELSIF p_order_type = ame_util.firstPreApprover THEN
3249: RETURN 'firstPreApprover';
3250: ELSIF p_order_type = ame_util.lastPostApprover THEN
3251: RETURN 'lastPostApprover';
3252: ELSIF p_order_type = ame_util.lastPreApprover THEN

Line 3250: ELSIF p_order_type = ame_util.lastPostApprover THEN

3246: ELSIF p_order_type = ame_util.firstPostApprover THEN
3247: RETURN 'firstPostApprover';
3248: ELSIF p_order_type = ame_util.firstPreApprover THEN
3249: RETURN 'firstPreApprover';
3250: ELSIF p_order_type = ame_util.lastPostApprover THEN
3251: RETURN 'lastPostApprover';
3252: ELSIF p_order_type = ame_util.lastPreApprover THEN
3253: RETURN 'lastPreApprover';
3254: ELSIF p_order_type IS NULL THEN

Line 3252: ELSIF p_order_type = ame_util.lastPreApprover THEN

3248: ELSIF p_order_type = ame_util.firstPreApprover THEN
3249: RETURN 'firstPreApprover';
3250: ELSIF p_order_type = ame_util.lastPostApprover THEN
3251: RETURN 'lastPostApprover';
3252: ELSIF p_order_type = ame_util.lastPreApprover THEN
3253: RETURN 'lastPreApprover';
3254: ELSIF p_order_type IS NULL THEN
3255: RETURN 'nullOrderType';
3256: ELSE

Line 3263: Returns a string representation of the value of an ame_util.orderRecord's or ame_util.insertionRecord's parameter field.

3259:
3260: END get_order_type_string;
3261:
3262: /*
3263: Returns a string representation of the value of an ame_util.orderRecord's or ame_util.insertionRecord's parameter field.
3264: */
3265: FUNCTION get_parameter_string(p_parameter IN VARCHAR2) RETURN VARCHAR2 IS
3266: BEGIN
3267: