APPS.PV_PARTNER_ATTR_LOAD_PUB dependencies on PV_ENTY_ATTR_VALUE_PUB

Line 58: l_attr_value_table PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

54: l_dec_pts number;
55:
56: l_no_format varchar2(30) := null;
57:
58: l_attr_value_table PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
59:
60: l_out_val_table PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
61:
62: l_v1_row pls_integer;

Line 60: l_out_val_table PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

56: l_no_format varchar2(30) := null;
57:
58: l_attr_value_table PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
59:
60: l_out_val_table PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
61:
62: l_v1_row pls_integer;
63: l_v2_row pls_integer;
64:

Line 761: l_attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type; --attr_values_tbl_type;

757: l_has_partner_type varchar2(1);
758: l_has_member_type varchar2(1);
759: l_is_subsidiary varchar2(1);
760: l_attribute_details_tbl attr_details_tbl_type;
761: l_attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type; --attr_values_tbl_type;
762: l_party_id number;
763: l_partner_id number;
764: l_partner_name varchar2(360);
765: l_gbl_orig_system varchar2(30);

Line 769: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

765: l_gbl_orig_system varchar2(30);
766: l_gbl_orig_system_ref varchar2(255);
767: l_gbl_party_id number;
768: l_gbl_partner_id number;
769: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
770: l_partner_member_type varchar2(500);
771: l_member_type varchar2(500);
772: l_default_resp_id NUMBER;
773: l_resp_map_rule_id NUMBER;

Line 1112: l_attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type; --attr_values_tbl_type;

1108: l_has_partner_type varchar2(1);
1109: l_has_member_type varchar2(1);
1110: l_new_partner_type varchar2(500);
1111: l_attribute_details_tbl attr_details_tbl_type;
1112: l_attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type; --attr_values_tbl_type;
1113: l_partner_id number;
1114: l_current_partner_type varchar2(500);
1115:
1116:

Line 1413: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

1409: ) IS
1410:
1411: l_bound NUMBER;
1412: u_bound NUMBER;
1413: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
1414: l_attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type; --attr_values_tbl_type;
1415: l_attribute_id NUMBER;
1416: l_version NUMBER;
1417:

Line 1414: l_attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type; --attr_values_tbl_type;

1410:
1411: l_bound NUMBER;
1412: u_bound NUMBER;
1413: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
1414: l_attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type; --attr_values_tbl_type;
1415: l_attribute_id NUMBER;
1416: l_version NUMBER;
1417:
1418: l_return_status VARCHAR2(1);

Line 1536: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (

1532: IF NOT (p_mode = 'CREATE' AND (l_attribute_id = 3 or l_attribute_id = 6)) THEN
1533: If l_attribute_id <> 19 then
1534: --dbms_output.put_line('Calling upsert for : ' || l_attribute_id);
1535: --dbms_output.put_line('ATTR VALUE EXTN: ' || l_partner_types_tbl(1).attr_value_extn);
1536: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
1537: p_api_version_number=> 1.0
1538: ,p_init_msg_list => FND_API.g_true
1539: ,p_commit => FND_API.g_false
1540: ,p_validation_level => FND_API.g_valid_level_full