DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on JTF_TERR_ASSIGN_PUB

Line 2472: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;

2468: l_count NUMBER;
2469: l_party_name VARCHAR2 (360);
2470: l_country_code VARCHAR2 (60);
2471: l_state_code VARCHAR2 (120);
2472: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
2473: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
2474: l_use_type VARCHAR2 (30);
2475: l_msg_count NUMBER;
2476: l_derived_res_id NUMBER;

Line 2473: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;

2469: l_party_name VARCHAR2 (360);
2470: l_country_code VARCHAR2 (60);
2471: l_state_code VARCHAR2 (120);
2472: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
2473: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
2474: l_use_type VARCHAR2 (30);
2475: l_msg_count NUMBER;
2476: l_derived_res_id NUMBER;
2477: l_resource_id NUMBER;

Line 17091: x_winners_rec OUT NOCOPY jtf_terr_assign_pub.bulk_winners_rec_type,

17087:
17088: PROCEDURE get_jtf_resource (
17089: p_authorg_id NUMBER,
17090: p_party_id NUMBER,
17091: x_winners_rec OUT NOCOPY jtf_terr_assign_pub.bulk_winners_rec_type,
17092: x_msg_count OUT NOCOPY NUMBER,
17093: x_msg_data OUT NOCOPY VARCHAR2,
17094: x_return_status OUT NOCOPY VARCHAR2
17095: )

Line 17115: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;

17111: AND hzs.party_id = hz.party_id
17112: AND hzs.identifying_address_flag = 'Y'
17113: AND hzl.location_id = hzs.location_id;
17114:
17115: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
17116: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
17117: l_party_name VARCHAR2 (360);
17118: l_country_code VARCHAR2 (60);
17119: l_state_code VARCHAR2 (120);

Line 17116: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;

17112: AND hzs.identifying_address_flag = 'Y'
17113: AND hzl.location_id = hzs.location_id;
17114:
17115: l_gen_bulk_rec jtf_terr_assign_pub.bulk_trans_rec_type;
17116: l_gen_return_rec jtf_terr_assign_pub.bulk_winners_rec_type;
17117: l_party_name VARCHAR2 (360);
17118: l_country_code VARCHAR2 (60);
17119: l_state_code VARCHAR2 (120);
17120: l_use_type VARCHAR2 (30);

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

17176: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
17177: THEN
17178: fnd_log.STRING (fnd_log.level_statement,
17179: g_module_current
17180: || '.JTF_TERR_ASSIGN_PUB.get_winners',
17181: 'Before JTF API call '
17182: );
17183: END IF;
17184:

Line 17185: jtf_terr_assign_pub.get_winners

17181: 'Before JTF API call '
17182: );
17183: END IF;
17184:
17185: jtf_terr_assign_pub.get_winners
17186: (p_api_version_number => 1.0,
17187: p_init_msg_list => okc_api.g_false,
17188: p_use_type => l_use_type,
17189: p_source_id => -1500,

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

17203: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
17204: THEN
17205: fnd_log.STRING (fnd_log.level_statement,
17206: g_module_current
17207: || '.JTF_TERR_ASSIGN_PUB.get_winners',
17208: 'After JTF call '
17209: );
17210: END IF;
17211: END get_jtf_resource;