APPS.JA_CN_COA_EXP_PKG dependencies on FND_GLOBAL

Line 444: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';

440: JA_CN_INCOMPLETE_DFF_ASSIGN exception;
441: JA_CN_INVALID_ACCOUNT_STRU exception;
442: l_msg_incomplete_dff_assign varchar2(2000);
443: l_msg_invalid_account_stru varchar2(2000);
444: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
445:
446: l_na_curr_req_id NUMBER; --Request id of current request
447: l_xml_layout boolean;
448: l_template_language VARCHAR2(10) := P_XML_TEMPLATE_LANGUAGE;

Line 757: l_na_curr_req_id := FND_GLOBAL.CONC_REQUEST_ID; --id of current request

753:
754: --4. Go through all the natural accounts with a natural number marked in
755: -- "Level" field and lists all invalid accounts in invalid account table
756: -- JA_CN_COA_NA_EXCEPTION.
757: l_na_curr_req_id := FND_GLOBAL.CONC_REQUEST_ID; --id of current request
758:
759: OPEN c_na_info;
760: LOOP -- Loop for all natural accounts
761: FETCH c_na_info INTO l_na_number

Line 808: ,fnd_global.user_id

804: ,l_length
805: ,l_expected_length
806: ,l_na_acc_str
807: ,l_na_curr_req_id
808: ,fnd_global.user_id
809: ,SYSDATE
810: ,fnd_global.user_id
811: ,SYSDATE
812: ,fnd_global.LOGIN_ID

Line 810: ,fnd_global.user_id

806: ,l_na_acc_str
807: ,l_na_curr_req_id
808: ,fnd_global.user_id
809: ,SYSDATE
810: ,fnd_global.user_id
811: ,SYSDATE
812: ,fnd_global.LOGIN_ID
813: );
814: END IF; --Value length

Line 812: ,fnd_global.LOGIN_ID

808: ,fnd_global.user_id
809: ,SYSDATE
810: ,fnd_global.user_id
811: ,SYSDATE
812: ,fnd_global.LOGIN_ID
813: );
814: END IF; --Value length
815: END IF; --Account Level should not null and be a natural number and <16
816: END LOOP;

Line 1118: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';

1114: l_proc_name VARCHAR2(100) :='Coa_PJ_Export';
1115:
1116: l_ledger_id NUMBER := P_LEDGER_ID;
1117: l_le_id NUMBER := P_LE_ID;
1118: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
1119:
1120: /*JA_CN_PROJ_NOT_CONSIDER exception;
1121: --JA_CN_NO_PROJ_DEFINED exception;
1122: l_msg_proj_not_consider varchar2(2000);

Line 1335: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';

1331:
1332: l_ledger_id NUMBER := P_LEDGER_ID; -- LEDGER ID
1333: l_le_id NUMBER := P_LE_ID; -- LEGAL ENTITY ID
1334: l_coa_id NUMBER := P_COA_ID; -- CHART OF ACCOUT ID
1335: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
1336:
1337: l_sup_meaning VARCHAR2(50);
1338: l_cust_meaning VARCHAR2(50);
1339:

Line 1800: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';

1796:
1797: l_ledger_id NUMBER := P_LEDGER_ID;
1798: l_le_id NUMBER := P_LE_ID;
1799: l_coa_id NUMBER := P_COA_ID;
1800: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
1801:
1802: l_row_count NUMBER; --count of rows
1803: l_cc_number JA_CN_ACCOUNT_BALANCES.cost_center%TYPE;
1804: l_cc_name FND_FLEX_VALUES_TL.description%TYPE;

Line 1936: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';

1932:
1933: l_ledger_id NUMBER := P_LEDGER_ID;
1934: l_le_id NUMBER := P_LE_ID;
1935: l_coa_id NUMBER := P_COA_ID;
1936: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
1937:
1938: l_row_count NUMBER; --count of rows
1939: l_person_number JA_CN_ACCOUNT_BALANCES.personnel_number%TYPE;
1940: l_person_name VARCHAR2(50);