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 414: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

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

Line 415: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

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

Line 665: JTF_TERR_ASSIGN_PUB.get_winners

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

Line 773: l_trx_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

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

Line 774: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

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

Line 1044: JTF_TERR_ASSIGN_PUB.get_winners

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

Line 1120: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

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

Line 1121: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

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

Line 1370: JTF_TERR_ASSIGN_PUB.get_winners

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

Line 1458: l_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

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

Line 1459: l_winner_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

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

Line 1706: JTF_TERR_ASSIGN_PUB.get_winners

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