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 25: g_bg_tbl qp_attr_mapping_pub.t_multirecord;

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

Line 61: px_bg_tbl IN OUT NOCOPY qp_attr_mapping_pub.t_multirecord)

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

Line 136: RETURN qp_attr_mapping_pub.t_MultiRecord IS

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

Line 137: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;

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

Line 209: RETURN qp_attr_mapping_pub.t_MultiRecord IS

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

Line 210: l_bg_tbl qp_attr_mapping_pub.t_multirecord ;

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

Line 281: RETURN qp_attr_mapping_pub.t_MultiRecord IS

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

Line 283: l_mks_tbl qp_attr_mapping_pub.t_multirecord ;

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

Line 331: RETURN qp_attr_mapping_pub.t_MultiRecord IS

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

Line 333: l_tgt_tbl qp_attr_mapping_pub.t_multirecord ;

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

Line 387: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

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

Line 420: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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

Line 719: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

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

Line 779: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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

Line 1093: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

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

Line 1126: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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

Line 1425: ) RETURN Qp_Attr_Mapping_Pub.t_multirecord

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

Line 1464: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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

Line 1785: RETURN Qp_Attr_Mapping_Pub.t_multirecord

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

Line 1787: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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

Line 1805: RETURN Qp_Attr_Mapping_Pub.t_multirecord

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

Line 1807: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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

Line 1825: RETURN Qp_Attr_Mapping_Pub.t_multirecord

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

Line 1827: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

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