DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on JTF_TERR_ASSIGN_PUB

Line 2423: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;

2419: l_count NUMBER;
2420: l_party_name VARCHAR2 (360);
2421: l_country_code VARCHAR2 (60);
2422: l_state_code VARCHAR2 (120);
2423: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
2424: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
2425: l_use_type VARCHAR2 (30);
2426: l_msg_count NUMBER;
2427: l_derived_res_id NUMBER;

Line 2424: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;

2420: l_party_name VARCHAR2 (360);
2421: l_country_code VARCHAR2 (60);
2422: l_state_code VARCHAR2 (120);
2423: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
2424: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
2425: l_use_type VARCHAR2 (30);
2426: l_msg_count NUMBER;
2427: l_derived_res_id NUMBER;
2428: l_resource_id NUMBER;

Line 16793: x_winners_rec OUT NOCOPY jtf_terr_assign_pub.bulk_winners_rec_type,

16789:
16790: PROCEDURE get_jtf_resource (
16791: p_authorg_id NUMBER,
16792: p_party_id NUMBER,
16793: x_winners_rec OUT NOCOPY jtf_terr_assign_pub.bulk_winners_rec_type,
16794: x_msg_count OUT NOCOPY NUMBER,
16795: x_msg_data OUT NOCOPY VARCHAR2,
16796: x_return_status OUT NOCOPY VARCHAR2
16797: )

Line 16817: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;

16813: AND hzs.party_id = hz.party_id
16814: AND hzs.identifying_address_flag = 'Y'
16815: AND hzl.location_id = hzs.location_id;
16816:
16817: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
16818: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
16819: l_party_name VARCHAR2 (360);
16820: l_country_code VARCHAR2 (60);
16821: l_state_code VARCHAR2 (120);

Line 16818: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;

16814: AND hzs.identifying_address_flag = 'Y'
16815: AND hzl.location_id = hzs.location_id;
16816:
16817: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
16818: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
16819: l_party_name VARCHAR2 (360);
16820: l_country_code VARCHAR2 (60);
16821: l_state_code VARCHAR2 (120);
16822: l_use_type VARCHAR2 (30);

Line 16882: || '.JTF_TERR_ASSIGN_PUB.get_winners',

16878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
16879: THEN
16880: fnd_log.STRING (fnd_log.level_statement,
16881: g_module_current
16882: || '.JTF_TERR_ASSIGN_PUB.get_winners',
16883: 'Before JTF API call '
16884: );
16885: END IF;
16886:

Line 16887: jtf_terr_assign_pub.get_winners

16883: 'Before JTF API call '
16884: );
16885: END IF;
16886:
16887: jtf_terr_assign_pub.get_winners
16888: (p_api_version_number => 1.0,
16889: p_init_msg_list => okc_api.g_false,
16890: p_use_type => l_use_type,
16891: p_source_id => -1500,

Line 16909: || '.JTF_TERR_ASSIGN_PUB.get_winners',

16905: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
16906: THEN
16907: fnd_log.STRING (fnd_log.level_statement,
16908: g_module_current
16909: || '.JTF_TERR_ASSIGN_PUB.get_winners',
16910: 'After JTF call '
16911: );
16912: END IF;
16913: END get_jtf_resource;