APPS.PON_AUCTION_PKG dependencies on FND_TERRITORIES

Line 3774: l_auctioneer_nls_territory fnd_territories.nls_territory%TYPE;

3770: x_territory_code VARCHAR2(30) := 'AMERICA';
3771: x_nls_territory VARCHAR2(60);
3772:
3773: l_auctioneer_nls_language fnd_languages.nls_language%TYPE;
3774: l_auctioneer_nls_territory fnd_territories.nls_territory%TYPE;
3775:
3776:
3777: CURSOR new_bidders IS
3778: select pbp.trading_partner_contact_name,

Line 3828: from fnd_territories

3824: from fnd_languages
3825: where language_code = x_language_code;
3826:
3827: select nls_territory into l_auctioneer_nls_territory
3828: from fnd_territories
3829: where territory_code = x_territory_code;
3830:
3831: FOR bidder IN new_bidders LOOP
3832:

Line 3924: from fnd_territories

3920: from fnd_languages
3921: where language_code = x_language_code;
3922:
3923: select nls_territory into x_nls_territory
3924: from fnd_territories
3925: where territory_code = x_territory_code;
3926: exception
3927: when others then
3928: x_nls_language := 'AMERICAN';

Line 6703: from fnd_territories

6699: from fnd_languages
6700: where language_code = x_language_code;
6701:
6702: select nls_territory into x_nls_territory
6703: from fnd_territories
6704: where territory_code = x_territory_code;
6705:
6706: open c1_auction_type;
6707: fetch c1_auction_type

Line 7097: from fnd_territories

7093: from fnd_languages
7094: where language_code = x_language_code;
7095:
7096: select nls_territory into x_nls_addnl_territory
7097: from fnd_territories
7098: where territory_code = x_territory_code;
7099:
7100:
7101: WF_DIRECTORY.CreateAdHocUser(x_additional_user_name,