DBA Data[Home] [Help]

APPS.OKL_FUNDING_WF dependencies on OKL_ACCOUNTING_UTIL

Line 811: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

807: || '';
808:
809: -- Funding Number, Funding type
810: l_message := l_message || ''
814: || ''
817: || ''
821: || '';
825:
826: -- Vendor Name, Vendor Site Code
827: l_message := l_message || ''
831: || ''
834: || ''
838: || '
865:
866:

Line 868: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

864: || '
865:


866:
867:
871:
872:

Line 878: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

874:
875: -- Vendor Name, Vendor Site Code
876:
877: l_message := l_message || '


881:
882:

Line 884: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

880: || '
881:


882:
883:
887:
888:

Line 899: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

895: l_message := l_message || '

';
896:
897: -- Currency
898: l_message := l_message || '

Line 916: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

912: -- "Funding Details" Sub Head
913: l_message := l_message || '


914:
920:
931:
935:
936:
935:
936:

Line 949: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_SUMMY',

945: -- Funding Remaining
946: l_message := l_message || '
947:


948:
952:
953:
952:
953:
958:

Line 965: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

961: -- Due Date
962: l_message := l_message || '
963:


964:
968:
969:
984:
990:
1002:
1006:
1007:
1016:
1020:
1021:
1039:
1045:
1057:
1061:
1062:
1071:
1075:
1076:
1075:
1076:
1081:

Line 1103: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1099: END IF;
1100: END LOOP;
1101:
1102: IF l_flag = 'Passed' THEN
1103: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1104: p_attribute_code => 'OKL_PASSED');
1105: ELSIF l_flag = 'Failed' THEN
1106: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1107: p_attribute_code => 'OKL_FAILED');

Line 1106: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1102: IF l_flag = 'Passed' THEN
1103: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1104: p_attribute_code => 'OKL_PASSED');
1105: ELSIF l_flag = 'Failed' THEN
1106: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1107: p_attribute_code => 'OKL_FAILED');
1108: END IF;
1109:
1110: -- Checklist Validation Result

Line 1112: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',

1108: END IF;
1109:
1110: -- Checklist Validation Result
1111: l_message := l_message || '

'
1115: || '';
1141:
1142: -- Description

Line 1144: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1140: || '';
1141:
1142: -- Description
1143: l_message := l_message || '

';
1150:
1151: -- Function

Line 1153: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1149: || '';
1150:
1151: -- Function
1152: l_message := l_message || '

';
1159:
1160: -- Mandatory

Line 1162: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1158: || '';
1159:
1160: -- Mandatory
1161: l_message := l_message || '

';
1168:
1169: -- Results

Line 1171: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1167: || '';
1168:
1169: -- Results
1170: l_message := l_message || '

';
1177:
1178:

'
811: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
812: p_attribute_code => 'OKL_FUND_NUMBER')
813: || '
' || G_AMP_SIGN || 'nbsp;'
815: || r_funding_req.fund_number

Line 818: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

814: || '

'
815: || r_funding_req.fund_number
816: || '
'
818: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
819: p_attribute_code => 'OKL_FUNDING_TYPE')
820: || '
' || G_AMP_SIGN || 'nbsp;'
822: || r_funding_req.funding_type_name

Line 828: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

824: || '

'
828: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
829: p_attribute_code => 'OKL_VENDOR_NAME')
830: || '
' || G_AMP_SIGN || 'nbsp;'
832: || r_funding_req.vendor_name

Line 835: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

831: || '

'
832: || r_funding_req.vendor_name
833: || '
'
835: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
836: p_attribute_code => 'OKL_VENDOR_SITE')
837: || '
' || G_AMP_SIGN || 'nbsp;'
839: || r_funding_req.vendor_site_code

Line 862: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

858: /*
859: -- Funding Number, Funding type
860:
861: l_message := l_message || '

'
862: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
863: p_attribute_code => 'OKL_FUND_NUMBER')
864: || '
'|| G_AMP_SIGN ||'nbsp;' || r_funding_req.fund_number || ' '|| G_AMP_SIGN ||'nbsp;' || r_funding_req.fund_number || ''
868: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
869: p_attribute_code => 'OKL_FUNDING_TYPE')
870: || '
'|| G_AMP_SIGN ||'nbsp;' || r_funding_req.funding_type_name || '
'
878: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
879: p_attribute_code => 'OKL_VENDOR_NAME')
880: || '
'|| G_AMP_SIGN ||'nbsp;' || r_funding_req.vendor_name || ' '|| G_AMP_SIGN ||'nbsp;' || r_funding_req.vendor_name || ''
884: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
885: p_attribute_code => 'OKL_VENDOR_SITE')
886: || '
'|| G_AMP_SIGN ||'nbsp;' || r_funding_req.vendor_site_code || '
'|| G_AMP_SIGN ||'nbsp;
'
899: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
900: p_attribute_code => 'OKL_CURRENCY')
901: || ' = '
902: || r_funding_req.currency_code
903: || '

915:

'
916: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
917: p_attribute_code => 'OKL_FUNDING_DETAILS')
918: || '


919:

Line 932: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

928: -- Funding Total
929: l_message := l_message || '
930:

'
932: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
933: p_attribute_code => 'OKL_AMOUNT')
934: || '
'|| G_AMP_SIGN ||'nbsp;'

Line 937: || OKL_ACCOUNTING_UTIL.format_amount(

933: p_attribute_code => 'OKL_AMOUNT')
934: || '

'|| G_AMP_SIGN ||'nbsp;'
937: || OKL_ACCOUNTING_UTIL.format_amount(
938: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(r_funding_req.id,
939: r_funding_req.funding_type_code),0),
940: r_funding_req.currency_code)
941: || '
'
949: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_SUMMY',
950: p_attribute_code => 'OKL_TOTAL_FUNDED_REMAINING')
951: || '
'|| G_AMP_SIGN ||'nbsp;'

Line 954: || OKL_ACCOUNTING_UTIL.format_amount(

950: p_attribute_code => 'OKL_TOTAL_FUNDED_REMAINING')
951: || '

'|| G_AMP_SIGN ||'nbsp;'
954: || OKL_ACCOUNTING_UTIL.format_amount(
955: NVL(OKL_FUNDING_PVT.get_chr_canbe_funded_rem(r_funding_req.contract_id),0),
956: r_funding_req.currency_code)
957: || '
'|| G_AMP_SIGN ||'nbsp;
'
965: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',
966: p_attribute_code => 'OKL_DATE_DUE')
967: || '
'|| G_AMP_SIGN ||'nbsp;'

Line 986: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT',

982: -- "Contract" Sub Head
983: l_message := l_message || '


985:

'
986: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT',
987: p_attribute_code => 'OKL_CONTRACT')
988: || '


989:

Line 1003: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT',

999: -- Contract Number
1000: l_message := l_message || '
1001:

'
1003: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT',
1004: p_attribute_code => 'OKL_CONTRACT_NUMBER')
1005: || '
'|| G_AMP_SIGN ||'nbsp;'

Line 1017: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',

1013: -- Customer Name
1014: l_message := l_message || '
1015:

'
1017: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',
1018: p_attribute_code => 'OKL_CUSTOMER_NAME')
1019: || '
'|| G_AMP_SIGN ||'nbsp;'

Line 1041: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',

1037: -- "Credit" Sub Head
1038: l_message := l_message || '


1040:

'
1041: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',
1042: p_attribute_code => 'OKL_CREDIT')
1043: || '


1044:

Line 1058: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',

1054: -- Credit line
1055: l_message := l_message || '
1056:

'
1058: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',
1059: p_attribute_code => 'OKL_CREDIT_NUMBER')
1060: || '
'|| G_AMP_SIGN ||'nbsp;'

Line 1072: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',

1068: -- Credit line remaining
1069: l_message := l_message || '
1070:

'
1072: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',
1073: p_attribute_code => 'OKL_REMAINING')
1074: || '
'|| G_AMP_SIGN ||'nbsp;'

Line 1077: || OKL_ACCOUNTING_UTIL.format_amount(

1073: p_attribute_code => 'OKL_REMAINING')
1074: || '

'|| G_AMP_SIGN ||'nbsp;'
1077: || OKL_ACCOUNTING_UTIL.format_amount(
1078: nvl(OKL_SEEDED_FUNCTIONS_PVT.creditline_total_remaining(r_creditline.id),0),
1079: r_creditline.currency_code)
1080: || '
'|| G_AMP_SIGN ||'nbsp;
'
1112: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',
1113: p_attribute_code => 'OKL_CHKLIST_VAL_RESULT')
1114: || '
='
1116: || l_flag

Line 1135: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1131:
1132: -- Headers for the creditline details table.
1133: -- Checklist Item
1134: l_message := l_message || '

'
1138: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1139: p_attribute_code => 'OKL_ITEM')

Line 1138: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1134: l_message := l_message || '

'
1138: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1139: p_attribute_code => 'OKL_ITEM')
1140: || '
'
1147: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1148: p_attribute_code => 'OKL_DESCRIPTION')

Line 1147: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1143: l_message := l_message || '

'
1147: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1148: p_attribute_code => 'OKL_DESCRIPTION')
1149: || '
'
1156: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1157: p_attribute_code => 'OKL_FUNCTION')

Line 1156: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1152: l_message := l_message || '

'
1156: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1157: p_attribute_code => 'OKL_FUNCTION')
1158: || '
'
1165: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1166: p_attribute_code => 'OKL_MANDATORY')

Line 1165: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1161: l_message := l_message || '

'
1165: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1166: p_attribute_code => 'OKL_MANDATORY')
1167: || '
'
1174: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1175: p_attribute_code => 'OKL_RESULTS')

Line 1174: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1170: l_message := l_message || '

'
1174: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1175: p_attribute_code => 'OKL_RESULTS')
1176: || '