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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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,