APPS.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on AMW_FIN_KEY_ACCOUNTS_TL

Line 1668: --accounts_tl_record AMW_FIN_KEY_ACCOUNTS_TL%rowtype;

1664: SOURCE_LANGUAGE VARCHAR2(4) );
1665:
1666: accounts_tl_record accounts_tl;
1667:
1668: --accounts_tl_record AMW_FIN_KEY_ACCOUNTS_TL%rowtype;
1669: TYPE get_accdesc_cursor IS ref CURSOR ;
1670: Get_acc_names_external_apps get_accdesc_cursor;
1671:
1672:

Line 1920: -- cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_TL

1916: X_LAST_UPDATE_LOGIN in NUMBER,
1917: X_CREATION_DATE DATE,
1918: X_CREATED_BY in NUMBER
1919: ) is
1920: -- cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_TL
1921: -- where ACCOUNT_GROUP_ID = X_ACCOUNT_GROUP_ID ;
1922: var_NATURAL_ACCOUNT_ID number;
1923: begin
1924:

Line 1927: from AMW_FIN_KEY_ACCOUNTS_TL

1923: begin
1924:
1925: select
1926: NATURAL_ACCOUNT_ID into var_NATURAL_ACCOUNT_ID
1927: from AMW_FIN_KEY_ACCOUNTS_TL
1928: where ACCOUNT_GROUP_ID = X_ACCOUNT_GROUP_ID AND
1929: NATURAL_ACCOUNT_ID = X_NATURAL_ACCOUNT_ID AND
1930: LANGUAGE = X_LANGUAGE;
1931: EXCEPTION

Line 1934: insert into AMW_FIN_KEY_ACCOUNTS_TL (

1930: LANGUAGE = X_LANGUAGE;
1931: EXCEPTION
1932: WHEN NO_DATA_FOUND THEN
1933:
1934: insert into AMW_FIN_KEY_ACCOUNTS_TL (
1935: ACCOUNT_GROUP_ID,
1936: NATURAL_ACCOUNT_ID,
1937: NAME,
1938: LANGUAGE,

Line 2116: --cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_TL

2112: X_LAST_UPDATE_LOGIN in NUMBER,
2113: X_CREATION_DATE DATE,
2114: X_CREATED_BY in NUMBER
2115: ) is
2116: --cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_TL
2117: -- where ACCOUNT_GROUP_ID = X_ACCOUNT_GROUP_ID;
2118:
2119: var_STATEMENT_ID number ;
2120: begin

Line 2322: --cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_TL

2318: X_LAST_UPDATE_LOGIN in NUMBER,
2319: X_CREATION_DATE DATE,
2320: X_CREATED_BY in NUMBER
2321: ) is
2322: --cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_TL
2323: -- where ACCOUNT_GROUP_ID = X_ACCOUNT_GROUP_ID;
2324:
2325: var_ITEM_ID NUMBER;
2326: begin