APPS.PON_AUCTION_PKG dependencies on FND_TERRITORIES

Line 4340: l_auctioneer_nls_territory fnd_territories.nls_territory%TYPE;

4336: x_territory_code VARCHAR2(30) := 'AMERICA';
4337: x_nls_territory VARCHAR2(60);
4338:
4339: l_auctioneer_nls_language fnd_languages.nls_language%TYPE;
4340: l_auctioneer_nls_territory fnd_territories.nls_territory%TYPE;
4341: l_users WF_DIRECTORY.UserTable;
4342:
4343: CURSOR new_bidders IS
4344: select pbp.trading_partner_contact_name,

Line 4394: from fnd_territories

4390: from fnd_languages
4391: where language_code = x_language_code;
4392:
4393: select nls_territory into l_auctioneer_nls_territory
4394: from fnd_territories
4395: where territory_code = x_territory_code;
4396:
4397: FOR bidder IN new_bidders LOOP
4398:

Line 4497: from fnd_territories

4493: from fnd_languages
4494: where language_code = x_language_code;
4495:
4496: select nls_territory into x_nls_territory
4497: from fnd_territories
4498: where territory_code = x_territory_code;
4499: exception
4500: when others then
4501: x_nls_language := 'AMERICAN';

Line 7312: from fnd_territories

7308: from fnd_languages
7309: where language_code = x_language_code;
7310:
7311: select nls_territory into x_nls_territory
7312: from fnd_territories
7313: where territory_code = x_territory_code;
7314:
7315: open c1_auction_type;
7316: fetch c1_auction_type

Line 7735: from fnd_territories

7731: from fnd_languages
7732: where language_code = x_language_code;
7733:
7734: select nls_territory into x_nls_addnl_territory
7735: from fnd_territories
7736: where territory_code = x_territory_code;
7737:
7738:
7739: WF_DIRECTORY.CreateAdHocUser(x_additional_user_name,