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 QP_ATTR_MAPPING_PUB

Line 22: g_bg_tbl qp_attr_mapping_pub.t_multirecord;

18: ------------------------------------------------------------------------------
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_QP_QUAL_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12):='ozfvqpqb.pls';
22: g_bg_tbl qp_attr_mapping_pub.t_multirecord;
23: g_total NUMBER := 1 ;
24: g_rel_type VARCHAR2(30) := FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE');
25:
26:

Line 58: px_bg_tbl IN OUT NOCOPY qp_attr_mapping_pub.t_multirecord)

54: --------------- end of comments ----------------------------
55:
56: PROCEDURE get_all_parents(aso_party_id IN NUMBER,
57: om_sold_to_org IN NUMBER,
58: px_bg_tbl IN OUT NOCOPY qp_attr_mapping_pub.t_multirecord)
59: IS
60:
61: p_party_id NUMBER;
62: l_party_id NUMBER;

Line 133: RETURN qp_attr_mapping_pub.t_MultiRecord IS

129: --
130: --------------- end of comments ----------------------------
131:
132: FUNCTION get_buying_groups(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
133: RETURN qp_attr_mapping_pub.t_MultiRecord IS
134: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;
135:
136: p_party_id NUMBER;
137: l_party_id NUMBER;

Line 134: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;

130: --------------- end of comments ----------------------------
131:
132: FUNCTION get_buying_groups(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
133: RETURN qp_attr_mapping_pub.t_MultiRecord IS
134: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;
135:
136: p_party_id NUMBER;
137: l_party_id NUMBER;
138:

Line 206: RETURN qp_attr_mapping_pub.t_MultiRecord IS

202: -- End of Comments
203: --
204: --------------- end of comments ----------------------------
205: FUNCTION get_buying_groups(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER,ic_party_id IN NUMBER)
206: RETURN qp_attr_mapping_pub.t_MultiRecord IS
207: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;
208:
209: p_party_id NUMBER;
210: l_party_id NUMBER;

Line 207: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;

203: --
204: --------------- end of comments ----------------------------
205: FUNCTION get_buying_groups(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER,ic_party_id IN NUMBER)
206: RETURN qp_attr_mapping_pub.t_MultiRecord IS
207: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;
208:
209: p_party_id NUMBER;
210: l_party_id NUMBER;
211:

Line 278: RETURN qp_attr_mapping_pub.t_MultiRecord IS

274: -- End of Comments
275: --
276: --------------- end of comments ----------------------------
277: FUNCTION get_segments(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
278: RETURN qp_attr_mapping_pub.t_MultiRecord IS
279:
280: l_mks_tbl qp_attr_mapping_pub.t_multirecord ;
281:
282: p_party_id number;

Line 280: l_mks_tbl qp_attr_mapping_pub.t_multirecord ;

276: --------------- end of comments ----------------------------
277: FUNCTION get_segments(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
278: RETURN qp_attr_mapping_pub.t_MultiRecord IS
279:
280: l_mks_tbl qp_attr_mapping_pub.t_multirecord ;
281:
282: p_party_id number;
283:
284: CURSOR c_mks IS

Line 328: RETURN qp_attr_mapping_pub.t_MultiRecord IS

324: --- julou Created
325: --
326: --------------- end of comments ----------------------------
327: FUNCTION get_lists(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
328: RETURN qp_attr_mapping_pub.t_MultiRecord IS
329:
330: l_tgt_tbl qp_attr_mapping_pub.t_multirecord ;
331:
332: p_party_id number;

Line 330: l_tgt_tbl qp_attr_mapping_pub.t_multirecord ;

326: --------------- end of comments ----------------------------
327: FUNCTION get_lists(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
328: RETURN qp_attr_mapping_pub.t_MultiRecord IS
329:
330: l_tgt_tbl qp_attr_mapping_pub.t_multirecord ;
331:
332: p_party_id number;
333:
334: CURSOR c_mks IS

Line 384: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

380: FUNCTION Find_TM_Territories
381: (
382: p_party_id IN NUMBER
383: ,p_sold_to_org IN NUMBER
384: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord
385: IS
386:
387: l_api_version CONSTANT NUMBER := 1.0;
388: l_api_name CONSTANT VARCHAR2(30) := 'Find_TM_Territories';

Line 417: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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);
420: l_msg_data VARCHAR2(2000);
421: l_msg_count NUMBER;

Line 716: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

712: p_party_id IN NUMBER
713: ,p_sold_to_org IN NUMBER
714: ,p_ship_to_org IN NUMBER
715: ,p_bill_to_org IN NUMBER
716: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord
717: IS
718:
719: l_api_version CONSTANT NUMBER := 1.0;
720: l_api_name CONSTANT VARCHAR2(30) := 'Find_TM_Territories';

Line 776: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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);
779: l_msg_data VARCHAR2(2000);
780: l_msg_count NUMBER;

Line 1090: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

1086: FUNCTION Find_SA_Territories
1087: (
1088: p_party_id IN NUMBER
1089: ,p_sold_to_org IN NUMBER
1090: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord
1091: IS
1092:
1093: l_api_version CONSTANT NUMBER := 1.0;
1094: l_api_name CONSTANT VARCHAR2(30) := 'Find_SA_Territories';

Line 1123: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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);
1126: l_msg_data VARCHAR2(2000);
1127: l_msg_count NUMBER;

Line 1422: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

1418: p_party_id IN NUMBER
1419: ,p_sold_to_org IN NUMBER
1420: ,p_ship_to_org IN NUMBER
1421: ,p_bill_to_org IN NUMBER
1422: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord
1423: IS
1424:
1425: l_api_version CONSTANT NUMBER := 1.0;
1426: l_api_name CONSTANT VARCHAR2(30) := 'Find_SA_Territories';

Line 1461: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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);
1464: l_msg_data VARCHAR2(2000);
1465: l_msg_count NUMBER;

Line 1782: RETURN Qp_Attr_Mapping_Pub.t_multirecord

1778: FUNCTION get_distributor_lists
1779: (
1780: p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
1781: )
1782: RETURN Qp_Attr_Mapping_Pub.t_multirecord
1783: IS
1784: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1785: l_distributor_acct_id NUMBER;
1786: BEGIN

Line 1784: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

1780: p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
1781: )
1782: RETURN Qp_Attr_Mapping_Pub.t_multirecord
1783: IS
1784: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1785: l_distributor_acct_id NUMBER;
1786: BEGIN
1787: IF p_resale_line_tbl.COUNT > 0 THEN
1788: l_distributor_acct_id := p_resale_line_tbl(1).sold_from_cust_account_id;

Line 1802: RETURN Qp_Attr_Mapping_Pub.t_multirecord

1798: FUNCTION get_distributor_segments
1799: (
1800: p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
1801: )
1802: RETURN Qp_Attr_Mapping_Pub.t_multirecord
1803: IS
1804: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1805: l_distributor_acct_id NUMBER;
1806: BEGIN

Line 1804: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

1800: p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
1801: )
1802: RETURN Qp_Attr_Mapping_Pub.t_multirecord
1803: IS
1804: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1805: l_distributor_acct_id NUMBER;
1806: BEGIN
1807: IF p_resale_line_tbl.COUNT > 0 THEN
1808: l_distributor_acct_id := p_resale_line_tbl(1).sold_from_cust_account_id;

Line 1822: RETURN Qp_Attr_Mapping_Pub.t_multirecord

1818: FUNCTION get_distributor_territories
1819: (
1820: p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
1821: )
1822: RETURN Qp_Attr_Mapping_Pub.t_multirecord
1823: IS
1824: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1825: l_distributor_acct_id NUMBER;
1826: l_ship_to_org_id NUMBER;

Line 1824: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

1820: p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
1821: )
1822: RETURN Qp_Attr_Mapping_Pub.t_multirecord
1823: IS
1824: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
1825: l_distributor_acct_id NUMBER;
1826: l_ship_to_org_id NUMBER;
1827: BEGIN
1828: IF p_resale_line_tbl.COUNT > 0 THEN