DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CSI_INSTALL_PARAMETERS

Line 7899: --select internal_party_id from csi_install_parameters,

7895: CLOSE C_SRC_CHANGE_OWNER;
7896:
7897: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
7898: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
7899: --select internal_party_id from csi_install_parameters,
7900: SELECT internal_party_id into l_internal_party_id
7901: FROM csi_install_parameters WHERE rownum = 1;
7902:
7903: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,

Line 7901: FROM csi_install_parameters WHERE rownum = 1;

7897: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
7898: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
7899: --select internal_party_id from csi_install_parameters,
7900: SELECT internal_party_id into l_internal_party_id
7901: FROM csi_install_parameters WHERE rownum = 1;
7902:
7903: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,
7904: p_party_id => l_internal_party_id,
7905: x_msg_data => l_msg_data,

Line 8150: --select internal_party_id from csi_install_parameters,

8146: --DBMS_OUTPUT.PUT_LINE('l_src_change_owner'||l_src_change_owner);
8147:
8148: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
8149: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
8150: --select internal_party_id from csi_install_parameters,
8151: SELECT internal_party_id into l_internal_party_id
8152: FROM csi_install_parameters WHERE rownum = 1;
8153:
8154: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,

Line 8152: FROM csi_install_parameters WHERE rownum = 1;

8148: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
8149: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
8150: --select internal_party_id from csi_install_parameters,
8151: SELECT internal_party_id into l_internal_party_id
8152: FROM csi_install_parameters WHERE rownum = 1;
8153:
8154: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,
8155: p_party_id => l_internal_party_id,
8156: x_msg_data => l_msg_data,

Line 8430: --select internal_party_id from csi_install_parameters,

8426: CLOSE C_SRC_CHANGE_OWNER;
8427:
8428: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
8429: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
8430: --select internal_party_id from csi_install_parameters,
8431: SELECT internal_party_id into l_internal_party_id
8432: FROM csi_install_parameters;
8433:
8434: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,

Line 8432: FROM csi_install_parameters;

8428: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
8429: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
8430: --select internal_party_id from csi_install_parameters,
8431: SELECT internal_party_id into l_internal_party_id
8432: FROM csi_install_parameters;
8433:
8434: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,
8435: p_party_id => l_internal_party_id,
8436: x_msg_data => l_msg_data,

Line 8652: --select internal_party_id from csi_install_parameters,

8648: CLOSE C_SRC_CHANGE_OWNER;
8649:
8650: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
8651: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
8652: --select internal_party_id from csi_install_parameters,
8653: SELECT internal_party_id into l_internal_party_id
8654: FROM csi_install_parameters;
8655:
8656: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,

Line 8654: FROM csi_install_parameters;

8650: If (l_src_change_owner = 'N') or (l_src_change_owner is null) THEN
8651: --Pass the internal_party_id to the existing "IS_INSTANCE_VALID" method.
8652: --select internal_party_id from csi_install_parameters,
8653: SELECT internal_party_id into l_internal_party_id
8654: FROM csi_install_parameters;
8655:
8656: l_valid_check := IS_INSTANCE_VALID( p_instance_id => p_charges_detail_rec.customer_product_id,
8657: p_party_id => l_internal_party_id,
8658: x_msg_data => l_msg_data,