DBA Data[Home] [Help]

APPS.QP_QP_FORM_PRICING_ATTR dependencies on QP_LIST_HEADERS_B

Line 1629: ( p_list_header_id IN qp_list_headers_b.list_header_id%type

1625:
1626: END Get_Pricing_Phase;
1627:
1628: FUNCTION Get_Charge_name
1629: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
1630: , p_Charge_Type_code IN QP_CHARGE_LOOKUP.lookup_code%type
1631: , p_Charge_Subtype_code IN QP_LOOKUPS.lookup_code%type
1632: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1633: )

Line 1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');

1632: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1633: )
1634: RETURN QP_LOOKUPS.Meaning%Type IS
1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;
1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
1637: l_profile_pte_code qp_list_headers_b.pte_code%type := fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
1638: l_source_system_code qp_list_headers_b.source_system_code%type;
1639: l_pte_code qp_list_headers_b.pte_code%type;
1640: BEGIN

Line 1637: l_profile_pte_code qp_list_headers_b.pte_code%type := fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');

1633: )
1634: RETURN QP_LOOKUPS.Meaning%Type IS
1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;
1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
1637: l_profile_pte_code qp_list_headers_b.pte_code%type := fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
1638: l_source_system_code qp_list_headers_b.source_system_code%type;
1639: l_pte_code qp_list_headers_b.pte_code%type;
1640: BEGIN
1641:

Line 1638: l_source_system_code qp_list_headers_b.source_system_code%type;

1634: RETURN QP_LOOKUPS.Meaning%Type IS
1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;
1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
1637: l_profile_pte_code qp_list_headers_b.pte_code%type := fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
1638: l_source_system_code qp_list_headers_b.source_system_code%type;
1639: l_pte_code qp_list_headers_b.pte_code%type;
1640: BEGIN
1641:
1642: IF p_list_line_type_code = 'FREIGHT_CHARGE' THEN

Line 1639: l_pte_code qp_list_headers_b.pte_code%type;

1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;
1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
1637: l_profile_pte_code qp_list_headers_b.pte_code%type := fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
1638: l_source_system_code qp_list_headers_b.source_system_code%type;
1639: l_pte_code qp_list_headers_b.pte_code%type;
1640: BEGIN
1641:
1642: IF p_list_line_type_code = 'FREIGHT_CHARGE' THEN
1643: