eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_QP_QUAL_PVT dependencies on JTF_TERR_ASSIGN_PUB

Line 417: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

413: AND jqtu.source_id = -1003
414: AND jqtu.qual_type_id = -1007;
415:
416: l_party_id NUMBER;
417: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
418: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
419: l_terr_name VARCHAR2(120);
420: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
421:

Line 418: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

414: AND jqtu.qual_type_id = -1007;
415:
416: l_party_id NUMBER;
417: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
418: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
419: l_terr_name VARCHAR2(120);
420: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
421:
422: l_return_status VARCHAR2(1);

Line 668: JTF_TERR_ASSIGN_PUB.get_winners

664: oe_debug_pub.add('Trade MGR: before calling get_winners: county ' || l_trans_rec.SQUAL_CHAR03(1));
665: oe_debug_pub.add('Trade MGR: before calling get_winners: country ' || l_trans_rec.SQUAL_CHAR07(1));
666: oe_debug_pub.add('Trade MGR: before calling get_winners: party_id ' || l_trans_rec.SQUAL_NUM01(1));
667:
668: JTF_TERR_ASSIGN_PUB.get_winners
669: ( p_api_version_number => l_api_version,
670: p_init_msg_list => FND_API.G_TRUE,
671: p_use_type => 'RESOURCE',
672: p_source_id => -1003,

Line 776: l_trx_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

772: WHERE hzcasa.cust_acct_site_id = hzcsua.cust_acct_site_id
773: AND hzcsua.site_use_id = p_ship_to_org_id;
774:
775: l_party_id NUMBER;
776: l_trx_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
777: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
778: l_terr_name VARCHAR2(120);
779: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
780:

Line 777: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

773: AND hzcsua.site_use_id = p_ship_to_org_id;
774:
775: l_party_id NUMBER;
776: l_trx_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
777: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
778: l_terr_name VARCHAR2(120);
779: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
780:
781: l_return_status VARCHAR2(1);

Line 1047: JTF_TERR_ASSIGN_PUB.get_winners

1043: FETCH c_site_use_code INTO l_trx_rec.squal_char17(l_index);
1044: CLOSE c_site_use_code;
1045: END IF;
1046: */
1047: JTF_TERR_ASSIGN_PUB.get_winners
1048: ( p_api_version_number => l_api_version,
1049: p_init_msg_list => FND_API.G_TRUE,
1050: p_use_type => 'RESOURCE',
1051: p_source_id => -1003,

Line 1123: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

1119: AND jqtu.source_id = -1001
1120: AND jqtu.qual_type_id = -1002;
1121:
1122: l_party_id NUMBER;
1123: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1124: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1125: l_terr_name VARCHAR2(120);
1126: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1127:

Line 1124: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

1120: AND jqtu.qual_type_id = -1002;
1121:
1122: l_party_id NUMBER;
1123: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1124: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1125: l_terr_name VARCHAR2(120);
1126: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1127:
1128: l_return_status VARCHAR2(1);

Line 1373: JTF_TERR_ASSIGN_PUB.get_winners

1369: oe_debug_pub.add('Trade MGR SA: before calling get_winners: county ' || l_trans_rec.SQUAL_CHAR03(1));
1370: oe_debug_pub.add('Trade MGR SA: before calling get_winners: country ' || l_trans_rec.SQUAL_CHAR07(1));
1371: oe_debug_pub.add('Trade MGR SA: before calling get_winners: party_id ' || l_trans_rec.SQUAL_NUM01(1));
1372:
1373: JTF_TERR_ASSIGN_PUB.get_winners
1374: ( p_api_version_number => l_api_version,
1375: p_init_msg_list => FND_API.G_TRUE,
1376: p_use_type => 'RESOURCE',
1377: p_source_id => -1001,

Line 1461: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

1457: WHERE hzcasa.cust_acct_site_id = hzcsua.cust_acct_site_id
1458: AND hzcsua.site_use_id = p_ship_to_org_id;
1459:
1460: l_party_id NUMBER;
1461: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1462: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1463: l_terr_name VARCHAR2(120);
1464: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1465:

Line 1462: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

1458: AND hzcsua.site_use_id = p_ship_to_org_id;
1459:
1460: l_party_id NUMBER;
1461: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1462: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1463: l_terr_name VARCHAR2(120);
1464: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1465:
1466: l_return_status VARCHAR2(1);

Line 1709: JTF_TERR_ASSIGN_PUB.get_winners

1705: OPEN c_party_site_id(p_ship_to_org);
1706: FETCH c_party_site_id INTO l_trans_rec.SQUAL_NUM02(1);
1707: CLOSE c_party_site_id;
1708:
1709: JTF_TERR_ASSIGN_PUB.get_winners
1710: ( p_api_version_number => l_api_version,
1711: p_init_msg_list => FND_API.G_TRUE,
1712: p_use_type => 'RESOURCE',
1713: p_source_id => -1001,