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

Line 407: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu, jtf_qual_type_usgs jqtu

403:
404: CURSOR cur_is_terr_setup IS
405: SELECT /*+ ORDERED */ -- julou sql performance fix
406: count(*)
407: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu, jtf_qual_type_usgs jqtu
408: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
409: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
410: jt.end_date_active IS NULL ))
411: AND jt.terr_id = jtqu.terr_id

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 433: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);

429: --apps.FND_MSG_PUB.initialize;
430: l_return_status := Fnd_Api.g_ret_sts_success;
431:
432: -- territory rec
433: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
434: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
435:
436: -- extend qualifier elements
437: l_trans_rec.SQUAL_NUM01.EXTEND;

Line 434: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);

430: l_return_status := Fnd_Api.g_ret_sts_success;
431:
432: -- territory rec
433: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
434: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
435:
436: -- extend qualifier elements
437: l_trans_rec.SQUAL_NUM01.EXTEND;
438: l_trans_rec.SQUAL_NUM02.EXTEND;

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 760: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu, jtf_qual_type_usgs jqtu

756: */
757: CURSOR cur_is_terr_setup IS
758: SELECT /*+ ORDERED */ -- julou sql performance fix
759: count(*)
760: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu, jtf_qual_type_usgs jqtu
761: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
762: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
763: jt.end_date_active IS NULL ))
764: AND jt.terr_id = jtqu.terr_id

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 791: l_trx_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);

787: --apps.FND_MSG_PUB.initialize;
788: l_return_status := Fnd_Api.g_ret_sts_success;
789:
790: -- territory rec
791: l_trx_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
792: l_trx_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
793:
794: -- extend qualifier elements
795: l_trx_rec.SQUAL_NUM01.EXTEND;

Line 792: l_trx_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);

788: l_return_status := Fnd_Api.g_ret_sts_success;
789:
790: -- territory rec
791: l_trx_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
792: l_trx_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
793:
794: -- extend qualifier elements
795: l_trx_rec.SQUAL_NUM01.EXTEND;
796: l_trx_rec.SQUAL_NUM02.EXTEND;

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 1113: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu,jtf_qual_type_usgs jqtu

1109:
1110: CURSOR cur_is_terr_setup IS
1111: SELECT /*+ ORDERED */ -- julou sql performance fix
1112: count(*)
1113: FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu,jtf_qual_type_usgs jqtu
1114: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
1115: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
1116: jt.end_date_active IS NULL ))
1117: AND jt.terr_id = jtqu.terr_id

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 1139: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);

1135: --apps.FND_MSG_PUB.initialize;
1136: l_return_status := Fnd_Api.g_ret_sts_success;
1137:
1138: -- territory rec
1139: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
1140: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
1141:
1142: -- extend qualifier elements
1143: l_trans_rec.SQUAL_NUM01.EXTEND;

Line 1140: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);

1136: l_return_status := Fnd_Api.g_ret_sts_success;
1137:
1138: -- territory rec
1139: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
1140: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
1141:
1142: -- extend qualifier elements
1143: l_trans_rec.SQUAL_NUM01.EXTEND;
1144: l_trans_rec.SQUAL_NUM02.EXTEND;

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 1445: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu,jtf_qual_type_usgs jqtu

1441:
1442: CURSOR cur_is_terr_setup IS
1443: SELECT /*+ ORDERED */ -- julou sql performance fix
1444: count(*)
1445: FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu,jtf_qual_type_usgs jqtu
1446: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
1447: ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
1448: jt.end_date_active IS NULL ))
1449: AND jt.terr_id = jtqu.terr_id

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 1477: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);

1473: --apps.FND_MSG_PUB.initialize;
1474: l_return_status := Fnd_Api.g_ret_sts_success;
1475:
1476: -- territory rec
1477: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
1478: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
1479:
1480: -- extend qualifier elements
1481: l_trans_rec.SQUAL_NUM01.EXTEND;

Line 1478: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);

1474: l_return_status := Fnd_Api.g_ret_sts_success;
1475:
1476: -- territory rec
1477: l_trans_rec.trans_object_id := JTF_TERR_NUMBER_LIST(null);
1478: l_trans_rec.trans_detail_object_id := JTF_TERR_NUMBER_LIST(null);
1479:
1480: -- extend qualifier elements
1481: l_trans_rec.SQUAL_NUM01.EXTEND;
1482: l_trans_rec.SQUAL_NUM02.EXTEND;

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,