DBA Data[Home] [Help]

APPS.JA_CN_AB_EXP_PKG dependencies on FND_GLOBAL

Line 264: l_na_curr_req_id := FND_GLOBAL.CONC_REQUEST_ID;

260: (end_date BETWEEN l_start_date AND l_end_date))
261: ORDER BY start_date;
262:
263: BEGIN
264: l_na_curr_req_id := FND_GLOBAL.CONC_REQUEST_ID;
265: --log the parameters
266: IF (l_procedure_level >= l_runtime_level) THEN
267:
268: FND_LOG.STRING(l_procedure_level,

Line 922: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

918: END IF;*/
919:
920: FND_FILE.put_line(FND_FILE.output,
921: '"' || l_account_balances_gbl_tmp_row.account_segment --account number
922: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
923: l_account_balances_gbl_tmp_row.currency_code --currency
924: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
925: JA_CN_JE_EXP_PKG.Get_Subsidiary_Desc(p_cost_center => l_account_balances_gbl_tmp_row.cost_center,
926: p_third_party_number => l_account_balances_gbl_tmp_row.third_party_number,

Line 924: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

920: FND_FILE.put_line(FND_FILE.output,
921: '"' || l_account_balances_gbl_tmp_row.account_segment --account number
922: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
923: l_account_balances_gbl_tmp_row.currency_code --currency
924: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
925: JA_CN_JE_EXP_PKG.Get_Subsidiary_Desc(p_cost_center => l_account_balances_gbl_tmp_row.cost_center,
926: p_third_party_number => l_account_balances_gbl_tmp_row.third_party_number,
927: p_personnel_number => l_account_balances_gbl_tmp_row.personnel_number,
928: p_project_number => l_account_balances_gbl_tmp_row.project_number,

Line 933: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||

929: p_has_cost_center => l_account_balances_gbl_tmp_row.has_cost_center,
930: p_has_third_party => l_account_balances_gbl_tmp_row.has_third_party,
931: p_has_personnel => l_account_balances_gbl_tmp_row.has_personnel,
932: p_has_project => l_account_balances_gbl_tmp_row.has_project) --subsidiary account group
933: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
934: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_begin_balance,
935: 0),
936: '99999999999999999990.99')) --opening balance
937: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --opening quantity

Line 937: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --opening quantity

933: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
934: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_begin_balance,
935: 0),
936: '99999999999999999990.99')) --opening balance
937: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --opening quantity
938: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
939: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_begin_balance,
940: 0),
941: '99999999999999999990.99')) --opening foreign currency balance

Line 938: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

934: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_begin_balance,
935: 0),
936: '99999999999999999990.99')) --opening balance
937: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --opening quantity
938: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
939: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_begin_balance,
940: 0),
941: '99999999999999999990.99')) --opening foreign currency balance
942: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 942: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

938: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
939: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_begin_balance,
940: 0),
941: '99999999999999999990.99')) --opening foreign currency balance
942: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
943: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_period_net_dr,
944: 0),
945: '999999999999999990.99')) --period debit amount
946: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --period debit quantity

Line 946: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --period debit quantity

942: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
943: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_period_net_dr,
944: 0),
945: '999999999999999990.99')) --period debit amount
946: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --period debit quantity
947: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
948: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_period_net_dr,
949: 0),
950: '999999999999999990.99')) --period foreign currency debit amount

Line 947: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

943: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_period_net_dr,
944: 0),
945: '999999999999999990.99')) --period debit amount
946: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --period debit quantity
947: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
948: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_period_net_dr,
949: 0),
950: '999999999999999990.99')) --period foreign currency debit amount
951: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 951: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

947: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
948: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_period_net_dr,
949: 0),
950: '999999999999999990.99')) --period foreign currency debit amount
951: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
952: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_period_net_cr,
953: 0),
954: '999999999999999990.99')) --period credit amount
955: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --preiod credit quantity

Line 955: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --preiod credit quantity

951: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
952: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_period_net_cr,
953: 0),
954: '999999999999999990.99')) --period credit amount
955: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --preiod credit quantity
956: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
957: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_period_net_cr,
958: 0),
959: '999999999999999990.99')) --period foreign currency credit amount

Line 956: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

952: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_period_net_cr,
953: 0),
954: '999999999999999990.99')) --period credit amount
955: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --preiod credit quantity
956: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
957: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_period_net_cr,
958: 0),
959: '999999999999999990.99')) --period foreign currency credit amount
960: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 960: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

956: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
957: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_period_net_cr,
958: 0),
959: '999999999999999990.99')) --period foreign currency credit amount
960: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
961: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_end_balance,
962: 0),
963: '99999999999999999990.99')) --closing balance
964: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --closing quantity

Line 964: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --closing quantity

960: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
961: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_end_balance,
962: 0),
963: '99999999999999999990.99')) --closing balance
964: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --closing quantity
965: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
966: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_end_balance,
967: 0),
968: '99999999999999999990.99')) --closing foreign currency balance

Line 965: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

961: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.func_end_balance,
962: 0),
963: '99999999999999999990.99')) --closing balance
964: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.00' --closing quantity
965: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
966: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_end_balance,
967: 0),
968: '99999999999999999990.99')) --closing foreign currency balance
969: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

Line 969: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

965: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
966: TRIM(to_char(nvl(l_account_balances_gbl_tmp_row.orig_end_balance,
967: 0),
968: '99999999999999999990.99')) --closing foreign currency balance
969: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
970: TRIM(to_char(l_account_balances_gbl_tmp_row.period_mon,
971: '09')) --accounting month
972: || '"');
973: END IF; --if JA_CN_UTILITY.Check_Account_Level(l_account_balances_gbl_tmp_row.balance_side)